Setting Up Reports
The report parameters that you define filter the data that is generated for the reports. You can use delivered or provide customized reports.
For reports initiated from within Oracle Public Sector Licensing and Permitting, you add and modify report IDs and configuration details, which includes adding, modifying, and deleting report parameters, on the Report Configuration Details page. This setup doesn't apply to the reports you generate from the Report List.
For a list of delivered reports, their descriptions, and where you can find them, see Public Sector Compliance and Regulation Analytics.
You can also create your own reports in Oracle BI Publisher and allow users to access them through the available report generation buttons. For example, users with appropriate permissions can click the Print button on some application pages, such as the Print Deposit Slip page or the Inspection Detail page in the permit application details.
For more information on modifying and creating analytics and reports, see the Oracle Applications Cloud documentation: Creating and Administering Analytics and Reports.
Adding Report Configuration Details
You can add a report in addition to the delivered reports.
Select
.Click the Add button.
Enter values for the following fields:
Elements on the Report Configuration Details page
Page Elements
Definition
Report ID and Description
Enter an identifier and description of the report.
Path
Enter a path to the desired report. For example, the path for the Inspection Summary report in the Oracle Business Intelligence (BI) Catalog is /shared/Public Sector/Inspections/InspectionSummary.xdo.
Output Format
Select PDF or RTF to indicate the format of the generated report.
Report Category
Select a product area to classify the report.Click Save.
Updating Report Configuration Details
Select
.Click a report row on the Report Configuration page.
On the Report Configuration Details page, you can:
Update the description.
Enter the BI Catalog path for the report. For example, the path for the Inspection Summary report is /shared/Public Sector/Inspections/InspectionSummary.xdo.
If you create your own report, you can point the existing report generation buttons on the application pages to your custom report using this path.
Click Save.
Adding Report Parameters
Select
.Click the report row on the Report Configuration page for which you want to add a parameter.
On the Report Configuration Details page, click Add in the Parameters grid.
Enter values for the following fields:
Elements on the Parameter Details page
Page Elements
Definition
Parameter ID and Parameter Name
Enter a unique ID and name for the report parameter.
Parameter Data Type
Enter the data type for the report parameter.
Click Save.
Modifying Report Parameters
Select
.Click the report row on the Report Configuration page for which you want to modify a parameter.
Click the row in the Parameters grid that you want to modify.
On the Parameter Details page, you can:
Update the report parameter field values.
Delete the report parameter. You will be prompted to confirm the permanent deletion.
Click Save.
Deleting Report Parameters
Select
.Click a row on the Report Configuration page.
Click Edit in the Parameters grid.
Select the check boxes next to all of the report parameters that you want to delete.
Click Delete. You will be prompted to confirm the permanent deletion.