Cost Calculation Error code: cst_invalid_wip

Cost Calculation Error code: cst_invalid_wip

The issue can be reproduced at will with the following steps:

1. Oracle Cost Management

2. Inventory material transactions

3. Review material txn

 

Select DistinctMt. transaction_source_id, MT. error_code

FromMtl_material_transactions Mt

WhereMt. costed_flag = 'E'

 

Error code: cst_invalid_wip

Explanation of Chinese errors: The WIP entity is undefined or does not have a balance item during the period

The WIP entity is either not defined or does not have a period balance entry

 

 

 

 

 

Solution: FYI

 

1) run the datafix scripts:

A. To change null Date released = minimum transaction date.

B. Change Date released = minimum transaction date.

C. Create missing wip_period_balances record after changing release date.

 

2) check that for all the jobs, Date released is populated.

3) after step 2, process pending transactions in wip_cost_txn_interface.

Record in mtl_material_transaction table will not be costed if record is

Stuck in wip_cost_txn_interface.

4) resubmit the transactions for costing.