Reports

Overview

The following seeded reports are available with CLM. If these reports need to be customized to suit individual agency needs, they can be modified by implementers.

In addition, implementers can create new reports using the following tools: Oracle Business Intelligence Publisher or Oracle Business Intelligence - Enterprise Edition (OBIEE).

Print CLM Requisitions Report

The Print CLM Requisitions Report prints the details of each purchase requisition that you have specified. You need to enter a range of requisition numbers (From and To) that you wish to print.

Report Submission

Using an appropriate CLM iProcurement responsibility, navigate to Reports > View Requests. In the Requests page, click Submit Request. The Schedule Request: Name page displays, select the New Request radiobutton and then search for the report name using the search LOV in the Program Name field. Search for the Print CLM Requisitions Report in the search LOV and ensure you have the appropriate Operating Unit and Language populated in the page. Click Next to proceed.

Parameters

Requisition Number From

Enter the starting requisition number that you wish to print from. You can specify a single requisition or a sequence of requisition numbers.

Requisition Number To

Enter the last requisition number that you wish to print. You can specify a single requisition or a sequence of requisition numbers.

Output

This report prints requisition details only for the requisition number sequence you specify.

Depending on the line type, contract type and cost constraints, the pricing details of the requisition are printed. The cost constraints, if any, are also printed. The funded amount is also calculated and printed in the report.

Print CLM Requisition Amendments Report

The Print CLM Requisitions Report prints the details of each purchase requisition that you have specified. You need to enter a range of requisition numbers (From and To) that you wish to print.

Report Submission

Using an appropriate CLM iProcurement responsibility, navigate to Reports > View Requests. In the Requests page, click Submit Request. The Schedule Request: Name page displays, select the New Request radio button and then search for the report name using the search LOV in the Program Name field. Search for the Print CLM Requisition Amendments Report in the search LOV and ensure you have the appropriate Operating Unit and Language populated in the page. Click Next to proceed.

Parameters

Amendment Number From

Enter the starting requisition amendment number that you wish to print from. You can specify a single requisition amendment or a sequence of requisition amendment numbers.

Amendment Number To

Enter the last requisition amendment number that you wish to print. You can specify a single requisition amendment or a sequence of requisition amendment numbers.

Output

The values on the report are printed as the data exists on the requisition amendment. The report displays the amended values, that is, the difference between the base value (From value) and the new value on the amendment (To value) are printed.

Depending on the line type, contract type and cost constraints, the pricing details of the requisition are printed. The cost constraints, if any, are also printed. The funded amount is also calculated and printed in the report.