You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Extensible Flexfields not auto populating on basis of SQl Query

Accepted answer
55
Views
1
Comments

Hi There,

I am trying to auto populate Extensible Flexfields through sql. This sql contains recent action code transaction and shows its Effective Start date.

In order to pass the parameter i used :

select * from fusion.FND_DF_PARAMETERS where DESCRIPTIVE_FLEXFIELD_CODE = 'PER_PERSON_EIT_EFF' from which I am passing :{PARAMETER.Person ID} as Paramter.


Sql query used yields out when I hardcode it and run in BI report. Please find the logic below:


Select 

to_char(max(a.Effective_start_date),'dd/mm/yyyy')

from per_all_assignments_m a

where 1=1

and a.action_code in

('IJP',

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!