HR_SIT_API.create_sit Throws the Error "FLEX-VALUE DOES NOT EXIST". (Doc ID 1943802.1)

Last updated on DECEMBER 21, 2016

Applies to:

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

Symptoms

When attempting to create an SIT record using API HR_CREATE_API.create_site, the following error occurs.

ERROR
ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, 56699, N, SEGMENT, DEPENDENT1, N, VALUESET, XX_VALUE_SET


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

Call the API as a back-end procedure to create a record.

Workaround:
The record can be created using Application.

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