R12: PA: View Accounting From Menu Bar For A Single Project Expenditure Item Takes Hours And Fails
Last updated on MARCH 08, 2017
Applies to:Oracle Project Costing - Version 12.1.2 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.
View Accounting from Menu Bar for a single Project expenditure item takes hours and fails.
When Navigating to the Expenditure item screen for a project, querying a project and date range, and selecting a specific expenditure item, when clicking on View Accounting from the menu bar, the drilldown runs for hours before returning and in most cases times out.
The expensive SQL is:
COUNT(DISTINCT currency_code) FROM XLA_PA_EI_AEL_SL_V WHERE
application_id = :l_appl_id AND set_of_books_id = :l_sob_id
AND trx_hdr_table = :l_trx_hdr_table AND trx_hdr_id = :l_trx_hdr_id
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