Download Contract Purchase Agreements

The Contract Purchase Agreements Integrator supports downloading existing agreements from Oracle ERP Cloud directly into the workbook. This allows you to review, update, or use existing agreements as a reference before uploading changes.

For general instructions on how to perform a download, refer to Download Functionality.

Download Filter Criteria

The following filter criteria are available when performing a download. Applying more specific filters will reduce the volume of returned records and improve performance.

Filter Field	Required	Description
Procurement Business Unit	Yes	The Procurement Business Unit is mandatory. Agreements are returned for the selected Business Unit only.
Agreement Number	No	Filter by a specific Contract Purchase Agreement number.
Supplier	No	Restrict results to agreements with a specific supplier.
Supplier Site	No	Further restrict results to a specific supplier site.
Buyer	No	Filter agreements assigned to a specific buyer.
Agreement Status	No	Filter by agreement status, for example Active or On Hold.
Agreement Start Date From	No	Return agreements with a start date on or after this date.
Agreement Start Date To	No	Return agreements with a start date on or before this date.

Filter Field

Required

Description

Procurement Business Unit

Yes

The Procurement Business Unit is mandatory. Agreements are returned for the selected Business Unit only.

Agreement Number

Filter by a specific Contract Purchase Agreement number.

Supplier

Restrict results to agreements with a specific supplier.

Supplier Site

Further restrict results to a specific supplier site.

Buyer

Filter agreements assigned to a specific buyer.

Agreement Status

Filter by agreement status, for example Active or On Hold.

Agreement Start Date From

Return agreements with a start date on or after this date.

Agreement Start Date To

Return agreements with a start date on or before this date.

Downloaded Contract Purchase Agreement data is read-only for reference columns such as Agreement Number, Procurement Business Unit, and Supplier. Updatable columns can be modified and re-uploaded. Refer to Updatable Columns for details on which columns can be changed.

Downloaded Sections

The download returns data across the following sections of the integrator sheet:

Header: Agreement header details including Agreement Number, Procurement Business Unit, Supplier, Supplier Site, Buyer, Start Date, and End Date.
Business Unit Access: Business units that have access to the agreement.