Error (18,2) When Updating GSS Transaction Configurations (Doc ID 2497886.1)

Last updated on MAY 11, 2023

Applies to:

Symptoms

Unable to modify configurations for Guided Self Service transactions. Every time a new effective dated row is added, the following error message is received when saving:

Data being added conflicts with existing data. (18,2)
When adding a new item to the database, the system found a conflicting item already exists.
This problem can happen if another user has entered similar information at the same time as you. Note the changes you have made, cancel the page, then retry your changes.
If the problem persists, it may be because of an application or other programming error and should be reported to technical support staff.
This error occurs when the keys on the record being inserted match a record that is already in the database. The application must ensure that each inserted record has unique keys.


The issue can be reproduced at will with the following steps:
1. Navigate to Set Up HCM > Common Definitions > Guided Self Service > Transaction Configuration
2. Select HR_TERMINATE transaction, add a new effective dated row, save
3. Note above error is returned

Changes

Cause

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