Oracle Apps Frequent Errors and Solutions

10-may-2013

------------

1) Error in Report while generating .XMl file.

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1401: '': Fatal PL/SQL error occurred.

Solution

---------

1) It shows this error because in formula column I wrote end if before RETURN clause.

So i wrote end if after the return clause then it will compile successfully

13-may-2013

-------------

2) Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert to number

This was occurred when I click the preview in rtf.

Solution

---------

2) Used to_number (String)

3) Routine FDPREP cannot read the file /oraapp/ERP/apps/apps_st/appl/ar/12.0.0/reports/US/    XXST_AR_INV_INTER.rep.

Check if the file exists under correct product directory.

Solution

------------

3) In above error observe carefully there is a space in front of .rep file name. Means in executable remove space and

Save

4) Enter Password:

REP-0004: Warning: Unable to open user preference file.

REP-1316: After Report Trigger references column 'inv_max' at wrong frequency.

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1316: After Report Trigger references column 'inv_max' at wrong frequency.

Solution

------------

4) Here inv_max is in group in RDF data model but I took this field or formula column or summary column in after report trigger

So this error occurs what I do is I created that field (summary column) in report level not group level so it was rectified.

07-Jun-2013

------------

5) Enter Password:

REP-0004: Warning: Unable to open user preference file.

REP-1401: 'cf_vend_nameformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1401: 'cf_vend_nameformula': Fatal PL/SQL error occurred.

ORA-06502: PL/SQL: numeric or value error

Solution

----------

5) This error occurred because that formula column has a number data type but it returns varchar values

So I changed data type as char and size 100 then submit report works fine.

07-06-2013

----------

6) Enter Password:

REP-0004: Warning: Unable to open user preference file.

REP-1416: 'beforereport': User exit 'FND'. IAF GET: unknown column 'P_CONC_REQUEST_ID'.

REP-0069: Internal error

REP-57054: In-process job terminated: Terminated with error:

REP-1416: 'beforereport': User exit 'FND'. IAF GET: unknown column 'P_CONC_REQUEST_ID'.

Solution

---------

6) Whenever we use user exits in report without creating P_CONC_REQUEST_ID parameter then this error will occur.

Action

------

To achieve this error you should create P_CONC_REQUEST_ID in user parameters of your report.

19-Jun-2013

-------------------

Error

--------

REP-0091: Invalid value for parameter 'P_VENDOR_NAME'.

 

Solution

------------

This error occurred because in rdf P_VENDOR_NAME parameter having only 40 size but value maximum is 58 so it occurred.

Action

---------

Increase that width to 100  then it will solve