R12 PRC: Create Accounting Warning "Ready To Enqueue Documents In The Queue" (Doc ID 2107708.1)

Last updated on AUGUST 01, 2016

Applies to:

Oracle Project Costing - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Accounting

ACTUAL BEHAVIOR
---------------
The PRC: Create Accounting process performance is slow and take more than two hours to complete. The most expensive query is:

SELECT /*+ leading (gl,xdl,ael,aeh,xaca,xad,xpap) index(xdl
  XLA_DISTRIBUTION_LINKS_N1) USE_NL (gl,xdl,ael,aeh,xaca,xad,xpap) */
  CODE_COMBINATION_ID
FROM
 XLA_DISTRIBUTION_LINKS XDL, XLA_AE_HEADERS AEH, XLA_AE_LINES AEL,
  XLA_ACCT_CLASS_ASSGNS XACA, XLA_ASSIGNMENT_DEFNS_B XAD,
  XLA_POST_ACCT_PROGS_B XPAP, GL_LEDGERS GL WHERE
  XDL.SOURCE_DISTRIBUTION_ID_NUM_1 = :B7 AND
  NVL(XDL.SOURCE_DISTRIBUTION_ID_NUM_2, -99) = TO_NUMBER(NVL(:B6 , -99)) AND
  XDL.SOURCE_DISTRIBUTION_TYPE = :B5 AND XDL.APPLICATION_ID = :B4 AND
  XDL.AE_HEADER_ID = AEH.AE_HEADER_ID AND XDL.AE_LINE_NUM = AEL.AE_LINE_NUM
  AND XDL.AE_HEADER_ID = AEL.AE_HEADER_ID AND AEH.APPLICATION_ID =
  AEL.APPLICATION_ID AND AEL.APPLICATION_ID = XDL.APPLICATION_ID AND
  AEH.BALANCE_TYPE_CODE = 'A' AND AEH.ACCOUNTING_ENTRY_STATUS_CODE = 'F' AND
  AEH.LEDGER_ID = :B3 AND AEL.ACCOUNTING_CLASS_CODE =
  XACA.ACCOUNTING_CLASS_CODE AND XACA.PROGRAM_CODE = XAD.PROGRAM_CODE AND
  XACA.PROGRAM_OWNER_CODE = XAD.PROGRAM_OWNER_CODE AND XAD.PROGRAM_CODE =
  XPAP.PROGRAM_CODE AND XPAP.PROGRAM_OWNER_CODE = 'S' AND
  XACA.ASSIGNMENT_CODE = XAD.ASSIGNMENT_CODE AND XACA.ASSIGNMENT_OWNER_CODE =
  XAD.ASSIGNMENT_OWNER_CODE AND (XAD.LEDGER_ID IS NULL OR XAD.LEDGER_ID = :B3
  ) AND XAD.ENABLED_FLAG = 'Y' AND GL.LEDGER_ID = :B3 AND XPAP.PROGRAM_CODE =
  DECODE ( XACA.ACCOUNTING_CLASS_CODE , 'DISCOUNT' , DECODE(
  GL.SLA_LEDGER_CASH_BASIS_FLAG, 'Y', DECODE ( :B2 , 'CREDIT',
  'PA_POSTACCOUNTING_DEBIT', 'DEBIT', '' ) ,:B1 ), 'ACCRUAL' , DECODE ( :B2 ,
  'CREDIT', '', 'DEBIT', 'PA_POSTACCOUNTING_CREDIT' ) ,:B1 ) AND
  XPAP.APPLICATION_ID = 275 AND ((XDL.ACCOUNTING_LINE_TYPE_CODE = 'S' AND
  ROWNUM = 1) OR ROWNUM = 1)


EXPECTED BEHAVIOR
-----------------------
Customer expects the process to complete in 10 minutes or less

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit the process
2. Performance is over 2 hours

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the process in an acceptable amount of time.

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