VendorCre Messages Fail in MPS_STAGED_MESSAGE Table with 'ORA-0001: unique constraint (SIM01.SUPPLIER_ORGANIZATION_UK) violated'
(Doc ID 3006515.1)
Last updated on MARCH 04, 2024
Applies to:
Oracle Retail Enterprise Inventory Cloud Service - Version 23.1 to 24.0 [Release 23.1 to 24.0]Information in this document applies to any platform.
Symptoms
When attempting to process VendorCre messages from Retail Merchandising to SIOCS, the following error occurs and Suppliers are not created in the SUPPLIER table
ERROR
-----------------------
Messages have failed with ORA-0001: unique constraint (SIM01.SUPPLIER_ORGANIZATION_UK) violated.
Steps to Reproduce:
Pre-Requisite:
SUPPLIER_ORGANIZATION table has a record with SUPPLIER_ID = X
1. MFCS published VendorCre message for Supplier ID X to SIOCS via RIB.
2. Message fails in MPS_STAGED_MESSAGE.
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 |