ORA-00001 Unique Constraint PK_DEPT_CHRG_HEAD Violated Error When Adding Up-charges at Department Level

(Doc ID 2394612.1)

Last updated on MAY 08, 2018

Applies to:

Oracle Retail Merchandising System - Version 16.0.1 and later
Information in this document applies to any platform.


System is throwing ORA-00001 unique constraint PK_DEPT_CHRG_HEAD violated error if multiple users tries to add up-charges at department level for same up-charge location combination concurrently.

Steps to Reproduce:
1. Login two users concurrently on RMS application.
2. Open Department Screen in both session.
3. Add same up-charges from one location to all stores
4. Save and close up-charge details for one user.
5. Now try to save and close department up-charge screen for other user
6. Application throws unique constraints error.




Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms