Oracle Customer Hub (UCM) Master Data Management Reference > ASIs and Messages for Oracle Master Data Management Applications > Messages for Oracle Master Data Management Applications >

Contact Relationship


Contact Relationship messages are used in insert, query, update, and delete operations to maintain Contact Relationships. The LookUpContactRelationship and LookUpContactRelationshipByName XML tags are used for query operations. The UpdateContactRelationship, InsertContactRelationship and DeleteContactRelationship XML tags are message pairs for request and response operations. Figure 13 describes the structure of this message.

Figure 13. Contact Relationship Structure

Table 334 lists the Contact Relationship Query Integration objects.

Table 334. Contact Relationship Query Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFContactRelationship

Contact

LookUpContactRelationship

UK1:PartyUId
UK2: Id

CIFContactRelationshipRs

Contact

LookUpContactRelationshipResponse

UK1:PartyUId
UK2: Id

Table 335 lists the Contact Relationship Query by Name Integration objects.

Table 335. Contact Relationship Query by Name Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFContactRelationshipByName

Contact

LookUpContactRelationshipByName

UK1:PartyUId
UK2: Id

CIFContactRelationshipByNameRs

Contact

LookUpContactRelationshipByNameResponse

UK1:PartyUId
UK2: Id

Table 336 lists the Contact Relationship Update Integration objects.

Table 336. Contact Relationship Update Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFContactRelationshipUpdate

Contact

UpdateContactRelationship

UK1:PartyUId
UK2: Id

CIFContactRelationshipUpdateRs

Contact

UpdateContactRelationshipResponse

UK1:PartyUId
UK2: Id

Table 337 lists the Contact Relationship Insert Integration objects.

Table 337. Contact Relationship Insert Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFContactRelationshipInsert

Contact

InsertContactRelationship

UK1:PartyUId
UK2: Id

CIFContactRelationshipInsertRs

Contact

InsertContactRelationshipResponse

UK1:PartyUId
UK2: Id

Table 338 lists the Contact Relationship Delete Integration objects.

Table 338. Contact Relationship Delete Integration Objects
Integration Object
Business Component
XML Tag
User Keys

CIFContactRelationshipDelete

Contact

DeleteContactRelationship

UK1:PartyUId
UK2: Id

CIFContactRelationshipDeleteRs

Contact

DeleteContactRelationshipResponse

UK1:PartyUId
UK2: Id

Table 339 lists the Contact Relationship Integration Component and Integration Component Fields.

Table 339. Contact Relationship Integration Component and Integration Component Fields
Name
XML Tag
Data Type
Length
Req
Comments

IC: Contact

Assistant

Assistant

Text

50

No

None

Assistant Phone #

AssistantPhone

Text

40

No

None

Cellular Phone #

CellularPhone

Text

40

No

None

Email Address

EmailAddress

Text

50

No

None

Fax Phone #

FaxPhone

Text

40

No

None

First Name

FirstName

Text

50

Yes

None

Home Phone #

HomePhone

Text

40

No

None

Id

Id

Id

15

Yes

This tag is required for ID cross-referencing. It stores the incoming external ID.

Integration Id

IntegrationId

Text

30

No

None

Job Title

JobTitle

Text

75

No

None

Last Name

LastName

Text

50

Yes

None

M/F

MF

Text

30

No

Bound by SEX_MF

M/M

MM

Text

15

No

Bound by MR_MS

Manager First Name

ManagerFirstName

Text

50

No

None

Manager Id

ManagerId

Id

No

None

Manager Integration Id

ManagerIntegrationId

Text

30

No

None

Manager Last Name

ManagerLastName

Text

50

No

Used for picking a related entity.

Manager Middle Name

ManagerMiddleName

Text

50

No

None

Manager Primary Organization

ManagerPrimaryOrganization

Text

100

No

None

Manager Primary Organization Id

ManagerPrimaryOrganizationId

Id

15

No

None

Manager UId

ManagerUId

Text

100

No

None

Middle Name

MiddleName

Text

50

No

None

Party UId

PartyUId

Text

100

No

None

Person UId

PersonUId

Text

100

No

None

Preferred Communications

PreferredCommunications

Text

30

No

Bound by OFFER_MEDIA

Status

Status

Text

30

No

Bound by CONTACT_STATUS

Work Phone #

WorkPhone

Text

40

No

None

Work Phone Extension

WorkPhoneExtension

Text

10

No

None

operation

operation

Text

30

No

System field

IC: Account

Account

Account

Text

100

Yes

None

Account Location

AccountLocation

Text

50

No

None

Account Organization

AccountOrganization

Text

100

No

None

Account Party UId

AccountPartyUId

Text

100

No

None

Account Row Id

AccountRowId

Id

15

No

None

Account Status

AccountStatus

Text

30

No

Bound by ACCOUNT_STATUS

IsPrimaryMVG

IsPrimaryMVG

Text

1

No

None

Related Account Integration Id

RelatedAccountIntegrationId

Text

30

No

None

operation

operation

Text

30

No

System field

Household

Household Id

HouseholdId

Id

30

No

None

Household Integration Id

HouseholdIntegrationId

Text

30

No

None

Household Name

HouseholdName

Text

50

No

None

Household Number

HouseholdNumber

Text

100

No

None

Household Party UId

HouseholdPartyUId

Text

100

No

None

Household Status

HouseholdStatus

Text

30

No

Bound by HOUSEHOLD_STATUS

IsPrimaryMVG

IsPrimaryMVG

Text

1

No

None

operation

operation

Text

30

No

System field

Organization

IsPrimaryMVG

IsPrimaryMVG

Text

1

No

None

Organization

Organization

Text

50

No

None

Organization Id

OrganizationId

Id

30

No

None

Organization Integration Id

OrganizationIntegrationId

Text

30

No

None

operation

operation

Text

30

No

System field

IC: Position

Division

Division

Text

255

No

None

IsPrimaryMVG

IsPrimaryMVG

Text

1

No

None

Position

Position

Text

50

No

None

Position Id

PositionId

Id

No

None

Position Integration Id

PositionIntegrationId

Text

30

No

None

Sales Rep

SalesRep

Text

50

No

None

operation

operation

Text

30

No

System field

Oracle Customer Hub (UCM) Master Data Management Reference Copyright © 2014, Oracle and/or its affiliates. All rights reserved. Legal Notices.