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.

1. Select Common Setup > Report Configuration.

2. Click the Add button.

3. Enter values for the following fields:

   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.

4. Click Save.

Updating Report Configuration Details

1. Select Common Setup > Report Configuration.

2. Click a report row on the Report Configuration page.

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

4. Click Save.

Adding Report Parameters

1. Select Common Setup > Report Configuration.

2. Click the report row on the Report Configuration page for which you want to add a parameter.

3. On the Report Configuration Details page, click Add in the Parameters grid.

4. Enter values for the following fields:

   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.

5. Click Save.

Modifying Report Parameters

1. Select Common Setup > Report Configuration.

2. Click the report row on the Report Configuration page for which you want to modify a parameter.

3. Click the row in the Parameters grid that you want to modify.

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

5. Click Save.

Deleting Report Parameters

1. Select Common Setup > Report Configuration.

2. Click a row on the Report Configuration page.

3. Click Edit in the Parameters grid.

4. Select the check boxes next to all of the report parameters that you want to delete.

5. Click Delete. You will be prompted to confirm the permanent deletion.