My Oracle Support Banner

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.

Symptoms

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.

Changes

 

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!


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