Component Records Are Intermittently Processed And The Work In Process (WIP) Mass Load Fails With An ORA-01400 (Doc ID 2165378.1)

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.

Symptoms

ACTUAL BEHAVIOR
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.

ERROR
WIPJDSTB, Add_Requirement: ORA-01400: cannot insert NULL into ("WIP"."WIP_REQUIREMENT_OPERATIONS"."MRP_NET_FLAG")

STEPS

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.

 

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