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.

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