Example 1: Passing parameters to report
1) Go into the Data Model and then change the query:
select a.*, b.dname
from emp a, dept b
where a.deptno=b.deptno
and a.deptno = :p_deptno
2) Save
3) Re-run the report
4) Now the report will prompt the user to enter Department Number.
Example 2: Passing lexical parameter to report– example 1
1) Go into the Data Model and then change the query:
select a.*, b.dname
from emp a, dept b
where a.deptno=b.deptno
&order_by
2) Save
3) Re-run the report
4) Now the report will prompt the user to enter Lexical parameter. Let say you enter ‘order by dname’ and then run the report.
Example 3: Passing lexical parameter to report – example 2
5) Go into the Data Model and then change the query:
select a.*, b.dname
from emp a, dept b
where a.deptno=b.deptno
&and_cond
6) Save
7) Re-run the report
8) Now the report will prompt the user to enter Lexical parameter. Let say you enter ‘and a.deptno=10’ and then run the report.
-
In HRMS we do use date with timestamp for EIT ans SIT segments. To change the format od the date we can use fnd_date . canonical_to_date ... -
Converstion API Table Organization hr_organization_api.create_hr_organization hr_all_organization...
-
WIP Migration: Create a job in Work in Process 1. Create a job with item which is billable on and define routing sequence for the ...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.