UDA Value Deleted In MFCS Fails To Get Deleted In SIOCS Due To Incorrect ChangeType
(Doc ID 3062819.1)
Last updated on DECEMBER 09, 2024
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 24.1 and laterOracle Retail Enterprise Inventory Cloud Service - Version 24.1 and later
Information in this document applies to any platform.
Symptoms
In SIOCS you see the DcsUDA message in error when UDA value is deleted in MFCS.
Messages in SIM01.MPS_STAGED_MESSAGE for DcsUDA fail with the below error message.
After deleting a UDA Value in MFCS for an existing UDA, a message is sent to MPS Staged Message without a value description since this isn't held in the ICL_RMS_UDA_ITEM_LOV table.
It seems as if deleting UDA Values via direct DB integration isn't supported.
ERROR
-----------------------
"Caused by: oracle.retail.sim.common.core.SimServerException: Error executing statement. SQLIntegrityConstraintViolationException(1400): ORA-01400: cannot insert NULL into ("SIM01"."UDA_LOV"."DESCRIPTION")"
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Have existing UDA & values attached in MFCS;
2. Delete one UDA_VALUE for that UDA in MFCS;
3. SIOCS receives the message in MPS_STAGED_MESSAGE but fails.
Due to this issue, the UDAs will not be aligned between MFCS and SIOCS.
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 |