Updating Job Record, Errors: APP-FND-00716:The combinations table for this flexfield contains more than one entry that matches the entered values and APP-PAY-07810:The job you have entered already exists in the Business Group (Doc ID 280301.1)

Last updated on MARCH 28, 2017

Applies to:

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

Symptoms

When updating records from within the application or through HR_JOB_API.UPDATE_JOB api , the following error message is received:

APP-FND-00716: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 &CCID is duplicated.


APP-PAY-07810:The job you have entered already exists in the Business Group .Please enter a unique name of the job.

 

The above errors are the result of data corruption in the per_job_definitions table, such as duplicate job_definition records with duplicate values for one or more Key Flex enabled segments. Only one of each duplicate set is actually used in the per_jobs table.

 

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