WIP_PERIOD_BALANCES Not Created When Job Status Changed From CANCELLED To COMPLETE NO CHARGES (Doc ID 1664618.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.1.3 version,
 

Find WIP Issue transactions that have failed costing due to the below error

ERROR
-----------------------
CST_INVALID_WIP (The wip entity is either not defined or does not have a
period balance entry.)

The issue is resolved by running data fix script to create missing
WIP_PERIOD_BALANCES (Doc ID 553138.1)


Was able to reproduce issue where WIP does not insert records
in WIP_PERIOD_BALANCES table and requests a code fix.


Steps To Reproduce
Navigate to Discrete Jobs Form
Create a job in Unreleased status>Change the status to Cancelled>Change the
status to Complete No Charges.
Notice that the date released and date completed fields have values
Check WIP_PERIOD_BALANCES for this wip_entity_id this record is not there

On the other hand if you modify the above steps to first change the status of
the Cancelled job to
Complete and then to Complete No Charges then WIP_PERIOD_BALANCES has a
record

So the system should disallow changing status of the job from Cancelled
directly to Complete No Charges (as it does when jobs are in Released Status
and you try to make them complete no charges)
or insert a record in WIP_PERIOD_BALANCES as it does when changing status
from Cancelled to Complete to Complete No Charges

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