value mapping not working properly

[rasjoshi]

Hi All,

I am using value mapping twice in same mapping program. But only 1 field is coming with value and other is taking same value from source payload, can you please tell me what can be issue here?

Value mapping 1 -

Context - http://sap.com/xi/XI

SenderParty- SenderSchema

ReceiverParty- ReceiverSchema

Value Mapping table in ID -

Value mapping at field 2 -

Context - http://sap.com/xi/XI

SenderParty1- SenderSchema1

ReceiverParty2- ReceiverSchema2

Value Mapping table in ID -

Source payload -

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_VM_Send xmlns:ns0="http://xyz.com/Rashmi_CollectPatternDemo">

   <Record>

      <Emp_ID>123</Emp_ID>

      <Name>rash</Name>

      <Surname>sumit</Surname>

      <Gender>Male</Gender>

     <Grade>E2</Grade>

  </Record>

</ns0:MT_VM_Send>

Target Payload -

<?xml version="1.0" encoding="UTF-8"?>

<ns0:MT_VM_Receiver xmlns:ns0="http://xyz.com/Rashmi_CollectPatternDemo">

<Record>

<Emp_ID>123</Emp_ID>

<Full_Name>rash sumit</Full_Name>

<Designation>E2</Designation>

<Gender>M</Gender>

<Travel_Mode>Train</Travel_Mode>

</Record>

</ns0:MT_VM_Receiver>

Here travel_mode is coming perfect, but designation is same as defined in source payload. Why here Value mapping not working???

Thanks & regards,

Rashmi Joshi

[former_member228170]

Hi,

    The designation is same as defined in source payload because the Value Mapping Lookup is failing and in Value Mapping Properties the selected Behaviour option would be Use Key when the Lookup Fails.

The reason why it is failing might be because the Grade group in Value Mapping Agencies might not be activated or the other reason might be Value Mapping is case sensitive, check whether the Agency and Scheme names are same in IR and ID and check the case sensitivity of the values.

[Harish]

Hi Rashmi,

The problem would either be in cache update or your mapping. Please provide the sceenshot of mapping (after clicking the value mapping function).

you can also choose the option to throw error in value mapping function, so it will throw error when value not found.

regards,

Harish