SIOCS: ItemHeader Data Seeding Fails With 'ORA-00001: Unique Constraint (.) Violated'
(Doc ID 2909940.1)
Last updated on DECEMBER 01, 2022
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 22.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to seed ItemHeader data from MFCS to SIOCS the following error occurs.
ERROR
-----------------------
{"controlId":34685,"logMessage":"ORA-00001: unique constraint (.) violated","item_id":"208061","dataKey2":null,"dataKey3":null,"createTime":"2022-11-02T13:48:34.557829Z","createUser":SIM01_MDI}
Steps to Reproduce:
1. Start with a clean DB in SIOCS
2. Run Data Seeding modules one at a time.
3. Run Item Header data seeding.
4. Process fails with error
Data shows that Item's that fail to load have more than 1 Supplier that is set as PRIMARY_SUPP.
V_RMS_SIM_ITEM_SUPP_COUNTRY
ITEM SUPPLIER ORIGIN_COUNTRY_ID SUPP_PACK_SIZE CURRENCY_CODE UNIT_COST PURCHASE_TYPE PRIMARY_COUNTRY_IND PRIMARY_SUPP_IND TOLERANCE_TYPE PURCHASE_RATE
208061 4300018357 US 1 USD 7 0 Y N - -
208061 4300122879 GB 1 USD 7 0 Y Y - -
208061 4300122879 US 1 USD 7 0 N Y - -
V_RMS_SIM_ITEM_SUPPLIER
ITEM SUPPLIER VPN PRIMARY_SUPP_IND
208061 4300018357 208061 N
208061 4300122879 MINTVGAME Y
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 |