Error While Publishing From Production Scheduling In The WIP Interface.
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