My Oracle Support Banner

Performance issue with Create Accounting - Receiving (Doc ID 2717112.1)

Last updated on OCTOBER 05, 2020

Applies to:

Oracle Purchasing - Version 12.2.6 and later
Information in this document applies to any platform.

Symptoms

Performance issue with Create Accounting - Receiving

Slow performing SQL

 

SELECT /*+ leading(xet) cardinality(xet,1) */ XET.ENTITY_ID ,
  XET.LEGAL_ENTITY_ID ,XET.ENTITY_CODE ,XET.TRANSACTION_NUMBER ,XET.EVENT_ID
,
  XET.EVENT_CLASS_CODE ,XET.EVENT_TYPE_CODE ,XET.EVENT_NUMBER ,XET.EVENT_DATE

  ,XET.TRANSACTION_DATE ,XET.REFERENCE_NUM_1 ,XET.REFERENCE_NUM_2 ,
  XET.REFERENCE_NUM_3 ,XET.REFERENCE_NUM_4 ,XET.REFERENCE_CHAR_1 ,
  XET.REFERENCE_CHAR_2 ,XET.REFERENCE_CHAR_3 ,XET.REFERENCE_CHAR_4 ,
  XET.REFERENCE_DATE_1 ,XET.REFERENCE_DATE_2 ,XET.REFERENCE_DATE_3 ,
  XET.REFERENCE_DATE_4 ,XET.EVENT_CREATED_BY ,XET.BUDGETARY_CONTROL_FLAG ,
  L2.LINE_NUMBER , L2.CODE_COMBINATION_ID SOURCE_5 ,
  L2.DISTRIBUTION_IDENTIFIER SOURCE_13 , L2.ENTERED_AMOUNT SOURCE_20 ,
  L2.ACCOUNTED_AMOUNT SOURCE_24 , L2.RCV_ACCOUNTING_LINE_TYPE SOURCE_29
FROM
 XLA_EVENTS_GT XET , CST_XLA_RCV_LINES_V L2 WHERE XET.EVENT_ID BETWEEN :B5
  AND :B4 AND XET.EVENT_DATE BETWEEN :B3 AND :B2 AND XET.EVENT_CLASS_CODE =
  :B1 AND XET.EVENT_STATUS_CODE <> 'N' AND L2.EVENT_ID = XET.EVENT_ID

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.