EGL 8.8+: ChartField Values Page Error 'Data Being Added Conflicts with Existing Data. (18,2)' When Adding New Chartfield With Same Effective Date (Doc ID 1121623.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 8.8 to 9.2 [Release 8.8 to 9]
Information in this document applies to any platform.
***Checked for relevance on 13-Sep-2012***

Symptoms

On : 8.8+ version, ChartField Configuration

When attempting to add a second value for Chartfield1 (same happens for Chartfield2 and Chartfield3) with the same effective date the following error occurs.

ERROR
-----------------------
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.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Set Up Financials/Supply Chain > Common Definitions > Design ChartFields > Define Values > ChartField Values. Click on Chartfield1, add a new value A with effective date 01/01/1900 and save changes.
2. Add another new value B with the same effective date. Save changes and the error message will pop up.

WHAT IS WORKING:
-----------------------
User is able to create and save only 1 Chartfield1 or as a work around user is able to create and save multiple Chartfield1 values using a different effective date.

EXPECTED RESULT
-----------------------
Users should be able to create and save multiple Chartfield1 values with the same effective date.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot create any new Chartfield1 values with the same effective date.

Cause

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