Update Changes to Manufacturer Part Numbers When You Import External Purchase Prices

Import external purchase prices with changed manufacturer part numbers (MPN) and update existing records with the changed MPNs, provided the corresponding trading partner relationship has already been updated in Oracle Product Hub.

When the MPN associated to an item has changed, it will be updated in Oracle Product Hub, but the external purchase prices will still have reference to the old MPN. When updates are sent for such contracts from the group purchasing organizations or source systems with the revised manufacturer part number, the Import External Purchase Prices scheduled process updates the external purchase price lines with the new MPNs.

Prior to this update, if the changed MPN was sent by the source system, a new external purchase price line was created with the new MPN and the existing external purchase price lines with the old MPN had to be canceled. With this feature, the system receives the contract lines with the updated MPN and replaces the old MPN with the new MPN eliminating the need to cancel the existing external purchase price lines.

Steps to Enable

You don't need to do anything to enable this feature.

Tips And Considerations

This feature applies only to item-based external purchase price lines where the MPN has changed. The MPN change must be done in Oracle Product Hub first, such that the item is associated to the new MPN.

This will only update the MPN for the external purchase prices line for which an update is being sent from the group purchasing organizations or source systems. For other lines having the same old MPN, it will continue to remain so till an update is sent for that line.

Key Resources

  • See External Purchase Prices in the Oracle Fusion Cloud Using Procurement guide in Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains the below privilege can access this feature:

  • Import External Purchase Prices (SCH_UPDATE_BPA_FROM_EXTERNAL_PURCHASE_PRICES_PRIV)

These privileges were available prior to this update.