Integration Platform Technologies: Siebel Enterprise Application Integration > Integration Objects > About Integration Component Keys >

Hierarchy Parent Keys


The Hierarchy Parent Key is used for integration objects that have a homogeneous hierarchy. This key must have only the Parent Id. The Hierarchy Parent Key is used for maintaining the hierarchy and keeping the data normalized.

For example, when you insert quotes, each quote item in turn can have more quote items. In this case, the first quote item inserted by the EAI Siebel Adapter has the Parent Id set to blank, but for each child quote item, the EAI Siebel Adapter checks the keys to figure out which fields are to be set. If the Hierarchy Parent Key is not defined, then the child quote item is inserted as a new quote item without a link to its parent (denormalized).

NOTE:  You cannot rearrange the hierarchy after it has been created. For example, if A is a parent of B, and you try to upsert B as a parent of A, an error will occur. Instead you must delete the hierarchy and then re-create it.

Integration Platform Technologies: Siebel Enterprise Application Integration Copyright © 2010, Oracle and/or its affiliates. All rights reserved. Legal Notices.