Error While Publishing From Production Scheduling In The WIP Interface. (Doc ID 2281685.1)

Last updated on JULY 06, 2017

Applies to:

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

Symptoms


When attempting to publish from Production Scheduling to Work in Process,
the following error occurs.


ERROR

 ORA-01407: cannot update ("WIP"."WIP_REQUIREMENT_OPERATIONS"."WIP_SUPPLY_TYPE") to NULL in Package
  wip_massload_pvt Procedure processWJSI


STEPS

The issue can be reproduced at will with the following steps:
1. Import into interface table.
2. Run WIP Mass load.
3. Error provided in the Report output of Job and Schedule Interface Report.

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