Oracle Customer Hub (UCM) Master Data Management Reference > Configuring the MDM Foundation and Workflows > Configuring Workflows and the MDM Foundation >
About Oracle Master Data Management Applications Integration Services
Oracle Master Data Management Applications provide objects called business services, which you can reuse in multiple applications. These business services perform the insert, update, query, and delete operations on data in Oracle Master Data Management Applications. You can use these business services together in the prebuilt workflow processes or build your own workflow processes or business services. The Siebel Connector for the Master Data Applications provides the following prebuilt business services that you can configure to meet your business requirements:
You can configure business services by manipulating their user properties, or you can create your own business service in Siebel Tools. For information on using Siebel Tools to configure your application, see Configuring Siebel Business Applications. NOTE: After you have configured your business services to accomplish the tasks required for your business, you must compile the business service to include the new information in your Siebel Repository file (.srf). Then copy the .srf file to the directory where your Siebel Servers can access it.
For more information on the integration services and Oracle Master Data Applications architecture, see About Oracle Customer Hub (UCM) Architecture and other topics in Architecture and Framework of Oracle Customer Hub (UCM). UCM Transaction Manager Business Service
You can extend this business service by manipulating its Operational user property. Table 107 lists the user properties examples for the UCM Transaction Manager. Use the following basic format to enter values for each operation. CIFOperation_Query
CIFOperation_Query user properties use the following format: Service/Method/Argument;Argument; or /Method/Argument;Argument;
where:
- Service, Method, and Argument are separated by a slash mark (/).
- Each argument ends with a semicolon (;).
CIFOperation_XMLQuery
CIFOperation_XMLQuery user properties use the following format: EAI Siebel Adapter/Query/#XMLHierarchy;
where:
- The default service name is EAI Siebel Adapter, and the default argument name is SiebelMessage.
- SiebelMessage indicates turning off the SiebelMessage.
- XMLHierarchy indicates replacing SiebelMessage with XMLHierarchy.
CIFOperation_GetValue
CIFOperation_GetValue user properties use the following format: FINS Industry/BC Facility Service/HierarchySearchSpec/!SiebelMessage;A=>B;
where:
- A=>B means getting argument value of A from argument value of B where argument B is an argument of the Connector Integration Object Instance.
Table 107 lists the user properties examples for the UCM Transaction Manager.
Table 107. User Properties for UCM Transaction Manager
UCM Transaction Manager User Property Name |
|
Account Address Field 1 |
Street Address;Street Address |
Account Address Field 2 |
City;City |
Account Address Field 3 |
State;State |
Account Address Field 4 |
Postal Code;Postal Code |
Account Address Field 5 |
Country;Country |
Account Address Primary CUT Address |
Primary Address Id;Account_Business Address |
Contact Address Field 1 |
INS Personal Street Address;Street Address |
Contact Address Field 2 |
INS Personal City;City |
Contact Address Field 3 |
INS Personal State;State |
Contact Address Field 4 |
INS Personal Postal Code;Postal Code |
Contact Address Field 5 |
INS Personal Country;Country |
Contact Address Primary Personal Address |
Primary Personal Id;Contact_INS Personal Address |
DisableSessionRealtimeClns |
TRUE |
DisableSessionRealtimeDeDup |
TRUE |
DispatcherMapName |
CIFDispMap |
Enable Updating SDH Type on Error |
TRUE |
EnableAgentLock |
TRUE |
EnableCrossReferenceForQuery |
None |
Household Address Field 1 |
Street Address;Street Address |
Household Address Field 2 |
City;City |
Household Address Field 3 |
State;State |
Household Address Field 4 |
Postal Code;Postal Code |
Household Address Field 5 |
Country;Country |
Household Address Primary CUT Address |
Primary Household Address Id;Household_Household Address |
Insert_IOandOp_Account |
CIFAccountInsert;CIFAccountInsertRs;IXMLOperation_ADD |
Insert_IOandOp_Contact |
CIFContactInsert;CIFContactInsertRs;IXMLOperation_ADD |
Insert_IOandOp_FINCORP Account |
CIFFINCORPAccountInsert;CIFFINCORPAccountInsertRs;IXMLOperation_ADD |
Insert_IOandOp_Household |
CIFHouseholdInsert;CIFHouseholdInsertRs;IXMLOperation_ADD |
IONameForQueryBV_Account |
CIFAccount |
IONameForQueryBV_Contact |
CIFContact |
IONameForQueryBV_FINCORP Account |
CIFFINCORPAccount |
IONameForQueryBV_Household |
CIFHousehold |
IXMLOperation_ADD |
EAI Siebel Adapter/Insert/ |
IXMLOperation_DELETE |
EAI Siebel Adapter/Delete/ |
IXMLOperation_QUERY |
EAI Siebel Adapter/Query/ |
IXMLOperation_QUERY_BY_ID |
EAI Siebel Adapter/Query/PrimaryRowId;!SiebelMessage; |
IXMLOperation_QUERYPAGE |
EAI Siebel Adapter/QueryPage/NewQuery=>IXML_NewQuery;SearchSpec=>SearchSpec;StartRowNum=>IXML_StartRowNum;PageSize=>IXML_PageSize;SERVICE_VALUE_RETURN;$LastPage=>IXML_LastPage;$NumOutputObjects=>IXML_NumOutputObjects; |
IXMLOperation_SYNCH |
EAI Siebel Adapter/Synchronize/ |
IXMLOperation_UPDATE |
EAI Siebel Adapter/Update |
IXMLOperation_UPSERT |
EAI Siebel Adapter/Upsert/ |
MaxNumQueryOutputObjects |
50 |
Operation Delete |
IXMLOperation_DELETE |
Operation Insert |
IXMLOperation_ADD |
Operation Query |
IXMLOperation_QUERY;IXMLOperation_QUERY_BY_ID;SOAPOperation_Query |
Operation Update |
IXMLOperation_UPDATE |
Operation Upsert |
IXMLOperation_UPSERT |
Primary Object 1 |
Address/CIFPersonalAddress |
RealtimeInsertAutoMatch_Account |
CIFAccountUpdate;CIFAccountUpdateRs;IXMLOperation_UPDATE |
RealtimeInsertAutoMatch_Contact |
CIFContactUpdate;CIFContactUpdateRs;IXMLOperation_UPDATE |
RealtimeInsertAutoMatch_Household |
CIFHouseholdUpdate;CIFHouseholdUpdateRs;IXMLOperation_UPDATE |
SDHCommitSize |
5 |
SOAPOperation_Delete |
EAI Siebel Adapter/Delete/ |
SOAPOperation_Insert |
EAI Siebel Adapter/Insert/ |
SOAPOperation_Query |
EAI Siebel Adapter/Query/ |
SOAPOperation_Update |
EAI Siebel Adapter/Update/ |
SOAPOperation_Upsert |
EAI Siebel Adapter/Upsert/ |
Update_IOandOp_Account |
CIFAccountUpdate;CIFAccountUpdateRs;IXMLOperation_UPDATE |
Update_IOandOp_Contact |
CIFContactUpdate;CIFContactUpdateRs;IXMLOperation_UPDATE |
Update_IOandOp_FINCORP Account |
CIFFINCORPAccountUpdate;CIFFINCORPAccountUpdateRs;IXMLOperation_UPDATE |
Update_IOandOp_Household |
CIFHouseholdUpdate;CIFHouseholdUpdateRs;IXMLOperation_UPDATE |
Upsert_IOandOp_Account |
CIFAccountUpsert;CIFAccountUpsertRs;IXMLOperation_UPSERT |
Upsert_IOandOp_Contact |
CIFContactUpsert;CIFContactUpsertRs;IXMLOperation_UPSERT |
Upsert_IOandOp_FINCORP Account |
CIFFINCORPAccountUpsert;CIFFINCORPAccountUpsertRs;IXMLOperation_UPSERT |
Upsert_IOandOp_Household |
CIFHouseholdUpsert;CIFHouseholdUpsertRs;IXMLOperation_UPSERT |
UCM Converter Business Service
Table 108 displays the only user property you can configure for this business service. This value appears in the preheader section of your Customer Relationship Management Markup Language (CRMML) message.
Table 108. User Property for UCM Converter
UCM Converter User Property Name |
|
XMLEnvIntObjectName |
The seed data name of the envelope integration object or the name you chose. |
The UCM Converter uses the hierarchy represented in the UCM integration object to guide the message through the conversion process. The conversion process iterates through the requests and responses in the message, and if the integration object instance receives elements that do not have a definition defined in the integration object definition, the UCM Converter generates an error. If you expect such a situation, you can set the Ignore Undefined XML Tag parameter on the user property of the corresponding integration object. NOTE: This user property is created by the wizard and is set to Y. You can turn the setting off if you want the UCM Converter to error out.
UCM Cross Reference Business Service
The user properties for this business service appear in Table 109.
Table 109. User Property for UCM Cross Reference Service
UCM Cross Reference Property Names |
|
CompFieldMap Account_Business Address |
CIF Account Address Reference:Address Id;;Address Id |
CompFieldMap Contact_Alternate Phone |
CIF Alternate Phone Reference:Alternate Phone Id;;Alternate Phone Id |
CompFieldMap Contact_Communication Address |
CIF Communication Address Reference:Communication Address Id;;Communication Address Id |
CompFieldMap Contact_INS Personal Address |
CIF Contact Address Reference:Address Id;;INS Personal Address Id |
CompFieldMap FINCORP Account |
CIF FINCORP Account Reference:FINCORP Account Id;;Id |
CompFieldMap FINCORP Deposit Account |
CIF FINCORP Deposit Account Reference:FINCORP Deposit Account Id;;Id |
CompFieldMap FINCORP Loan Account |
CIF FINCORP Loan Account Reference:FINCORP Loan Account Id;;Id |
CompFieldMap UCM HE Constituent Name |
CIF Contact Name Reference:Contact Name Id;;Id |
EnableChildCrossReferenceForQuery |
None |
Generate UID Service Method |
GenerateID |
Generate UID Service Method Arg 1 |
IDType:GUID |
Generate UID Service Name |
FINS Teller Converter Extensions |
MaxNumChildCrossReferenceForQuery |
10 |
UCM Dispatcher Business Service
You can modify both user properties for this business service as shown in Table 110.
Table 110. User Properties for UCM Dispatcher
UCM Dispatcher User Property Name |
|
DispatcherMapName |
The name of the dispatcher map shipped or that you customized. |
XMLEnvIntObjectName |
The name of the envelope integration object shipped or that you customized. |
UCM Security Manager Business Service
You can modify or extend this business service by manipulating its user properties. Table 111 displays these user properties.
Table 111. User Properties for UCM Security Manager
UCM Security Manager User Property Name |
|
IXMLOperation_ADD |
Insert |
IXMLOperation_DELETE |
Delete |
IXMLOperation_QUERY |
Query |
IXMLOperation_QUERYPAGE |
Query |
IXMLOperation_UPDATE |
Update |
IXMLOperation_UPSERT |
Upsert |
UCM Data Quality Manager
The user properties for this business service appear in Table 112.
Table 112. User Properties for UCM Data Quality Manager
UCM Data Quality Manager User Property Name |
|
Account Account Cleansing Field 1 |
Name:Name;Location:Location; |
Account Account Matching Field 1 |
Name:Name;DUNS Number:DUNS Number; |
Account Account_Business Address Cleansing Field 1 |
Street Address:Street Address;City:City;State:State;Postal Code:Postal Code;Country:Country; |
Account Account_Business Address Matching Field 1 |
Street Address:Primary Account Street Address;City:Primary Account City;State:Primary Account State;Postal Code:Primary Account Postal Code;Country:Primary Account Country; |
Account Auto Threshold |
90 |
Account Cleansing Component 1 |
Account:Account;Account_Business Address:CUT Address; |
Account Manual Threshold |
70 |
Account Matching Component 1 |
Account:Account;Primary Account_Business Address; |
Contact Auto Threshold |
90 |
Contact Cleansing Component 1 |
Contact:Contact;Contact_INS Personal Address:Personal Address;Contact_Account:Account; |
Contact Contact Cleansing Field 1 |
Last Name:Last Name;First Name:First Name;Middle Name:Middle Name;Job Title:Job Title; |
Contact Contact Matching Field 1 |
Last Name:Last Name;First Name:First Name;Middle Name:Middle Name;Work Phone #:Work Phone #;Cellular Phone #:Cellular Phone #;Home Phone #:Home Phone #; |
Contact Contact Matching Field 2 |
Email Address:Email Address;Social Security Number:Social Security Number;Birth Date:Birth Date; |
Contact Contact_Account Cleansing Field 1 |
Account:Name;Account Location:Location; |
Contact Contact_Account Matching Field 1 |
Account:Account; |
Contact Contact_INS Personal Address Cleansing Field 1 |
INS Personal Street Address:Street Address;INS Personal City:City;INS Personal State:State;INS Personal Postal Code:Postal Code;INS Personal Country:Country; |
Contact Contact_INS Personal Address Matching Field 1 |
INS Personal Street Address:Primary Personal Street Address;INS Personal City:Primary Personal City;INS Personal State:Primary Personal State;INS Personal Postal Code:Primary Personal Postal Code;INS Personal Country:Primary Personal Country; |
Contact Manual Threshold |
70 |
Contact Matching Component 1 |
Contact:Contact;Primary Contact_INS Personal Address;Contact_Account; |
Enable XRef Match |
false |
ExactMatch Object 1 |
Account:CIFAccount;Contact:CIFContact; |
UCM Batch Manager Business Service
The user properties for this business service appear in Table 113.
Table 113. User Properties for UCM Batch Manager
UCM Batch Manager User Property Name |
|
Account AutoMatch |
CIFAccountUpdate;CIFAccountUpdateRs;IXMLOperation_UPDATE |
Account NoMatch |
CIFAccountInsert;CIFAccountInsertRs;IXMLOperation_ADD |
Contact AutoMatch |
CIFContactUpdate;CIFContactUpdateRs;IXMLOperation_UPDATE |
Contact NoMatch |
CIFContactInsert;CIFContactInsertRs;IXMLOperation_ADD |
FINCORP Account NoMatch |
CIFFINCORPAccountInsert;CIFFINCORPAccountInsertRs;IXMLOperation_ADD |
Household AutoMatch |
CIFHouseholdUpdate;CIFHouseholdUpdateRs;IXMLOperation_UPDATE |
Household NoMatch |
CIFHouseholdInsert;CIFHouseholdInsertRs;IXMLOperation_ADD |
UCM Survivorship Engine
The user properties for this business service appear in Table 114.
Table 114. User Properties for UCM Survivorship Engine
UCM Survivorship Engine User Property Name |
|
BRCurrencyFldConstruct_Contact |
Income:Income Currency Code,Income Exchange Date |
DefaultAttrGrpName_Account |
Default Account Attribute Group |
DefaultAttrGrpName_Contact |
Default Contact Attribute Group |
DefaultAttrGrpName_Household |
Default Household Attribute Group |
ExemptFields_Account |
Party UId;Id |
ExemptFields_Contact |
Party UId;Person UId;Id |
ExemptFields_Household |
Party UId;Id |
ExternalBSIOInterface_Account |
UCMAccountAttributeGroupMetaData |
ExternalBSIOInterface_Contact |
UCMContactAttributeGroupMetaData |
ExternalBSIOInterface_Household |
UCMHouseholdAttributeGroupMetaData |
KnowledgeBaseName |
ucmsurvivorshiprules |
NULLValueOverride_Account |
TRUE |
NULLValueOverride_Contact |
TRUE |
NULLValueOverride_Household |
TRUE |
EntityInternalProcess<ChildObjectName> |
TRUE |
UCM Account Source Data and History Service
The user properties for this business service appear in Table 115.
Table 115. User Properties for UCM Account Source Data and History Service
UCM Account Source Data and History User Property Name |
|
Application Services Interface |
Y |
Internal Integration Object |
UCMAccountSourceDataAndHistory |
UCM Contact Source Data and History Service
The user properties for this business service appear in Table 116.
Table 116. User Properties for UCM Contact Source Data and History Service
UCM Contact Source Data and History User Property Name |
|
Application Services Interface |
Y |
Internal Integration Object |
UCMContactSourceDataAndHistory |
UCM FINCORP Account Source Data and History Service
The user properties for this business service appear in Table 117.
Table 117. User Properties for UCM FINCORP Account Source Data and History Service
UCM FINCORP Account Source Data and History User Property Name |
|
Application Services Interface |
Y |
Internal Integration Object |
UCMFINCORPAccountSourceDataAndHistory |
UCM Household Source Data and History Service
The user properties for this business service appear in Table 118.
Table 118. User Properties for UCM Household Source Data and History Service
UCM Household Source Data and History User Property Name |
|
Application Services Interface |
Y |
Internal Integration Object |
UCMHouseholdSourceDataAndHistory |
|