ORA-20001: The Combinations Table For This Flexfield Contains More Than One Entry

(Doc ID 1984497.1)

Last updated on AUGUST 25, 2017

Applies to:

Oracle Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Person / Assignment Issues

When attempting to update the people group in the assignment form, the following error occurs.

ERROR
-----------------------
"ORA-20001: : The combinations table for this flexfield contains more than one entry that matches the entered values. Inform your system administrator that the combination identified by the number 62 is duplicated."


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to assignment form and change the people group flex field.


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