My Oracle Support Banner

Payroll Connector Worker Extract Import Process Failed for New Hire Employee created In Fusion with error "ORA-20001: FLEX-VALUE DOES NOT EXIST" (Doc ID 2572980.1)

Last updated on AUGUST 30, 2023

Applies to:

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


Problem Statement:

When attempting to load a person record from Fusion to EBS, the following error occurs:

ORA-20001: The Job ################## is not loaded into the system
ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, <VALUE_1>, N, SEGMENT, TYPE, N, VALUESET, <NAME OF ERROR VALUESET>, N, ERRMSG, Value <VALUE_1> for the flexfield segment TYPE does not exist in the value set <NAME OF ERROR VALUESET>.


Steps to Reproduce:
The issue can be reproduced at will with the following steps:

1. Load Data File to EBS from Fusion

2. Review Error Logs




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.