PriceEventExecutionRMSBatch Fails With ORA-00001 Unique Constraint While Processing Price Changes for Re-Used Items
(Doc ID 2254140.1)
Last updated on NOVEMBER 22, 2020
Applies to:
Oracle Retail Merchandising System - Version 14.0.3 and laterInformation in this document applies to any platform.
Symptoms
PriceEventExecutionRMSBatch Fails with the below error while Processing Price Changes for Re-Used Items.
Steps to reproduce:
--------------------------
- Create a transaction item and range it to a store.
- Run RPM NewItemLocBatch.
- Create an emergency price change for the item and store created in step 1.
- Delete the item from the User Interface (UI).
- Run Dlyprg batch
- Verify that the item is deleted but the records still remain in PRICE_HIST.
- Create another item. Make sure the item number is same as in step 1 and range it to the same store.
- Create a regular price change for the item and store with effective date as tomorrow.
- Run RPM PriceEventExecutionBatch.
- Run RPM PriceEventExecutionRMSBatch. Note that the batch fails with the above error.
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 |