Extensible Flexfields not auto populating on basis of SQl Query

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',