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 MARCH 03, 2017

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.

Symptoms

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

or

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

This same error can also occur for Resource transactions where in MTL_MATERIAL_TRANSACTIONS the transaction_source_id is a negative number.  See <Note 1344384.1> for details.

 



Steps:

1. WIP > Resource Transactions > Pending Resource 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