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 JULY 19, 2016

Applies to:

Oracle Work in Process - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Problem Statement

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.

OPERATION_SEQ_NUM RESOURCE_SEQ_NUM LOAD_TYPE SUBSTITUTION_TYPE
11 10 1 2
21 10 1 2
31 10 1 2
41 10 1 2


Error

System cannot add resource because requested resource_seq_num has already existed or less than or equal to 0.

Steps to Reproduce

  1. Insert records into WIP_JOB_SCHEDULE_INTERFACE and  WIP_JOB_DTLS_INTERFACE tables.
  2. Run WIP MASS LOAD.

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