External Purchase Prices Mappings

When the external purchase prices are imported from an external application, the values of some of the attributes may be different from the corresponding values in Oracle Fusion Cloud Procurement. External purchase prices mappings helps you to bridge this gap.

You can create mappings using the Manage External Purchase Prices Business Unit Mapping setup task or from the External Purchase Prices Mappings page. To create or update the mapping data in bulk, download the template from the External Purchase Prices Mappings page. The Import External Purchase Prices process uses this data to translate the value of the attributes in the source system to the corresponding value in Oracle Procurement.

Attributes	Description
Requisitioning BU	Map the source organization code or identifier to one or more requisitioning business units belonging to a procurement BU. A requisitioning business unit can be mapped to only one active source organization.
Purchasing Category	Map the manufacturer part number to a purchasing category. In case a manufacturer part number belongs to different manufacturers, you can map that manufacturer part number combined with different manufacturers, to different purchasing categories. This mapping is required only when a manufacturer part number isn't associated to an item number in the item relationships.
Supplier Site	Map a source supplier to a supplier and supplier site. You can map the same source supplier to different supplier sites in different procurement BUs.
Unit of Measure	Map the source unit of measure (UOM) and quantity to a UOM code. The same source unit of measure can be mapped to different UOM codes for different suppliers.

Work with Requisitioning BU Mappings

Map multiple requisitioning business units to a source organization and create external purchase prices for the group of requisitioning business units specified in these mappings. The purchase agreements created from these external purchase prices are accessible to all the requisitioning BUs in the group.

If any purchase agreements couldn’t be updated due to errors after you create or modify the mappings, the error status is shown for those mappings in the requisitioning BU mapping page. The external purchase prices work area also displays the number of purchase agreements in error. Drill down from the card to the purchase agreement exceptions page to view the error details. After resolving the errors, update the purchase agreements by submitting the scheduled process Update BU Access for Purchase Agreements Created from External Purchase Prices.

Create a Requisitioning BU Mapping

To create a new mapping,

1. Click Add on the External Purchase Prices Mappings page to open the Create Mapping panel.
2. Enter the name of the source organization and select the procurement BU.
3. In the Requisitioning BU section, add requisitioning BUs of that procurement BU from the drop-down list and click Create.

Add Requisitioning BUs to an Existing Mapping

You can modify the list of requisitioning BUs mapped to a source organization at any time. To add requisitioning BUs to an existing mapping:

1. On the External Purchase Prices Mappings page click on a source organization’s requisitioning BUs to open the Manage Mappings panel.
2. Add requisitioning BUs and click Update.

   If external purchase prices exist for the mapping, the BU access of the purchase agreements created for those external purchase prices are automatically updated with the newly added requisitioning business units.

If any purchase agreements couldn’t be updated due to errors, the error status is shown for those mappings in the requisitioning BU mapping page and the external purchase prices work area displays the number of purchase agreements in error. Drill down from the card to the purchase agreement exceptions page to view the error details. After resolving the errors, update the purchase agreements by submitting the scheduled process Update BU Access for Purchase Agreements Created from External Purchase Prices.

Remove Requisitioning BUs from an Existing Mapping

You can delete requisitioning BUs mapped to a source organization on the Mapping Details panel by clicking the delete button against the requisitioning BU’s name. These conditions must be met for requisitioning BUs to be deleted from an existing requisitioning BU mapping:

• There must be no purchase agreements created for the external purchase prices tied to those requisitioning BUs.
• The source organization must have more than one requisitioning BU mapped to it. If there’s only one requisitioning BU mapped to a source organization, you can’t delete that requisitioning BU from the mapping.

However, if purchase agreements exist for the external purchase prices that are tied to the requisitioning BUs that you want to delete, follow these steps to delete those requisitioning BUs:

1. From the mapping, identify the external purchase price lines that are tied to the requisitioning BUs that you want to delete and exclude them from purchasing. You can exclude the lines for purchasing using one of these methods:
   1. On the External Purchase Prices page, select those lines and click Exclude from Selection.
   2. Click Download Template and modify the status using the Canceled Flag, upload the changes.
2. Submit the Import Purchase Agreements from External Purchase Prices scheduled process to end date the excluded external purchase price lines in the purchase agreements.
3. On the Mapping Details panel, delete the requisitioning BUs from the mapping.
4. Include the excluded lines for purchasing manually using one of these methods:
   1. On the External Purchase Prices page, select those lines and click Include for Purchasing.
   2. Click Download Template and modify the status using the Purchase Enabled Flag, upload the changes.
5. Submit the Import Purchase Agreements from External Purchase Prices scheduled process again to create new purchase agreements with the revised list of requisitioning BUs for these external purchase prices.
6. You can verify that the lines are updated with an end date and cancel the lines as they are no longer in use.

On the Mapping Details panel, you can change the status of the mapping to inactive by turning off the Active switch. For the status to be changed to inactive, the mapping must not be used in other external purchase prices in any status other than canceled.