Value Set using FND_SESSIONS Is Not Returning Data (Doc ID 1598003.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle Human Resources - Version 10.7.0.16.1 and later
Information in this document applies to any platform.
Checked for currency 07-Apr-2015

Symptoms

the value set PER_ORGANIZATION_UNITS  in the DFF Common Lookups screen in Application Developer is not returning any values .


The below will work :

select * from per_organization_units
WHERE 1=1
and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')

But the original one will not :

select * from per_organization_units o, fnd_Sessions s
WHERE 1=1
and business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID')
  and session_id = userenv('sessionid')
  and s.effective_date between
  o.date_from and
  nvl(o.date_to,to_date('31/12/4712','DD/MM/YYYY'))

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