My Oracle Support Banner

R12: AP: APList Diagnostic Fails on Java Heap Error (Doc ID 1667064.1)

Last updated on DECEMBER 04, 2019

Applies to:

Oracle E-Business Suite Diagnostics - Version 12.1.3 and later
Information in this document applies to any platform.
APList Diagnostic Fails on Java Heap Error

ODX-0060: SQL has not been executed as table or view does not exist (ORA-00942 returned)
Error executing element "sql" with the name "SQL_115_AX" Error in the sql statement: "SELECT event_id FROM AX_EVENTS WHERE application_id = 200 AND event_type like 'NON_CASH%' AND event_field1 = :1 AND NVL(org_id, -99)= :2 UNION SELECT event_id FROM AX_EVENTS WHERE application_id = 200 AND ( event_type like 'CASH%' OR event_type like 'FUTURE%' ) AND event_field1 IN ( SELECT check_id FROM AP_INVOICE_PAYMENTS_ALL WHERE invoice_id = :3 ) AND NVL(org_id, -99) = :4" with the bind values: "'XXXX', 'XX', 'XXXXXX', 'XX'".

ERROR - ODX-0467: Unable to execute the if expression due to invalid variable in test attribute: $SQL_115_AX.
ACTION - If the XML file for this test was delivered by Oracle Support Services, contact the support representative for assistance
General Ledger


Tried running diagnostic, which fails with 'Test aborted. No downloadable report got generated.'

Log file generated on server $INST_TOP/logs/oam/diagnostics/logs following error is noticed.

java.lang.OutOfMemoryError: Java heap space
at java.lang.String.toCharArray(
at oracle.apps.fnd.oam.diagnostics.dao.LogDAO.insertLegacyReport(
at oracle.apps.fnd.oam.diagnostics.exec.LegacyTestExecution.insertReport(
at oracle.apps.fnd.oam.diagnostics.exec.LegacyJavaTestExecution.execute(

so i uploaded this file and the OD_report log file generated by the diag request




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.