Loading Account Parent-child hierarchy during the Initial Load into UCM

The way to do this in Siebel UCM 8.0 is to use the EIM_UCM_ORG table (one record per account), filling the PAR_OU_ID field with the ROW_ID of the related parent account. This entails the need to load parent accounts before respective children, and get their ROW_IDs. One tiny possible configuration is to add an EIM Foreign Key Mapping for the field S_UCM_ORG_EXT.PAR_OU_ID. This way, it would be possible to specify the parent account using its user key values (name, location, and organization) instead of the ROW_ID.

The attached document describes this change ("How To Add an EIM Foreign Key Mapping for S_UCM_ORG_EXT.PAR_OU_ID.doc").

But take into consideration that Oracle Siebel Expert Service must be involved before applying it in a production environment, since a modification to the S_UCM_ORG_EXT.PAR_OU_ID base table column is needed.


http://www.siebeldigest.com/