SIOCS Data Seeding Fails for WAREHOUSE_ITEM When Item Has Multiple Statuses Across Virtual Warehouses
(Doc ID 3011453.1)
Last updated on MARCH 21, 2024
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 24.0 to 24.0 [Release 24.0]Information in this document applies to any platform.
Symptoms
When attempting to import Warehouse Item data from MFCS into SIOCS, the following error occurs and the Warehouse Item Data Seeding module fails.
ERROR
-----------------------
{"controlId":31080,"logMessage":"ORA-00001: unique constraint (.) violated","physical_wh_id":"844","item_id":"088506660016172","dataKey3":null,"createTime":"2024-02-16T10:56:43.589568Z","createUser":SIM01_MDI}
Steps to Reproduce:
MFCS and SIOCS are on nextGen
MFCS has data as follows:
---------------------------------------------------------
Item ID Virtual WH Physical WH Status
---------------------------------------------------------
088506660016172 12345 844 A
088506660016172 45673 844 I
---------------------------------------------------------
1. Data seed into SIOCS Warehouse Items.
2. Status is Failed.
Changes
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 |
Changes |
Cause |
Solution |
References |