Foreign Key Mapping

Foreign keys can now be defined and added in the data dictionary of the source and destination providers, including Gateway. Once defined, the mapping can then be defined in a mapping template.

<FieldMapTemplates>

<App1Name>Sample</App1Name>

<App2Name>P6</App2Name>

<FieldMapTemplate>

<Description>Demonstrating mapping foreign key in a mapping template</Description>

<App1BusinessObjectName>Operation</App1BusinessObjectName>

<Name>Sample Mapping Template</Name>

<PDIBusinessObjectName>Activity</PDIBusinessObjectName>

<FieldMap>

<App1>SampleWorkOrderElementId</App1>

<App2>SampleWBSObjectId</App2>

<PDI>SampleWBSObjectId</PDI>

</FieldMap>

</FieldMapTemplate>

</FieldMapTemplates>

In the metadata XML file or the customization XML file, mark the field as a foreign key and set the JoinTo to the name of the object that this field is joining to as in the example below:

<Field>

<Description>Sample WBS Object IDs</Description>

<Name>SampleWBSObjectId</Name>

<JoinTo>WBS</JoinTo>

<Type>ForeignKey</Type>

</Field>



Legal Notices
Copyright © 2013, 2015, Oracle and/or its affiliates. All rights reserved.

Last Published Wednesday, March 25, 2015