Tuesday, August 25, 2015

Frequent Errors in Oracle Reports

Frequent Errors in Oracle apps




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.

17-Jun-2013
-------------------
Error:

Solution
------------
Use errbuf and retcode in procedure because those are mandatory parameters.

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 widthto100 like below then it will solve.

 

20-Jun-2013
-------------------
Error
--------
Enter Password: 
REP-0004: Warning: Unable to open user preference file.
MSG-01001: You have not defined your system parameters or your installation is incomplete.
REP-1419: 'beforereport': PL/SQL program aborted.
REP-0069: Internal error
REP-57054: In-process job terminated: Terminated with error: 
REP-1419: MSG-01001: You have not defined your system parameters or your installation is incomplete.
REP-1419: 'beforereport': PL/SQL program aborted.
 
Solution
-----------
In Rdf Before Report Trigger if we forgot to give any Procedure/Parameter then this error will occurred.
26-Jun-2013
-------------------
Error
--------

ORA-28115: policy with check option violation occurred in package(package name)

Solution                                                                                                                                             
=======
This error occurred when I call the standard package AP_AID_TABLE_HANDLER_PKG.INSERT_ROW
To insert data into ap_invoice_distributions_all.

While inserting into base table it will validate data. So if your data does not satisfy validations then this error occurred.


Action
======

Check the data if any validations violated then rectify it and insert through That API then it will get success.


10-Jul-2013
==========
Error:
--SQLException
java.sql.SQLSyntaxErrorException: ORA-01790: expression must have same datatype as corresponding expression
 
               at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
               at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
               at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
               at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
               at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
               at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
               at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205)
               at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861)
               at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145)
               at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267)
               at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)
               at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493)
               at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491)
               at oracle.apps.xdo.dataengine.XMLPGEN.processQuery(XMLPGEN.java:1947)
               at oracle.apps.xdo.dataengine.XMLPGEN.processSQLDataSource(XMLPGEN.java:501)
               at oracle.apps.xdo.dataengine.XMLPGEN.writeData(XMLPGEN.java:445)
               at oracle.apps.xdo.dataengine.XMLPGEN.writeGroupStructure(XMLPGEN.java:308)
               at oracle.apps.xdo.dataengine.XMLPGEN.processData(XMLPGEN.java:273)
               at oracle.apps.xdo.dataengine.XMLPGEN.processXML(XMLPGEN.java:215)
               at oracle.apps.xdo.dataengine.XMLPGEN.writeXML(XMLPGEN.java:254)
               at oracle.apps.xdo.dataengine.DataProcessor.processDataStructre(DataProcessor.java:390)
               at oracle.apps.xdo.dataengine.DataProcessor.processData(DataProcessor.java:355)
               at oracle.apps.xdo.oa.util.DataTemplate.processData(DataTemplate.java:334)
               at oracle.apps.xdo.oa.cp.JCP4XDODataEngine.runProgram(JCP4XDODataEngine.java:294)
               at oracle.apps.fnd.cp.request.Run.main(Run.java:157)
 

Solution
=========

In ,xml file there are 4 queries used by joining with union all.
So one of that have different data type. But in my query both are date data types.
But one query having just date column name and one query have like this….
to_char(jpr.accounting_date,'YYYY-MM-DD"T"hh:mi:ss')

So this error occurred.

Action
=====

In all queries I used to_char for that column then it was rectified and completed normal.



10-Jul-2013
==========
Error:

After creating adhoc roles in workflow getting below error second time run.

Error Name WF_DUP_ROLE

Error Message 395: Duplicate role



Action
----------
Hai,
comment below code then it will give any error.                              wf_directory.CreateAdHocRole(role_name => ,                                                                            role_display_name =>);                                                          wf_directory.AddUsersToAdHocRole(role_name => ' '                                                                                    , role_users => ' ' );because once you created role and assigned to user then no need to do it again and again. so comment that code and check it.



31-Jul-2013
------------------- 
Error: ORA-01861 Literal does not match format string

Solution:  Problem with date format.

In valuset I used below condition.

and to_char(payment_date) between to_char(:$FLEX$.FND_STANDARD_DATE) and to_char(:$FLEX$.FND_STANDARD_DATE1)


Here fnd_standard_date1 returns date format as “'YYYY/MM/DD HH24:MI:SS'” so it cause this error.




Action
----------

So finally I used like this then was worked fine.

and to_char(payment_date,'YYYY/MM/DD HH24:MI:SS') between to_char(:$FLEX$.FND_STANDARD_DATE) and to_char(:$FLEX$.FND_STANDARD_DATE1)

No comments:

Post a Comment

Clear BNE Cache for WebADI Changes

It Sometime happens that WebAdi Changes doesn't reflect once migrated in controlled instances. Here are the quick steps(Generally perfor...