GL Drill Down to Inventory Hangs
(Doc ID 746260.1)
Last updated on NOVEMBER 05, 2016
Applies to:Oracle Cost Management - Version 22.214.171.124 to 126.96.36.199 [Release 11.5]
Information in this document applies to any platform.
When Drilldown button is pressed for inventory journals, system just halts.
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...........................
XLA_AEL_GL_V WHERE 1=2 ..............
is consuming most of the resource and the costliest query.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!