• Bookshelf
  • EAI
  • EAI Value Map
  • EAI Value Type
  • EAILookupExternal
  • EAILookupSiebel
  • Error
  • Knowledgebase
  • SBL-BPR-00162
  • SBL-DAT-00102
  • Siebel
  • Siebel CRM

    • SBL-DAT-00102: Data Transform Error. No entry for lookup key in EAI Value Map. Key: '%1' Type: '%2' Direction: '%3' - Siebel EAI Value Map

    May 29, 2024 Guide

    Error:

    Error invoking service 'EAI Data Transformation Engine', method 'Execute' at step 'Map'.(SBL-BPR-00162)--Data Transform Error. No entry for lookup key in EAI Value Map.   Key:   'Administration Fees'   Type: 'External-Siebel'   Direction: 'Siebel Outbound'(SBL-DAT-00102)

    SBL-DAT-00102: Data Transform Error. No entry for lookup key in EAI Value Map. Key: '%1' Type: '%2' Direction: '%3'

    Reason:

    Value is not defined in EAI Value Map for Outbound direction. External system have different value for "Administration Fees". If this was working before that means external entity have changed the value in their system.

    Below details will help and guide you to resolve this error and understand the EAI Value Map.

    EAI Value Map:

    This is similar to List of Values but defined and use is different. Use case is when integrating with external system most likely external system will have different list of values. So when passing data you will have to use the EAI Value Map. For example Siebel have value "Pakistan" but external system (drop down field) will accept "PAK" as input. EAI Value Maps will help you easily convert the value in Siebel.

    EAI Value Maps have two Directions, Siebel Outbound (1) and Siebel Inbound (2).

    1. When your system will send "Pakistan" EAI Value Maps will convert it to "PAK".
    2. When your system receive "PAK" , Inbound Data Map will convert it to "Pakistan".

    How to define EAI Value Map:

    1. Navigate to site map and Administration - Data -> List of Values.
    2. Create new records against "EAI_LOOKUP_MAP_TYPE" with desired Display and LIC values (EAI Country Map) and Clear Cache.
    3. Navigate to site map and Administration – Integration –> EAI Value Maps.
    4. Create new record define Direction (Siebel Outbound), Siebel Value (Pakistan), External System Value (PAK), Type (Newly created value: EAI Country Map).

    Direction:

    • Sending and receiving data, you can create inbound and outbound maps for the same data
    • Receiving data only, you need only to define an inbound map
    • Sending data only, you need only to define an outbound map

    Source

    How to use:

    Below are two expressions for Outbound and Inbound values.

    For Outbound

    • EAILookupExternal("EAI Value Type",[Source field that lookup will be based on])
    • EAILookupExternal("EAI Country Map","Pakistan")

    For Inbound:

    • EAILookupSiebel ("EAI Value Type",[Source field that lookup will be based on])
    • EAILookupSiebel ("EAI Country Map","PAK").



    You May Also Like