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

Last updated on MARCH 15, 2022

Applies to:

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

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