default value in DOR DFF
How to get default value for person_number in DOR DFF. I have tried below query to retrieve default value. But it is not showing the default value.
How to use the derivation value parameters?
select papf.person_number from per_all_people_f papf where papf.person_id = :{parameter.PERSONID} and trunc(sysdate) between papf.effective_start_date and papf.effective_end_date
0