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

1. Oracle cost Management

2. Inventory Material Transactions

3. Review material txn

 

select distinct mmt.transaction_source_id,mmt.error_code

from    mtl_material_transactions  mmt

where  mmt.costed_flag ='E'

 

错误代码：CST_INVALID_WIP   

中文错误解释：WIP 实体未定义或不具有期间余额项

英文错误解释：The wip entity is either not defined or does not have a period balance entry

 

 

 

 

 

SOLUTION: FYI

 

1) Run the datafix scripts to:

  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.