Adding New Mappings
To add a new mapping for the elements available in the Oracle Integration Cloud application schema, the pre-built integration provides a customization template for all the integration flows.
As the Integration is delivered as business accelerator, the base integration flow cannot be edited and they need to clone the existing integration flow to add any customizations to the existing xsl mapper files.
The supported cases are:
• Case1: In the Oracle Utilities Customer Cloud Service application schema, elements exist but are not mapped in the Oracle Integration Cloud pre-built integration.
• Case2: In Oracle Field Service, the properties exist but are not mapped in the Oracle Integration Cloud pre-built integration.
This section provides the steps to add a new mapping using the import xsl.
In this integration, Oracle Utilities Customer Cloud Service is the source and Oracle Field Service is the target.
To add custom mappings in Oracle Integration Cloud layer:
1. Login to Oracle Integration Cloud.
2. Identify the integration to add custom mappings.
3. Clone the Integration.
Refer to the Customizations section in Oracle Field Service Configurations for Oracle Utilities Customer Cloud Service Integration to Oracle Field Service Setup Guide included in this release for instructions to clone the Integration. The documentation is available on Oracle Help Center at:
4. Unzip the .iar file and identify the mapping/xsl file in which the custom mappings have to be added.
5. This integration has all mappers as import xsls. To add any new mapping, edit the respective mapper/xsl file.
Note: Mappings cannot be added using the Mapper Design view.
6. In all integration mappings, a template is added under every complex element. Any custom elements under that complex element can be added directly in the template provided.
7. Add the mapping under the respective customization template. Save the changes.
8. In Oracle Integration Cloud, click the integration to add the mapping for an extra element. Select the respective map activity.
9. Click Import and upload the updated mapper/xsl file.
10. Save and close and activate the integration to reflect the custom mappings.
Following is the list of integrations and the respective mappers/xsls with customization templates defined.
Integration Name
Location of XSL File
Oracle Utilities CCS OFSC Activity Process
OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\resources\processor_430\resourcegroup_433\req_d6b0de6e354d44cf8e0768249b5fa66c.xsl
 
OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\resources\processor_469\resourcegroup_472\req_2c143905deba4c4891091d048bfcbc28.xsl
 
OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\resources\processor_474\resourcegroup_477\req_ae404868fb9e4907a86975bbdb75e1fa.xsl
 
OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_PROCES_01.00.0000\resources\processor_464\resourcegroup_467\req_29b57e613bbe4c8eb2850866951ce1da.xsl
Oracle Utilities OFSC CCS Device Verification
OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\resources\processor_177\resourcegroup_180\req_05949e2168eb499d9027b4aea4fd370b.xsl
 
OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\resources\processor_19\resourcegroup_22\req_9de4224508dc47c49bea25adef82afcb.xsl
 
OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\resources\processor_197\resourcegroup_200\req_7d0bb46fb32b4509969797a1d3576012.xsl
 
OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\resources\processor_44\resourcegroup_47\req_f5c009a3b2bb47d881aaf31b65a269db.xsl
 
OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\resources\processor_264\resourcegroup_267\req_a1f6ce0a3b5a423791d6ea625cd7cb0d.xsl
 
OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_DEVICE_VERIFY_01.00.0000\resources\processor_350\resourcegroup_353\req_95cb7603192e4bda85d7a8c6632574f6.xsl
Oracle Utilities OFSC CCS Activity Create
OUTL-BA-OFSC_CCS_ACTIVITY_CREATE_01.00.0000\icspackage\project\OUTL-BA-OFSC_CCS_ACTIVITY_CREATE_01.00.0000\resources\processor_417\resourcegroup_420\req_9f90c963e5d94ff98b38b2ab22107d63.xsl
Oracle Utilities OFSC CCS Activity Complete
OUTL-BA-OFSC_CCS_ACTIVITY_COMP_01.00.0000\icspackage\project\OUTL-BA-OFSC_CCS_ACTIVITY_COMP_01.00.0000\resources\processor_509\resourcegroup_512\req_358b3cdb3d5745fb8e082acdde659bb2.xsl
Oracle Utilities CCS OFSC Appointment Get
OUTL-BA-CCS_OFSC_APPMT_GET_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_APPMT_GET_01.00.0000\resources\processor_80\resourcegroup_83\req_3636a98aa4a44cae8cdb99ef4f5d5f55.xsl
Oracle Utilities CCS OFSC Activity Get Status
OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\resources\processor_18\resourcegroup_21\req_93d5d20a9bbc4a51800246d1af17262c.xsl
 
OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\resources\processor_35\resourcegroup_38\req_3b615b7222fc48648a2a594ee69c797a.xsl
 
OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\resources\processor_65\resourcegroup_68\req_ea1951b8286e459a92eab6c39b42d525.xsl
 
OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_ACTIVITY_STATUS_01.00.0000\resources\processor_82\resourcegroup_85\req_2770ed549fbe410eb3f0f7d87a56f2a5.xsl
Oracle Utilities OFSC CCS ServicePoint Query
OUTL-BA-CCS_OFSC_SP_QUERY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_SP_QUERY_01.00.0000\resources\processor_36\resourcegroup_39\req_8acd527b3f724df0a3c783ee1a1b6ce2.xsl
 
OUTL-BA-CCS_OFSC_SP_QUERY_01.00.0000\icspackage\project\OUTL-BA-CCS_OFSC_SP_QUERY_01.00.0000\resources\processor_87\resourcegroup_90\req_0b406d5cf3734306b7f5afd49ec8c0d6.xsl
Oracle Utilities CCS OFSC Admin Sync
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_104\resourcegroup_107\req_715e7d9bcdf5411f9317d7051fa272c7.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_1053\resourcegroup_1056\ req_2574482f49fd4020a262818272c13ffe.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_1396\resourcegroup_1399\req_36e778c0cab34841b02cf297bfa0f78e.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_1428\resourcegroup_1431\ req_9202bec21c4246538a3bfb52ad30e87b.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_1927\resourcegroup_1930\ req_bbdc7b2f03be45b29015bea0727dc1c6.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_1944\resourcegroup_1947\ req_34d2ab352c9c4b9cbcc6923119c69ee0.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_219\resourcegroup_222\ req_e5535c199c9a49969fba9737e91c199c.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_2443\resourcegroup_2446\ req_0f2e7dd8bc2a40508af56da12e6727db.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_306\resourcegroup_309\ req_60c0a4cb0a51447ba3db122a2a47df69.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_35\resourcegroup_38\ req_559e9d49354b4b9fae2260a93e274ce5.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_4852\resourcegroup_4855\ req_17a8617480634ec4a963272fe4cddc98.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_5157\resourcegroup_5160\ req_00f344cbdef04eb7b594bd40c03388d5.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_739\resourcegroup_742\ req_79817326d4af40198f854f04a1c9cdeb.xsl
 
OUTL-BA-CCS_OFSC_ADMIN_SYNC_01.00.0000\resources\processor_756\resourcegroup_759\ req_45113dd66d3a453985fadecea6120689.xsl
 
Note: After customizations are added and activated in the Integration, make sure that the generated integration wsdl url is configured in message senders in Oracle Utilities Customer Cloud Service if the integration is triggered from Oracle Utilities Customer Cloud Service. Refer to the Message Senders section in Configuring Oracle Utilities Customer Cloud Service for more details.