EAR92:Payment Worksheet Error' Data being added conflicts with existing data. (18,2)' (Doc ID 2652762.1)

Last updated on JUNE 06, 2023

Applies to:

Symptoms

When attempting to create/submit payment worksheet
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 To Replicate
-----------------------
1. Enable Audit for PS_PAYMENT and PS_PAYMENT_ITEM table.
2. Create a regular deposit.
3. Apply payment and see the error.

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.