Mappings with XML Profiles are getting shuffled automatically

Document created by janaki_dangeti on May 8, 2015Last modified by vreddy on Mar 1, 2016
Version 2Show Document
  • View in full screen mode

Scenario where multiple duplicate elements of complex types are defined with the same name at the same level and one of the element from each element of complex type is mapped to destination profile elements. When the destination profile is re-imported in the map then the mappings get shuffled.

 

For eg: In XML profile,Multiple address_information elements are defined with different Identifier instances lets say Home,Business & Mailing as shown below.

0EM40000000bpJr

Mapping before the destination profile is re-imported

Address_Information/Last_modified_on    (home)                                               ModifiedDate1
Address_Information[address_type=home]/Last_modified_on                         ModifiedDate2
Address_Information/Last_modified_on  
(business)                                         ModifiedDate3
Address_Information[address_type=business]/Last_modified_on                    ModifiedDate4
Address_Information/Last_modified_on  
(mailing)                                           ModifiedDate5
Address_Information[address_type=mailing]/Last_modified_on                     
ModifiedDate6

Mapping after the destination profile is re-imported

Address_Information/Last_modified_on    (mailing)                                             ModifiedDate1
Address_Information[address_type=home]/Last_modified_on                         ModifiedDate2
Address_Information/Last_modified_on  
(mailing)                                             ModifiedDate3
Address_Information[address_type=business]/Last_modified_on                    ModifiedDate4
Address_Information/Last_modified_on  
(mailing)                                             ModifiedDate5
Address_Information[address_type=mailing]/Last_modified_on                     
ModifiedDate6

 

Mappings get scrambled because defining multiple elements of complex type with the same name at the same level creates an invalid XML profile.
Profile should only contain single element at same level instead of multiple duplicate elements & add identifier instance to the single element and map the elements accordingly.

 

For eg Identifier instance should be defined as below:

0EM40000000bpJm

 

 

Attachments

    Outcomes