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 and later
Information in this document applies to any platform.



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.

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.



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




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

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