Siebel Community

Welcome to Siebel Community. In this place you can find all the topics related to Siebel. This place is dedicated to provide information about how to implement Siebel CRM application. Siebel Technical/Functional consultants can get information from basics of Siebel CRM to advanced topics like EAI, EIM, eScripting, Workflows, Assignment Manager, Actuate Reports, Territory Management. This place also included Forums and Blogs to help you further.

Tuesday, May 29, 2012

Guidelines to configure additional UCM Source Data and history (SDH) Child objects

1. Create UCM SDH Business Component


Source and Data History are stored in predefined UCM tables.
The primary SDH object for account, contact, financial account, household, address, privacy are store in S_UCM_ORG_EXT, S_UCM_CONTACT, S_UCM_ASSET, S_UCM_ORGGRP, S_UCM_ADDR_PER, and S_UCM_PRIVACY.
All other account child components are stored in table S_UCM_ORG_CHILD, all other contact child components are stored in table S_UCM_CON_CHILD, and all other household child components are stored in table S_UCM_OGP_CHILD.
Since all other child components of each UCM business object are stored in one table, the component object type has to be configured to distinguish the child components.
Naming standard of UCM SDH Business Component:
“UCM” + ”Parent Component Name” + ”Child Component Name” + “Source and Data History”
For example: Using standard field 'Specialty' in Account BC to show Segment information associated to a account.
Segment data is stored in Pharma Professional Primary Specialty Business Component ( S_MED_SPEC table) .
SDH Parent Bus Comp: “UCM Account Source Data and History”
SDH Child Bus Comp: “UCM Account Segment Source Data and History”


Business Component:
Name : UCM Contact Account Source Data and History
Table : S_UCM_ORG_CHILD
Search Specification : [Object Name] = “Pharma Professional Primary Specialty”


Business Component Field:
Name Column Predefault Value
Required fields…
Object Name OBJECT_NAME Pharma Professional Primary Specialty
Object Table OBJECT_TABLE S_MED_SPEC
Par Row Id PAR_ROW_ID
UCM UId UCM_UID Field: ‘Id’


For 1:M relationship… Use character column
Primary Flg ATTRIB_08 N


Additional component specific fields… Use appropriate column for data type and length…
Specialty Code ATTRIB_03
Specialty Name ATTRIB_01

No comments:

Post a Comment