Component Records Are Intermittently Processed And The Work In Process (WIP) Mass Load Fails With An ORA-01400
Last updated on JULY 28, 2016
Applies to:Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
The wip_job_dtls_interface had many records for adding component requirements. Although the WIP Mass Load concurrent request processed successfully, only some component records were successfully processed. The unprocessed records had the following error in WIP_INTERFACE_ERRORS.
WIPJDSTB, Add_Requirement: ORA-01400: cannot insert NULL into ("WIP"."WIP_REQUIREMENT_OPERATIONS"."MRP_NET_FLAG")
The issue can be reproduced at will with the following steps:
1. Insert many records into wip_job_dtls_interface
2. Run WIP MASS LOAD
3. Review Material Requirements on Discrete Job components screen.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms