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 laterInformation 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:
- Load Job data into the WIP_JOB_SCHEDULE_INTERFACE table.
- 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 - Run the WIP Mass Load concurrent program.
- Work in Process > Other > Request.
- Select the Submit a New Request button.
- From the list of values, select WIP Mass Load.
- Populate Group ID.
- 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 |