Skip to main content

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

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").



Comments

Popular posts from this blog

How to set Profile Attribute in Siebel Workflow

For setting the Profile Attribute in Siebel Workflow, follow below steps: Add Business Service box in workflow. Open Business Service properties. Set  SessionAccessService in Business Service Name. Set  SetProfileAttr in Method Name. Then click on Business Service and set Input Arguments as below: Against Name argument you will add your profile attribute name and against Value argument you will add value for the new profile attribute, it could be from Process Property or Literal.

How to call Popup Applet through Server Script in Siebel

Background: Based on the requirements you need to show data or reports on a popup applet. You can invoke popup applet using workflow (below business service will be used in business service step), applet server script or browser script and using vanilla method and setting field user properties. Procedure: Below is the script for calling popup applet through server script: if (MethodName == "MethodName") { var oServiceAF = TheApplication().GetService("SLM Save List Service"); var inputPropAF = TheApplication().NewPropertySet(); var outputPropAF = TheApplication().NewPropertySet(); inputPropAF.SetProperty("Applet Name","ABC Popup Applet"); inputPropAF.SetProperty("Applet Mode","6"); inputPropAF.SetProperty("Applet Height", "700"); inputPropAF.SetProperty("Applet Width", "700"); oServiceAF.InvokeMethod("LoadPopupApplet", inputPropAF, outputPropAF) return (CancelOperati...

How to create and publish Inbound Web Service in Siebel based on Workflow

Inbound Web Services: The Inbound Web Service allows an external system to call a Siebel published Web Service. You can publish a business service or a business process as a Web Service and generate a Web Service Definition Language (WSDL) file that an external system can import. The Inbound Web Services can only be published from Siebel C using SOAP-RPC binding. Source: Oracle Docs What Is The Difference Between Web Services and APIs? An API is an interface that allows you to build on the data and functionality of another application, while a web service is a network-based resource that fulfills a specific task. Yes, there’s overlap between the two: all web services are APIs, but not all APIs are web services. Both web services and APIs are — at their core — very useful and very much used today. However, it’s the web services associated with SOAP and/or Service Oriented Architecture which are falling out of favor. Source: NordicApis Process: Prepare the workflow which will serve as Si...