Getting error FLEX-VALUE DOES NOT EXIST during the HR_POSITION_API.UPDATE_POSITION
Hi,
our position name contains the organization name in one of its segments. We are using custom procedure to update position name once the organization name gets changed.
This works fine if there is no value set assigned to this segment. As soon as the segment has value set assigned it fails with error message FLEX-VALUE DOES NOT EXIST.
i.e. the organization name has been changed from 'CAC012 - Abc' into 'CAC012 - Cba' the following error message appear:
ORA-20001: FLEX-VALUE DOES NOT EXIST: N, VALUE, CAC012 - Abc, N, SEGMENT, Organization Name, N, VALUESET, XX_HR_ORGANIZATION_NAME