My Oracle Support Banner

Swapping Resources Using the WIP Mass Load API Fails With 'System cannot add resource because requested schedule_seq_num has already existed or less than or equal to 0.' (Doc ID 3043267.1)

Last updated on AUGUST 23, 2024

Applies to:

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

Symptoms

While using the WIP Mass Load API and loading data into the WIP_JOB_SCHEDULE_INTERFACE and WIP_JOB_DTLS_INTERFACE tables, the following error is displayed in the WIP_INTERFACE_ERRORS table:

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

The issue can be reproduced at will with the following steps:

  1. Load Job data into the WIP_JOB_SCHEDULE_INTERFACE table.

  2. Load primary and alternate resource data into the WIP_JOB_DTLS_INTERFACE table.
    -- Primary resource information
    OPERATION_SEQ_NUM
    RESOURCE_SEQ_NUM
    RESOURCE_ID_OLD

    -- Alternate resource to be swapped
    SCHEDULE_SEQ_NUM
    SUBSTITUTE_GROUP_NUM
    REPLACEMENT_GROUP_NUM
    USAGE_RATE_OR_AMOUNT
    RESOURCE_ID_NEW
  3. Run the WIP Mass Load concurrent program.
    1. Work in Process > Other > Request.
    2. Select the Submit a New Request button.
    3. From the list of values, select WIP Mass Load.
    4. Populate Group ID.
    5. Submit.

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.