If you want to make any parameter dependent on other parameter in oracle fusion BI reports then below is the sample sql example provided while creating LOV for the dependent parameter.
select assignment_number from PER_ALL_ASSIGNMENTS_F where job_id=(select job_id from PER_JOBS_F_VL where name=:p_job_name) and trunc(sysdate) between trunc(effective_start_date) and trunc(effective_end_date)
Please refer to the link provided below.
dependent-parameter-in-fusion-bi
For any queries, you can message us at contact@doyensys.com
Recent Posts
