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.


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


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


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.


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