Import Purchase Agreements from External Purchase Prices

Use the Import Purchase Agreements from External Purchase Prices scheduled process to create or update purchase agreements from the external purchase prices.

All approved external purchase price lines that are effective as of date are created as purchase agreements.

When more than one external purchase price line exists for the same item and unit of measure combination, one of the price lines is selected based on the selection criteria to be created as purchase agreement line.

This process checks for any changes to the external purchase prices after the process was last run and updates the purchase agreements with all the required changes. Depending on the type of changes, it might create a new purchase agreement, or add lines to the existing purchase agreement, update, or end date existing purchase agreement lines. This process will create the records in the purchasing interface tables to create or update purchase agreements. In addition, it will automatically submit the Import Blanket Agreements process to import the records from the interface tables.

When to Use

The process should be scheduled to run automatically at least once daily. You must also schedule this process to run after the Import External Purchase Prices process is completed so that the latest changes to external purchase prices are reflected in the purchase agreements.

Privileges Required

  • Import Purchase Agreements from External Purchase Prices SCH_UPDATE_BPA_FROM_EXTERNAL_PURCHASE_PRICES_PRIV)

Specifications

Review these specifications before you set up the scheduled process.

Specification Description
Job Type Scheduled.
Frequency The process should be scheduled to run automatically at least once daily.
Time of Day After work hours preferably in the early hours of the day. Any future dated external purchase prices that come into effect on the day of the run are pushed to the purchase agreements by this process.

You must also schedule this process to run after the Import External Purchase Prices process is completed so that the latest changes to external purchase prices are reflected in the purchase agreements.

Duration Typically, less than 10 minutes.
Compatibility There should be only one instance of the job running at any one time and there is no current functional need to run multiple instances of this process at the same time. This process is automatically placed on hold when any of these other External Purchase Prices scheduled processes are running.
  • Import External Purchase Prices
  • Update Item and Category for External Purchase Prices
And it automatically resumes after the earlier process is completed.

Parameters

Parameter Optional or Required Description Parameter Values Special Combinations Required Notes
Procurement BU Optional The procurement business unit for which the purchase agreements are created from external purchase prices. Procurement BU No Schedule the process without specifying a batch id.
Default Buyer Optional Name of the default procurement agent for creating the purchase agreements.

Ensure that the buyer has access to create and update purchase agreements in the procurement business unit.

Default buyer No Schedule the process with Reprocess Error = No.

Troubleshooting Information

  • The purchase agreement errors exception card is displayed in the External Purchase Prices work area when errors have occurred during import of purchase agreements. From here, you can drill down to the Errors in Purchase Agreements page which lists the detailed error messages and the attributes that caused the error.
  • The External Purchase Prices lines with purchase agreement errors are displayed in error status in the External Purchase Prices page. An exception icon is indicated against external purchase prices that contain error lines in the external purchase prices work area.
  • Once the errors are resolved, the interface records are processed in the next run of the Import Purchase Agreements from External Purchase Prices scheduled process.