My Oracle Support Banner

CMCACW Actual Cost Worker Poor Performance - Full Table Scan - Mtl_Material_Transactions (Doc ID 1121023.1)

Last updated on FEBRUARY 09, 2018

Applies to:

Oracle Cost Management - Version 12.0.0 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

The actual cost worker, CMCACW,  is performing poorly.  Actual Cost Transaction Worker is doing a Full Table Scan on MTL_MATERIAL_TRANSACTIONS on the following query.

update MTL_MATERIAL_TRANSACTIONS
set COSTED_FLAG=null , TRANSACTION_GROUP_ID=null , REQUEST_ID=:b0
where TRANSACTION_TYPE_ID=99

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!


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