CMCACW Actual Cost Worker Poor Performance - Full Table Scan - Mtl_Material_Transactions

(Doc ID 1121023.1)

Last updated on FEBRUARY 27, 2017

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.
***Checked for relevance 21-May-2014***

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

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 hundreds of Community platforms