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
