Update Tax Categories Error: APP-FND-01206: This record already exists. You entered a duplicate value (Doc ID 1639311.1)

Last updated on SEPTEMBER 16, 2016

Applies to:

Oracle Financials for India - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, India PO Localizations

When attempting to update the Tax categories using the 'Update tax category UI'
the following error occurs.

ERROR
-----------------------
APP-FND-01206: This record already exists. You entered a duplicate value of sequence of values that must be unique for every record


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (N)->India Local Purchasing
2. India Localization -> Setup -> Tax Setup -> Update Tax Categories
3. Enter the value in for the 'Old Tax Name' field.
4. Enter the value for the 'New Tax Name'
5. Find Tax Categories
6. Enable the checkbox 'Update'.
Observe that the following error message comes:

APP-FND-01206: This record already exists. You entered a
duplicate value of sequence of values that must be unique
for every record

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
1. Users can not update the open orders with the new tax values.
2. Order processing is stuck as the user is unable to update the tax categories with the latest tax rate.
3. Unable to arrive at the exact revenue and tax projections as the user is unable to update the orders with the correct / applicable tax code/rate.

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