My Oracle Support Banner

R12: PA: View Accounting From Menu Bar For A Single Project Expenditure Item Takes Hours And Fails (Doc ID 1485702.1)

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:

 SELECT  SUM(entered_dr),

  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


To view full details, 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 a vibrant support community of peers and Oracle experts.