Redwood: Transform Data Using Functions in Publication Maps

You can use transformation functions in publication maps to transform the data before publishing it to a target spoke system. You can apply the transformation functions for both TEXT and XML output types. On the Publication Map page, select a mapping and click Transform to open the Transform master attributes drawer, where you can add and validate transformation expressions using functions as shown in the following screenshot.

Transform Master Attributes Drawer

Click Validate to validate the transformation expression as shown in the following screenshot.

Validate Transformation Expression

The following screenshot depicts the validated expression updated in the corresponding mapping.

Expression Updated for Spoke to Master Attribute Mapping

• This feature benefits your business by:
• Providing a flexible output to match ingesting system requirements.
• Providing a configurable and personalized output for each publication channel.
• Enabling faster consumption of product data to your downstream systems.  

Steps to Enable

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

Tips And Considerations

The Transform button is enabled only when you select a single mapping row.

Key Resources

• Refer to the Item Publications section in the Oracle Fusion Cloud SCM: Using Product Master Data Management guide, available on the Oracle Help Center.

Access Requirements

Users who are assigned a configured job role that contains these privileges can access this feature:

• Manage Publication Maps (EGI_MANAGE_PUBLICATION_MAPS_PRIV)
• Manage Publishable Attributes REST (EGI_MANAGE_PUBLISHABLE_ATTR_REST_PRIV)
• Manage Publication Maps REST (EGI_MANAGE_PUBLICATION_MAPS_REST_PRIV)

These privileges were available prior to this update.