My Oracle Support Banner

Create Accounting In Cost Management Poor Performance Even After Patch 13441975:R12.BOM.C (Doc ID 1451109.1)

Last updated on MARCH 19, 2019

Applies to:

Oracle Cost Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On :  12.1.3 version, Cost Groups

ACTUAL BEHAVIOR  
---------------
Create Accounting process in Cost Management is taking about 24 hours to complete in Production.We are running Create Accounting - Cost Management program to transfer entries to GL  from inventory, costing and WIP.

However Accounting program is running for long time

Applied Patch 12898461:R12.BOM.C CREATE ACCOUNTING - COST MANAGEMENT PROGRAM PERFORMANCE PROBLEM
and 13441975:R12.BOM.C POOR PERFORMANCE IN ACCOUNTING PERIOD END ACCRUAL EVEN AFTER PATCH 12882091

cstcxla.odf 120.67.12010000.32

Create accounting launched the accounting program  hangs


Found that below query is running for past 10hrs and nothing is happening

 
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 , H3.APPLIED_TO_APPL_ID SOURCE_6 , H3.APPLIED_TO_DIST_LINK_TYPE SOURCE_7 , H3.APPLIED_TO_ENTITY_CODE SOURCE_8 , H3.APPLIED_TO_PO_DOC_ID SOURCE_10 , H1.DISTRIBUTION_TYPE SOURCE_12 , FVL12.MEANING SOURCE_12_MEANING , H4.PO_BUDGET_ACCOUNT SOURCE_13 , H3.ENCUM_REVERSAL_AMOUNT_ENTERED SOURCE_14 , H3.ENCUMBRANCE_REVERSAL_AMOUNT SOURCE_16 , H5.PURCH_ENCUMBRANCE_TYPE_ID SOURCE_23 , H6.CST_ENCUM_UPG_OPTION SOURCE_27 , H3.TXN_PO_DISTRIBUTION_ID SOURCE_28 , H1.TRANSFER_TO_GL_INDICATOR SOURCE_34 , FVL34.MEANING SOURCE_34_MEANING
FROM XLA_EVENTS_GT XET , CST_XLA_INV_HEADERS_V H1 , CST_XLA_INV_REF_V H3 , PO_DISTS_REF_V H4 , PO_HEADERS_REF_V H5 , PSA_CST_XLA_UPG_V H6 , FND_LOOKUP_VALUES FVL12 , FND_LOOKUP_VALUES FVL34
WHERE XET.EVENT_DATE BETWEEN :B3 AND :B2 AND XET.EVENT_CLASS_CODE = :B1 AND XET.EVENT_STATUS_CODE <> 'N' AND H1.EVENT_ID = XET.EVENT_ID AND H3.REF_TRANSACTION_ID = H1.TRANSACTION_ID AND H3.TXN_PO_HEADER_ID = H4.PO_HEADER_ID (+) AND H3.TXN_PO_DISTRIBUTION_ID = H4.PO_DISTRIBUTION_ID (+) AND H3.TXN_PO_HEADER_ID = H5.PO_HEADER_ID (+) AND H3.RCV_TRANSACTION_ID = H6.TRANSACTION_ID (+) AND FVL12.LOOKUP_TYPE(+) = 'CST_DISTRIBUTION_TYPE' AND FVL12.LOOKUP_CODE(+) = H1.DISTRIBUTION_TYPE AND FVL12.VIEW_APPLICATION_ID(+) = 700 AND FVL12.LANGUAGE(+) = USERENV('LANG') AND FVL34.LOOKUP_TYPE(+) = 'YES_NO' AND FVL34.LOOKUP_CODE(+) = H1.TRANSFER_TO_GL_INDICATOR AND FVL34.VIEW_APPLICATION_ID(+) = 0 AND FVL34.LANGUAGE(+) = USERENV('LANG') ORDER BY EVENT_ID

 


EXPECTED BEHAVIOR
-----------------------
Expect better response time from the Create Accounting concurrent program.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Cost Management application,
2. Submit requests screen
3. Submit Create Accounting - Cost Management program (or use N/SLA/Create Accounting navigation to submit the program).

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
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.