My Oracle Support Banner

The Performance of Resource Cost Worker Gets Worse (Doc ID 2749206.1)

Last updated on FEBRUARY 02, 2021

Applies to:

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

Symptoms

Actual Behavior
The performance of Resource Cost Worker gets worse.
The following sql statement takes almost time.
UPDATE WIP_COST_TXN_INTERFACE wti
SET
last_update_date = SYSDATE,
last_update_login = :login_id,
request_id = :req_id,
program_application_id = :appl_id,
program_id = :prog_id,
program_update_date = SYSDATE,
wti.BASIS_TYPE =
(SELECT NVL(WOR.BASIS_TYPE,BR.DEFAULT_BASIS_TYPE)
FROM WIP_OPERATION_RESOURCES WOR,
BOM_RESOURCES BR,
WIP_COST_TXN_INTERFACE WTI2
WHERE BR.RESOURCE_ID = WTI.RESOURCE_ID
AND BR.ORGANIZATION_ID = WTI.ORGANIZATION_ID
AND WTI2.GROUP_ID = WTI.GROUP_ID
AND WTI2.TRANSACTION_ID = WTI.TRANSACTION_ID
AND WOR.WIP_ENTITY_ID(+) = WTI2.WIP_ENTITY_ID
AND WOR.OPERATION_SEQ_NUM(+) = WTI2.OPERATION_SEQ_NUM
AND WOR.RESOURCE_SEQ_NUM(+) = WTI2.RESOURCE_SEQ_NUM
AND WOR.ORGANIZATION_ID(+) = WTI2.ORGANIZATION_ID
AND NVL(WOR.REPETITIVE_SCHEDULE_ID(+),-1) =
NVL(WTI2.REPETITIVE_SCHEDULE_ID,-1))
WHERE wti.group_id = :group_id
AND wti.process_phase = 1
AND wti.process_status = 2
AND NOT EXISTS
(SELECT 'X'
FROM WIP_TXN_INTERFACE_ERRORS err
WHERE wti.transaction_id = err.transaction_id
AND err.error_column IN ( :colname, 'RESOURCE_CODE',
'RESOURCE_ID', 'OPERATION_SEQ_NUM', 'REPETITIVE_SCHEDULE_ID',
'WIP_ENTITY_NAME', 'LINE_ID', 'LINE_CODE', 'ENTITY_TYPE', 'WIP_ENTITY_ID',
'ORGANIZATION_ID', 'ORGANIZATION_CODE', 'RESOURCE_SEQ_NUM', NULL ))

Expected Behavior
The performance of Resource Cost Worker is good.

Steps to Reproduce

  1. Run Cost Manager

Changes

Upgrade to 12.2.9 from 12.1.3

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.