ORA-06502: PL/SQL: numeric or value error: NULL index table key value,ORA-06512: at "APPS.FA_RX_PUBLISH", line 2153.

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem:
On : 11.5.10.2 version, Reports Issues

When attempting to run report for Unapplied Receipts Journal ,
the following error occurs.

ERROR
-----------------------
One or more post-processing actions failed. Consult the OPP service log for details.

Error executing cursor.
ORA-06502: PL/SQL: numeric or value error: NULL index table key value
ORA-06512: at "APPS.FA_RX_PUBLISH", line 2153.

Symptoms:
Go to AR receivable manager responsibility.
View menu request->single request and run the below reports.

1) Unapplied Receipts Journal
2) Unapplied and Unresolved Receipts Register

Log files:
See the following error: One or more post-processing actions failed. Consult the OPP service log for details.

Filename = FNDOPP94524.txt
See the following:
Caused by: oracle.xdo.parser.v2.XMLParseException: Start of root element expected.
at oracle.xdo.parser.v2.XMLError.flushErrors1(XMLError.java:324)
at oracle.xdo.parser.v2.NonValidatingParser.parseRootElement(NonValidatingParser.java:319)
at oracle.xdo.parser.v2.NonValidatingParser.parseDocument(NonValidatingParser.java:281)
at oracle.xdo.parser.v2.XMLParser.parse(XMLParser.java:266)
... 17 more


Solution:



Issue may be caused due to insufficient memory and incorrect setups in XML Publisher
please follow the action plan in a test environment:
1.
Navigation Path : XML Publisher Administration responsibility
-> Tab : Administration
-> Configuration
-> Properties
-> General
-> Temporary Directory
.
Please specify a directory that has plenty of space.

-> Tab : Data Definition
-> Search for the data definition:
Name: Subledger Period Close Exceptions Report
Application: Subledger Accounting
-> View the data definition
-> On the View Data Definition page, click on the Edit Configuration button (similar
navigation path for Templates)
-> Properties
-> FO Processing
.
2.
Set the following:
Use XML Publisher's XSLT processor = TRUE
Enable scalable feature of XSLT processor = TRUE

3.
Please change the Output for the ARXSGPO and ARXSGP concurrent programs to XML and save
(Sysadmin\Concurrent\Program\Define). Both programs need to be set to XML

4.
Restart the Concurrent Managers


References:

Note 869522.1: Statement Generation Program ending in XDOException "java.lang.reflect.InvocationTargetException".

Get Oracle Certifications for all Exams
Free Online Exams.com