My Oracle Support Banner

In Special Information Type (SIT), how to avoid errors on end-dated values coming from Lookup? (Doc ID 2907036.1)

Last updated on NOVEMBER 03, 2022

Applies to:

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


In SIT, if we use a Table Valueset which pulls values from a Lookup and if any of the lookup values are end-dated and if there exists any SIT record which holds one of those end-dated records,
then the below error is thrown upon accessing that SIT record (both in PUI and SSHR).

ID <Lookup_value> for the flexfield segment <Flexfield_Segment_Name> does not exist in the value set <Valueset_Name>.

Steps to Replicate the Issue

1. Create an SIT such that one of the segment has a Table ValueSet which pulls data from a Lookup as below:

2. Create an SIT record by selecting the value from the Valueset LOV.

3. Now end-date one of the Lookup values such that the lookup value end-date falls within the SIT record End Date

4. Now you can see that the SIT record is in error.


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.