R12: AP: APList Diagnostic Fails on Java Heap Error
(Doc ID 1667064.1)
Last updated on JUNE 10, 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
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
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