Custom Reports
The Custom Reports function provides a generic reporting capability that makes use of a single report to print out a custom definition. This report is called PERGENRP.
The report is registered as a concurrent process and prints, in landscape format, the contents of the temporary table PER_GENERIC_OUTPUT_REPORT.
This table contains the individual components of a custom report and is populated by the PL/SQL package PERGENRP.pkb, stored in $PER_TOP/admin/sql. This package is executed when you select the Generate Report button on the Custom Reports window.
To submit a Custom Report:
1. Navigate to the Custom Reports window.
2. Select the report by name.
3. Enter any parameters for this report.
Attention: Parameter values are not validated until you choose the Generate Report button.
4. Choose the Generate Report button
The default for the report is to print the output automatically. It is a System Administrator task to set default printers for all users, or to reset this option on the Concurrent Program window.
Creating New Report Formats
A special feature of Custom Reports is that you do not need to create multiple reports. You modify the generic package (PERGENRP.pkb) and report to provide additional formats and parameters.
Three sample report formats are provided, each with a different set of parameters:
- PERCS001 - Custom Report 1
There is one parameter: Vacancy. The format in PERGENRP is Full Name of Applicant and Gender.
- PERCS002 - Custom Report 2
Parameters are Vacancy and Gender. The format in PERGENRP is Full Name of Applicant in uppercase.
Parameters are Vacancy, Gender and Marital Status. The format in PERGENRP is Full Name of Applicant, Gender and then Full Name in uppercase.
You can edit the generic package to change:
After you have modified the package, you need to register a new custom report, with the parameter set for that report. This is a task for the System Administrator.
To register a new Custom Report with parameters:
1. Navigate to the Concurrent Programs window.
2. Enter the name of the Custom Report as the Program.
3. Enter a short name for the Custom Report.
Attention: You must start the short name with PERCS. This will limit the list of values available to users in the Custom Report window.