GL Drill Down to Inventory Hangs
Last updated on NOVEMBER 05, 2016
Applies to:Oracle Cost Management - Version 18.104.22.168 to 22.214.171.124 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms