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
Last updated on MARCH 28, 2017
Applies to:Oracle Human Resources - Version 188.8.131.52 and later
Information in this document applies to any platform.
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.
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