Define External Purchase Prices Mappings for Manufacturer Names

Map manufacturer names provided by source systems to the manufacturer names defined as trading partners. When you import external purchase prices, this mapping aligns the manufacturer names as per the mapping definitions.

From this update onwards, manufacturers being imported into External Purchase Prices should either be created as a manufacturer defined in trading partners or mapped to a manufacturer defined as a trading partner. The mapping of manufacturer names is required when the source manufacturer name isn't an exact match to the manufacturer name defined in trading partners in the Product Information Management work area. 

The External Purchase Prices Mappings page has a new Manufacturer tab where you can define manufacturer mappings.

Manufacturer Mapping

From the external purchase price mappings page, you can download the template for external purchase price mappings. This predefined template uses the Oracle Visual Builder Add-in for Microsoft Excel to download, update, and create external purchase price mappings. The template now has a Manufacturer tab where you can define and manage manufacturer mappings.

Manufacturer Mapping Spreadsheet

Manufacturer mapping enables you to translate the value of the manufacturer name from the source system to the corresponding value defined in the Product Information Management work area. This ensures that External purchase prices with valid manufacturer names are imported into the system. The Manufacturer tab in the Oracle Visual Builder Add-in enabled Excel template enables you to achieve significant reduction in data entry efforts by updating the mapping data in bulk.

Steps to Enable

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

Tips And Considerations

All manufacturers that are imported into External purchase Prices should be either created as a manufacturer in trading partners or mapped to a manufacturer defined as a trading partners in the manufacturer mappings.

Access Requirements

Users who are assigned a configured job role that contains these privileges can manage or update the manufacturer mappings using this feature:

• Manage External Purchase Prices Mappings (SCH_MANAGE_EXTERNAL_PURCHASE_PRICES_MAPPINGS_PRIV)
• View Trading Community Organization (HZ_VIEW_TRADING_COMMUNITY_ORGANIZATION_PRIV)

Users who are assigned a configured job role that contains these privileges have a view-only access of the manufacturer mappings using this feature:

• View External Purchase Prices Mappings (SCH_VIEW_EXTERNAL_PURCHASE_PRICES_MAPPINGS_PRIV) 
• View Trading Community Organization' (HZ_VIEW_TRADING_COMMUNITY_ORGANIZATION_PRIV)

These privileges were available prior to this update.