GL Drill Down to Inventory Hangs (Doc ID 746260.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

 
When Drilldown button is pressed for inventory journals, system just halts.

EXPECTED BEHAVIOR
Expect system to take to the relevant details in a short time

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. General Ledger >> Inquiry>>Account>>Drilldown.

Trace file leads to

SELECT TRX_CLASS_NAME,TRX_TYPE_NAME,TRX_NUMBER_DISPLAYED,TRX_DATE,COMMENTS, DOC_SEQUENCE_N...........................
FROM
XLA_AEL_GL_V WHERE 1=2 ..............

is consuming most of the resource and the costliest query.

Cause

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