This discussion is archived
1 Reply Latest reply: Sep 28, 2012 1:03 AM by 965000 RSS

How to map between child objects in a Siebel Data Map

petedi Newbie
Currently Being Moderated
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 Newbie
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points