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

FRM-41072: cannot create group FRM-41827: Group Does not exist.

Hi for below error

FRM-41072: cannot create group <Group Name>
FRM-41827: Group Does not exist.

Solution
----------------
If it will occur at the time of changing or restricting LOV then follow below procedure.

First open the form and place cursor on field which have list of values in drop down

then go to help diagnostics examine
give system
        current block


then it shows block name this was the Data Block Name in our .fmb file.

in same form go to help--> About oracle applications

here we can see the form name. i.e our .fmb name it should be in AU_TOP

so get that .fmb and open through Form Builder

here we can click on our Data block then click on Items

select our field which is having list of values then press F4

here we can see the LOV name.


then go to LOV in the same form builder down

then right click on our LOV here copy the query and paste it into TOAD or Sql Developer

Made changes in where condition what ever we require. Dont change columns and names.

Then go to frontend form and help-->diagnistics-->custom code --> form personalize

here give sequence and name and function

below select WHEN NEW FORM INSTANCE

then click on actions

10  Builtin              All                                                 Create Record Group from query:
paste your query here. and in the group name give some name i.e. XX_GRP.( As your like)

20  Property         All                                                Object Type - LOV
                                                                                Target Object - select your LOV name here
                                                                                 Property Name - GROUP_NAME
                                                                        Value - give the new record group name here i.e. XX_GRP.

By doing above procedure as it is sometimes getting error so what we will do that time is

just done all changes and save and validate and validate all dont click on Apply Now.

now close the form and re open now we can see restricted lov.



Hope this helps.

Thanks,
Jagadekara Reddy.