How do I create mappings?

Use the External Purchase Prices Mappings page to create mappings for requisitioning business units (BUs) and other optional categories such as manufacturer, supplier site, and so on. Create these mappings when values for some of the attributes imported from the external application are different from the corresponding attributes in Oracle Fusion Cloud Procurement.

Here's how:

1. From the Procurement section, select the External Purchase Prices work area and click the Mappings tab at the lower left-side of the page.
2. Create requisitioning BU mappings as follows:
   1. On the Requisitioning BU tab, click Add.
   2. In the Create mapping drawer:
      1. Enter the source organization code or identifier and select the procurement BU to which it needs to be mapped.
      2. Add one or more requisitioning BUs associated with the procurement BU that you selected in the earlier step.
   3. Click Create.
   Tip: You can also create requisitioning BU mappings using the Setup and Maintenance work area. Search for and select the Manage External Purchase Prices Requisitioning BU Mapping task in the Procurement offering and map one or more requisitioning BUs of a procurement BU to a source organization.
3. If you want to create manufacturer mappings, then click the Manufacturer tab and add entries to map the source manufacturer to the corresponding manufacturer defined as a trading partner.
4. If you want to create purchase category mappings, then click the Purchasing Category tab and add a new entry as follows:
   • To map the manufacturer part number to a purchasing category, specify values for the Manufacturer Part and Purchasing Category fields.
   • If a manufacturer part number belongs to different manufacturers, then map the given manufacturer part number and the manufacturer to different purchasing categories.
   • To create mappings based on UNSPSC codes, specify values for the UNSPSC Code and Purchasing Category fields.
5. If you want to create supplier site mappings, then click the Supplier Site tab and add a new entry to map a source supplier to a supplier and supplier site.
   You can also map the same source supplier to different supplier sites in different procurement BUs.
6. If you want to create unit of measure mappings, then click the Unit of Measure tab and add a new entry to map the source unit of measure (UOM) and quantity to a UOM code.
   You can also map the same source unit of measure to different UOM codes for different suppliers.

Tip: To create mappings in bulk, click Download Template. This predefined template uses the Oracle Visual Builder Add-in for Microsoft Excel to download and create external purchase price mappings.