Manage Service mappings

Service Mapping Entities

You must use a sand box to edit a service mapping. If you access the Manage Service Mappings page outside of a sandbox, then the actions that you need to edit the mapping, such as Add Row, are unavailable.

From the Sandbox edit page, select Manage Service Mapping from the task menu to create or manage your service mapping. The AssetIntegration service mapping is predefined with the delivered values.

These entities contain a set of attributes available for the integration:

AssetOrderMap
SalesOrderFulfillLine
SalesOrderHeader

You can add new attributes to an existing entity or to a new entity. It's recommended that you create new source entities and add new attributes for the destination entity. You must append the newly created entity attributes with the word _Custom. For example, Header EFF_Custom or LineEFF_Custom.

You also can add your attributes on an existing entity by adding them below below the AssetOrderMap: Details Region.

Service Mapping - Source Tab

This tab enables you to reference your inputs and output Service Data Objects (SDO). The service mapping uses the Source tab to structure both objects. In this section, you can select your existing entity and map your newly created attributes, along with the view object attributes. For example, the AssetAppCompChar4_Custom attribute is mapped against the ExtnAttributeChar003 Application composer extended attribute.

When you create a new entity, enter these values in the columns of the newly added row.

Column Name	Column Value	Notes
Entity	HeaderEFF_Custom	This is the entity name defined on your entity tab.
Type	View Object	Select this value.
View Object	HeaderEffBHeaderContext1privateVO	This view object is extracted from the Download Flexfield Archive option on the Manage Extensible Flexfields page.
Query Type	Join	Select this value.
Query Attribute	HeaderId	This is the unique identifier for the view object selected.
Join Entity	SalesOrderHeader	This column appears when you select the Add more columns option.
Join Entity Attribute	HeaderId	This column appears when you select the Add more columns option.

Note: Go to Set Up and Maintenance > Manage Extensible FlexField > Name Header Information > Action > Download Flexfield Archive to extract the view object. Extract the .ZIP file named DOO_HEADER_ADD_INFO. The extracted folder contains a list of contextual .XML files that are used in the sales order header.

Select a sales order line to create a new row. Note that you might have to enter these values into this row.

Column Name	Column Value	Notes
Entity	LineEFF_Custom	This is your entity name set up on your entity tab.
Type	View Object	Select this value.
View Object	FulfillLineEffBFulfillLineContext1privateVO	This view object is extracted from the Download Flexfield Archive option on the Manage Extensible Flexfields page.
Query Type	Join	Select this value.
Query Attribute	FulfillLineId	This is the unique identifier for the view object selected.
Join Entity	SalesOrderFullfillment	This column renders with the Add more columns option.
Join Entity Attribute	FulfillmentLineId	This column renders with the add more columns option.

Note: Go to Set Up and Maintenance > Manage Extensible FlexField > Name Header Information > Action > Download Flexfield Archive to extract the view object. Extract the generated DOO_FULFILL_LINE_ADD_INFO.zip file. The extracted folder contains a list of contextual .XML files that are used in the sales order fulfillment lines.

Service Mapping - Service Tab

Use the Services tab to set up your attribute’s characteristics. Most likely, you will set up your destination entities and attributes as READ and WRITE, this will allow you to perform downstream corrections with the spreadsheet task option. You should set up your source attributes, however, as READ only. All the entities and attributes that you previously set up on the Entities and Source tabs must also be added here.