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.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!