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.

Symptoms

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),
   SUM(entered_cr),

   SUM(accounted_dr),
   SUM(accounted_cr),
   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

Cause

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