My Oracle Support Banner

Root Cause Fix: Missing Record In WIP_PERIOD_BALANCES and CST_INVALID_WIP Errors - Most Current or Recent Root Cause Fix (Doc ID 1416033.1)

Last updated on JANUARY 12, 2023

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Work in Process - Version 12.1.3 to 12.1.3 [Release 12.1]
Oracle Enterprise Asset Management - Version to [Release 11.5]
Oracle Work in Process - Version to [Release 11.5]
Information in this document applies to any platform.
Form:WIPDJMDF.FMB - Define Discrete Job
Form:EAMWOMDF.FMB - EAM Work Order Definition


Actual Behavior
When a Work Order is created shortly after a period is opened, transactions against the work order will error.

Missing record for WO in WIP_PERIOD_BALANCE table

Expected Behavior
The transactions should process without error.

Scenario 1 (For Work In Process):
1. In the month end when the user open the next month period on last day of the month (31-DEC-2011 4.11.30pm)
2. Then another user create WO with release status at almost same time (31-DEC-2011 4.11.56pm).
3. The system fails to insert the record in WIP_PERIOD_BALANCE for that particular WO

Scenario 2 (for Enterprise Asset Management):
1 thru 3. See Scenario #1.
4.   The issue happens if the user change the WO status from Draft/ unreleased to released while period open is ongoing




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.