While Registering the report to instance we need to make sure od date format:
1.The default type is YYYY/MM/DD HH24:MI:SS
go to properties of the parameter and update in format mask.
2.Have to pass P_Conc_Request_id to make sure we can retrive the request id.
The parameter name and the token name should be the same.
3.In before report trigger have to call the client info if we take inputs from views.
eg: begin
fnd_client_info.set_org_context('104');
end;
4.If u need the template to be same for multiple inputs.e.g payslip for all employees to be generated in a template from two or more queries then have to use Link in reports builder.
Oracle HCM & ERP insights from the field — Fusion Cloud, Redwood UI, Payroll, Absence, BIP, OTBI and integrations.
Subscribe to:
Post Comments (Atom)
Recruiting: jobs not visible on the career site
# Fix of the Day #7: Recruiting: jobs not visible on the career site Part of my Oracle Fusion HCM Fix of the Day series: real issues from...
-
Absence Management in Oracle Fusion is powerful — and easy to get wrong. The accrual plan is where most of the complexity lives. Here is a...
-
While Registering the report to instance we need to make sure od date format: 1.The default type is YYYY/MM/DD HH24:MI:SS go to propert...
-
This is easily done with the following command: select to_char(to_date('56789','J'),'JSP') from dual / TO_CHAR...
No comments:
Post a Comment
Thanks for your comments submitted.,will review and Post soon! by admin.