Material and Resource Transactions With Error Code CST_INVALID_WIP because of missing record in WIP_PERIOD_BALANCES
(Doc ID 553138.1)
Last updated on JULY 28, 2020
Applies to:Oracle Work in Process - Version 11.5.9 and later
Oracle Enterprise Asset Management - Version 11.5.9 and later
Oracle Cost Management - Version 11.5.9 and later
Information in this document applies to any platform.
This note provides solution for following situations:
A. Material Transactions
There are transactions in MTL_MATERIAL_TRANSACTIONS related to DISCRETE JOB which have following error :
ERROR CODE: CST_INVALID_WIP
ERROR_EXPLANATION: The wip entity is either not defined or does not have a period balance entry.
The issue can be reproduced at will with the following steps:
1. WIP > Material Transactions > View Material Transactions > Select Status=Error
2. Inventory > Transactions > Material Transactions > Select Status=Error
B. Resource Transactions
There are Resource Transactions stuck in pending in WIP_COST_TXN_INTERFACE with following error explanation:
Record not found in WIP_PERIOD_BALANCE
Cause: There is no record in WIP_PERIOD_BALANCES for the repetitive schedule or job.
Action: Contact Oracle Support Representative
Other possible error message:
The wip entity is either not defined or does not have a period balance entry
1. WIP > Resource Transactions > Pending Resource Transactions
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document