CMCTCM Cost Manager Is Not Spawning Cost Workers and not Processing Transactions (Doc ID 1271025.1)

Last updated on OCTOBER 10, 2016

Applies to:

Oracle Cost Management - Version 11.5.10.0 and later
Information in this document applies to any platform.
Form:WIPTXRSC.FMB - Resource Transactions
Form:INVTVTXN.FMB - View Transactions
Form:WIPTISFM.FMB - Move Transactions Interface
Form:INVTVTMP.FMB - View Pending Transactions


Symptoms

You have many pending material and resource transactions and cost worker will not launch (no errored transactions)

EXPECTED BEHAVIOR
-----------------------
Expect the transactions to process

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. INV: Transactions: Material Transactions: Choose org
2. Null/Blank the from date
3. Choose no from the costed field List Of Values (LOV) in the lower right of the form
4. Find
5.  Many uncosted material transactions

Or,
1.  WIP: Resource Transactions: Pending Resource Transactions
2.  Find
3.  Many pending material transactions

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, you cannot close period and have many uncosted WIP jobs....

Changes

There are some errored/unprocessed rows in the WIP_MOVE_TXN_INTERFACE table (Pending move transactions) and/or the MTL_MATERIAL_TRANSACTIONS_TEMP table (Pending Inventory Transactions).

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