This program has been designed to streamline the process of maintaining organizational changes. You may have to change the person name (buyer, approver, deliver-to) on existing purchasing documents. The Mass Update of Purchasing Documents program updates person information on Oracle Purchasing documents from a previous (old) person to a new person.

The following Purchasing documents will be updated:

• Standard Purchase Order

• Blanket Purchase Agreements

• Blanket Releases

• Planned Purchase Orders

• Planned Releases

• Contract Agreements

You can run the Mass Update of Purchasing Documents program from within Purchasing. Documents will remain in the same status after the person name update. Document revision and archival will not take place.

Mass updates can be done for documents with the following statuses: Approved, Requires Approval, Pre-Approved, Incomplete, Rejected, and In-Process. You cannot perform mass update for documents with a status of Cancelled, Finally Closed, Closed POs and Frozen POs.

A report is produced as output from the concurrent program. This report lists the document number and document type of the Oracle Purchasing documents that were updated by the program.

Submission

In the Submit Requests window, select Mass Update of Purchasing Documents in the Name field.

Parameters

Update Person (Required)

Select from All, Approver, Buyer, Deliver To.

Old Person (Required)

Enter or select the person name that needs to be changed. This must be a person name that is currently in the system (active or inactive).

New Person (Required)

Enter or select the person name that is to be updated on all the documents that match the old person. This will show all the current persons except the one entered as the old person.

Document Type (Optional)

Select one of the following document types: All, Blanket Purchase Agreement, Contract Purchase Agreement, Planned Purchase Order, Standard Purchase Order. If Blanket Purchase Agreement is selected, then the updates are applicable for all the releases associated to the Blanket Purchase Agreement.

Document Number From and Document Number To (Optional)

Enter the range of the document numbers for the documents that you want updated.

Date From and Date To (Optional)

Enter the date range for which you want the documents to be updated.

Vendor Name (Optional)

Enter the Vendor (Supplier) Name. If this field is left blank, then the person name is updated for all suppliers.

Include Close PO (Optional)

Enter Yes or No, depending on whether you want to include closed Purchase Orders or Requisitions in the mass update.

Commit Interval (Optional)

Specify how many records should be updated before they are committed.