The Import Price Catalogs process imports price/sales catalog information and responses to requests for quotation (RFQs) electronically from suppliers in the form of blanket purchase agreements or catalog quotations. There are several ways you can import agreements and quotations into Oracle Purchasing.
Use the e-Commerce Gateway to import the electronic catalog information into the Purchasing Documents Open Interface. The Import Price Catalogs program then validates the information before importing it into Purchasing. When using the e-Commerce Gateway (EDI 832 or EDI 843 transactions) you have the option of running the Import Price Catalogs program either from within the gateway by choosing Import Programs from the menu, and entering the parameters or running the Import Price Catalogs program from Oracle Purchasing.
The other way to import agreements and quotations is to use a custom program to import the electronic catalog information into the Purchasing Documents Open Interface and then run the Import Price Catalogs program from Oracle Purchasing.
In the Submit Requests window, select Import Price Catalogs in the Name field.
Enter the default buyer name to be associated with the incoming documents.
Valid options are Blanket and Quotation. The option of Blanket directs Purchasing to create a blanket agreement from the price/sales catalog or quotation to be imported. The option of Quotation directs Purchasing to create a catalog quotation for the information to be imported.
Used with document type of Quotation to indicate a document sub type of Catalog for Response to RFQ to be imported. The document sub type of Bid Quotation is invalid for the transaction.
Used with the Price/Sales Catalog or Response to RFQ to indicate whether to update the item master with catalog item changes or add catalog items to the item master.
Indicate Yes or No on whether supplier sourcing rules should be created automatically during the Price/Sales Catalog and Response to RFQ import process. Yes means that Purchasing creates sourcing rules and Approved Supplier List entries from the supplier, item, and document information that the supplier sends.
If you choose Yes, make sure the Approval Status field for the submitted documents is Approved. Sourcing rules can be created only when the Purchasing documents have a status of Approved.
Enter desired status of Approved or Incomplete for the Blanket Agreements and Quotations to be created.
The following table shows the effects of the Approval Status you choose here on an agreement's or quotation's current status, when you import an Update price/sales catalog.
| Current Document Status | Import as Incomplete | Import as Approved |
|---|---|---|
| Incomplete | Document remains Incomplete | Document changes to Approved |
| Approved | Document remains Approved | Document remains Approved |
Attention: If the concurrent program is executed with the Approval Status parameter INITIATE APPROVAL or APPROVED, then you must run the Workflow Background Process for Item type PO Approval with process deferred as Yes.
Used when Document Type is set to Blanket and Create Sourcing Rules is set to Yes. Select from the following three blanket release methods:
Automatic Release/Review: Purchasing automatically generates releases and forwards them for approval.
Release Using AutoCreate: Enables you to use AutoCreate to convert purchase requisitions into blanket releases for blanket purchase orders.
Automatic Release: Purchasing automatically generates approved blanket releases for items that are sourced to a single supplier.
Enter a valid batch ID, that is a unique identifier for the group of documents in this submission. If you don't enter a Batch ID, one is generated for you when the process runs.
Enter Yes here to indicate that you wish to create global agreements from the blanket agreements that you are importing.
Select Yes or No. No is the default value. If the value is selected as Yes, then all the lines satisfying the matching conditions will be grouped to single line. Shipments will also be grouped based on the matching conditions.