When Attempting to Create a Standard Discrete Job via WIP MASS LOAD, 'System Cannot Add Resource Because Requested Resource_seq_num Has Already Existed or Less Than or Equal to 0' Happens
Last updated on APRIL 01, 2018
Applies to:Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to create a standard discrete job via WIP MASS LOAD, the following error occurs.
Customer set WIP_JOB_SCHEDULE_INTERFACE.ALLOW_EXPLOSION to N to insert operation,material requirement and operation resource records manually.
In WIP_JOB_DTLS_INTERFACE table, each operation has only 1 resource as below.
Steps to Reproduce
- Insert records into WIP_JOB_SCHEDULE_INTERFACE and WIP_JOB_DTLS_INTERFACE tables.
- Run WIP MASS LOAD.
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