October 5, 2010

Custom Report Notes:

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.

No comments:

Post a Comment

Thanks for your comments submitted.,will review and Post soon! by admin.

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...