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
(Doc ID 2115498.1)
Last updated on MAY 01, 2023
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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document