1 Reply Latest reply: Sep 28, 2012 3:03 AM by 965000 RSS

    How to map between child objects in a Siebel Data Map

    PeteDi
      Hello. I need to map a field from one child object to another child object using a Siebel Data Map.
      Specifically, I have an Integration Object set up for FINS Group Policy with 2 child components (Action and Proposal). I want to map the Proposal's name to the Activity's Description. Here's the structure:
      Policy (io)
      -Name
      -Action (io)
      --Description
      -Proposal (io)
      --PPSLFileName (this is the proposal's file name)

      I can map from the parent (Policy) to the child (Action) as follows:
      Integration Component Map: Action-to_Action
      Source Expression: [FINS Group Policy.Name]
      Target Field Name: Description

      This will map the Policy's Name to the Activity's Description.

      I tried these, but they don't work:
      1)
      Integration Component Map: Action-to_Action
      Source Expression: [FINS Group Policy.Proposal.PPSLFileName]
      Target Field Name: Description
      2)

      Integration Component Map: Action-to_Action
      Source Expression: [Proposal.PPSLFileName]
      Target Field Name: Description

      Thanks for any help
        • 1. Re: How to map between child objects in a Siebel Data Map
          965000
          Hi,

          For your issue,you can use the 2nd point what u hv mentioned :-

          Integration Component Map: Action-to_Action
          Source Expression: [Proposal.PPSLFileName]
          Target Field Name: Description

          But it has some limitations,i.e the child's(Proposal) cardinality should be 1 or less than 1 i.e no. of instances of Proposal IC should not exceed 1 or else the data map will error out at runtime.

          Regards,
          Sambit