Last updated on NOVEMBER 19, 2015
Applies to:PeopleSoft Enterprise FIN Expenses - Version 9.2 and later
Information in this document applies to any platform.
On : 9.2 version, Expense Report
When attempting to add a new value under Travel and Expenses, Manage Expenses Security, Authorize Expense Users
the following error occurs.
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 Travel and Expenses, Manage Expenses Security, Authorize Expense Users and click on Add a new value tab.
2. Type in some value like 'ABC' and click on Add.
3. On the authorize users page, enter VP1 and click on save and the above message will be displayed.
3. Click on magnifying lens and choose any User ID and click on save and it will be saved without any issues - when there is no existing user ID 'ABC' there is no point in allowing to add a new USER ID in this page to authorize users to enter expense reports on behalf of users who doesn't even exist.
Please see the Replication Steps document for more details related to complete configuration and the replication steps necessary to reproduce the issue.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms