My Oracle Support Banner

WIP_FLOW_SCHEDULES with records in MTL_MATERIAL_TRANSACTIONS tables with Error Record not found in WIP_PERIOD_BALANCES Table (Doc ID 2134831.1)

Last updated on JUNE 21, 2023

Applies to:

Oracle Work in Process - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

 

When viewing materials transactions, observed erred transactions with any of the following error message in relation to WOLC - Work OrderLess Completions / Flow Schedules:

No balance exists for the appropriate period for the job/schedule
Record not found in WIP_PERIOD_BALANCE
The wip entity is either not defined or does not have a period balance entry.
CST_INVALID_WIP


The issue can be observed with any of the below steps:

1. observe erred transactions in the form Material Transactions

2. observe erred transactions in the following script:

For Material Transactions, the below query output displays one of the errors mentioned above.

QUERY 1:

 

For WIP Discrete Jobs or EAM work orders entities other than WOLCs, review the following document:

Note 2052420.1 - [Data Fix] Resource [WIP_COST_TXN_INTERFACE (WCTI)]/ Material Transactions [MTL_MATERIAL_TRANSACTIONS (MMT)] Having Errors Related to WIP_PERIOD_BALANCES Table

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.