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 Technical Experience and Test Cases Shared from different resource and through self leanings.
Subscribe to:
Post Comments (Atom)
COALESCE-SQL
Coalesce- return the null values from the expression. It works similar to a case statement where if expression 1 is false then goes to expr...
-
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.