Date track for update

To pull the date updated by eliminating the previous version we can use this truncate staement for date tracked tables which will give only the updated values.

E.g:- select nvl(pac.segment1,null) from
                         per_person_analyses ppa,
                         per_analysis_criteria pac,
                         per_all_people_f papf
                         where ppa.ANALYSIS_CRITERIA_ID=pac.ANALYSIS_CRITERIA_ID
                         and ppa.id_flex_num =p_id_flex_num and ppa.person_id=p_person_id
                         and papf.person_id=ppa.person_id and
                         trunc(sysdate) between papf.EFFECTIVE_START_DATE
                         and papf.EFFECTIVE_END_DATE and trunc(sysdate) between ppa.DATE_FROM
                         and nvl  (ppa.DATE_TO,trunc(sysdate));

NVL in reports

To choose all the values or the parametr value:

nvl(:p_param,colum_name);

this will replace the param even if we dont pass manually.

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.