ORA-00001 Upon Applying the Off Invoice Deals on Purchase Orders
(Doc ID 2938976.1)
Last updated on MARCH 31, 2023
Applies to:
Oracle Retail Merchandising Foundation Cloud Service - Version 22.1 and laterInformation in this document applies to any platform.
Symptoms
ORA-00001 Error occurs upon applying the offinvoice deals on the Purchase Order.
steps to reproduce:
--------------------------
1. Create a company wide deal.
2. Create a item/loc specific deal.
3. Create a PO and make sure the deals created in step 1, 2 get applied.
4. Recalculate the PO and Save and Close. Note it fails with below error.
Error ORA-00001: unique constraint(RMS01.ORDLOC_DISCOUNT_I2) violated returned by program unit DEAL_ORD_LIB_SQL.FIND_ITEMS_FOR_DEAL.
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 |