Bad Performance In Create Accounting
(Doc ID 1333173.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle Cost Management - Version 12.1.1 and later Information in this document applies to any platform.
Symptoms
On : 12.1.1 version, Subledger Accounting
When attempting to run the Create Accounting -Cost Management the performance is unacceptable. Create Accounting in Cost Management SLA responsibility its taking about 30 hours to finish
The bad performing sql is the LINES's cursor 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 .. FROM XLA_EVENTS_GT XET , CST_XLA_INV_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
STEPS ----------------------- The issue can be reproduced at will with the following steps: 1. Go to SLA -Cost Management Responsibility 2. Run the request Create Accounting
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!
