My Oracle Support Banner

Itemexp Screen Throws an Error as "ORA-00001: Unique Constraint (PK_ITEM_EXP_HEAD) Violated@2ITEM_EXPENSE_SQL.COPY_DOWN_PARENT_EXP" (Doc ID 2001505.1)

Last updated on FEBRUARY 21, 2019

Applies to:

Oracle Retail Merchandising System - Version 13.2.6 to 13.2.8 [Release 13.2]
Information in this document applies to any platform.


Itemexp screen throws following error when defaulting expenses from parent item to child item in case the child item may have an additional country than the parent item.

Steps to Recreate:

1. Create item parent IP1 and Tran Item IT2.
2. Attach IP1 to Supplier 1 and Origin Country US.
3. Add expenses.
4. Default Supplier, Country and expenses to Child.
5. Now edit IT2, add CA as origin Country.
6. Add Expenses.
7. Now edit IP1, add CN as origin country.
8. Add expenses, click OK.
9. Pop up appears asking – Should the expenses be defaulted to children, Click Yes.
10. The error "ORA-00001" pops up.




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.