1. SOAP Web Services for Sales and Fusion Service
  2. Contact

Contact

The profile information of the trading community person. The profile includes information such as marital status and additional name.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/personService/}PersonProfile

Relationships

The following table describes how this service data object is related to other service data objects or business object services.

Relationship Type Object or Service

Contains

Trading Community Person Profile Additional Information

Contained by

Trading Community Person Details

Contained by

Sales Account

Contained by

Loyalty Member

Handled by

Sales Account Service

Handled by

Sales Party

Handled by

Loyalty Member Service

Handled by

Company and User Registration

Handled by

Sales Party Resource Service

Handled by

Sales Party Territory service

Handled by

Trading Community Person Information

Attributes

The following table describes attributes in the service data object.

Name Type Description

Alias

string

Person alias name.

CertReasonCode

string

The reason for the organization party's current certification level assignment as indicated by the HZ_PARTY_CERT_REASON lookup type.

CertificationLevel

string

The certification level the organization party as indicated in the HZ_PARTY_CERT_LEVEL lookup type.

Comments

string

The comments for the record.

CorpCurrencyCode

string

The corporate currency code associated with the record. This attribute is used by CRM Extensibility framework.

CreatedBy

string

The user who created the record.

CreatedByModule

string

The module that created the record.

CreationDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was created.

CurcyConvRateType

string

The currency conversion rate associated with the record. This attribute is used by CRM Extensibility framework.

CurrencyCode

string

The currency code. This attribute is used by CRM Extensibility framework.

DataCloudStatus

string

The enrichment status of the person.

DateOfBirth

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the person was born.

DateOfDeath

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the person died.

DeceasedFlag

boolean

Y or N indicates whether the person is deceased or not.

DeclaredEthnicity

string

The declared ethnicity of the person.

Department

string

The free form text used to name the department.

DepartmentCode

string

The list of values for possible department codes.

Distance

decimal

The distance from the input location.

DoNotCallFlag

boolean

Indicator to specify if the user can send mail to the person or not.

DoNotContactFlag

boolean

Indicator to specify if the user can contact the person through phone, e-mail, or mail or not.

DoNotEmailFlag

boolean

Indicator to specify if the user can send e-mail to the person or not.

DoNotMailFlag

boolean

Indicator to specify if the user can send mail to the person or not.

EffectiveEndDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the end of the date range within which the row is effective.

EffectiveLatestChange

string

The date effective entity. Y indicates that this row represents the latest change in the day.

EffectiveSequence

int

The date effective entity. Indicates the order of different changes made during a day. The lowest value represents the earliest change in the day.

EffectiveStartDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date at the beginning of the date range within which the row is effective.

FavoriteContactFlag

boolean

Indicator to specify if the person is key contact.

Gender

string

The gender details such as male, female, or unknown of the person.

HeadOfHouseholdFlag

boolean

The head of household indicator is not used.

HouseholdIncomeAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The household income amount is not used.

HouseholdSize

decimal

The household size is not used.

InternalFlag

boolean

The denormalized value of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.

JgzzFiscalCode

string

The taxpayer identification number. It can be the unique identifier of the person or organization. It can also be the SSN or income taxpayer ID in US, fiscal code or NIF in Europe.

JobTitle

string

The free form text for the job title.

JobTitleCode

string

The code given to the job title.

LastContactDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the contact was last contacted.

LastEnrichmentDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the person was last enriched in DaaS.

LastKnownGPS

string

The geophysical location that is, GPS point last reported for the person.

LastSourceUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated by the source application.

LastUpdateDate

{http://xmlns.oracle.com/adf/svc/types/}dateTime-Timestamp

The date when the record was last updated.

LastUpdateLogin

string

The login of the user who last updated the record.

LastUpdateSourceSystem

string

The source application that last updated the record.

LastUpdatedBy

string

The user who last updated the record.

MaritalStatus

string

The marital status of the person.

MaritalStatusEffectiveDate

{http://xmlns.oracle.com/adf/svc/types/}date-Date

The date when the marital status of the person changed.

OrigSystem

string

The source system name.

OrigSystemReference

string

The identifier for the record from the original system.

PartyId

long

The unique identifier of the contact party.

PartyNumber

string

The unique identification number for the party.

PartyUniqueName

string

This is a derived column. For Organization, it is concatenation of unique_name_alias and suffix. For Person, it is concatenation of person_name and suffix.

PersonAcademicTitle

string

The academic title that is part of the name of a person such as Dr. Jane Smith.

PersonFirstName

string

The first name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Given Name in HL7.

PersonInformation

Trading Community Person Profile Additional Information

The information of the person.

PersonInitials

string

The Initials of the name.

PersonLastName

string

The last name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Family Name in HL7.

PersonLastNamePrefix

string

Used to identify the Last name prefix such as fon, van and so on for a person. It is used in the same way the new field PERSON_LAST_NAME_PREFIX in HZ_PERSON_PROFILES is used. Corresponds to the field, Last Name Prefix in HL7.

PersonMiddleName

string

The middle name of a person. It is used in the same way the homonymous field in HZ_PERSON_PROFILES is used. It corresponds to the field Middle Initial or Name in HL7.

PersonName

string

The combination of title, first, middle, last, and suffix names.

PersonNameSuffix

string

Indicates the place in a family structure. For example, III in Tom Jones III.

PersonPreNameAdjunct

string

Salutary introduction such as Mr., Herr, and so on.

PersonPreviousLastName

string

The previous last or surname of the person.

PersonProfileId

long
The unique identifier of the person profile.

  • Primary Key

PersonSecondLastName

string

The second last name for a person. In some cultures it is not uncommon to have double last names. It is used in the same way the field PERSON_SECOND_LAST_NAME in HZ_PERSON_PROFILES is used.

PersonTitle

string

The professional or family title. For example, Don or The Right Honorable.

PersonalIncomeAmount

{http://xmlns.oracle.com/adf/svc/types/}AmountType

The estimated gross annual income of the person.

PlaceOfBirth

string

The place where the person was born, including city and country.

PreferredContactEmail

string

The preferred contact e-mail of the person.

PreferredContactMethod

string

The preferred contact method for a person or organization. It is validated against lookup HZ_PREFERRED_CONTACT_METHOD.

PreferredContactName

string

The preferred contact name of the person.

PreferredContactPersonId

long

The PARTY_ID of a preferred contact for a given party. There should be a valid relationship.

PreferredContactPhone

string

The preferred contact phone of the person.

PreferredContactURL

string

The preferred contact uniform resource locator of the person.

PreferredFunctionalCurrency

string

The preferred functional currency for the person or organization. The denormalized value of the PREF_FUNCTIONAL_CURRENCY in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.

PreferredName

string

The denormalized value of the PARTY_NAME field in HZ_ADDTNL_PARTY_NAMES identified by PREFERRED_NAME_ID.

PreferredNameId

long

The foreign key to PARTY_NAME_ID in HZ_ADDTNL_PARTY_NAMES. It contains the ID of the referred name for the party. If it is NULL the Profile Name will be used as preferred name. By default the value is NULL.

PrimaryAddressCity

string

The city of the identifying address.

PrimaryAddressCountry

string

The country listed in the TERRITORY_CODE column of the FND_TERRITORY table for the identifying address.

PrimaryAddressCounty

string

The county of the identifying address.

PrimaryAddressLatitude

decimal

The primary address latitude information for the location for spatial proximity and containment purposes.

PrimaryAddressLine1

string

The first line of the identifying address.

PrimaryAddressLine2

string

The second line of the identifying address.

PrimaryAddressLine3

string

The third line of the identifying address.

PrimaryAddressLine4

string

The fourth line of the identifying address.

PrimaryAddressLocationId

long

The primary address location ID.

PrimaryAddressLongitude

decimal

The primary address longitude information for the location for spatial proximity and containment purposes.

PrimaryAddressPostalCode

string

The postal code of the identifying address.

PrimaryAddressProvince

string

The province of the identifying address.

PrimaryAddressState

string

The state of the identifying address.

PrimaryCustomerId

long

The customer party identifier of a primary customer for a given person. There should be a valid relationship between the person and the customer.

PrimaryCustomerName

string

The customer party name of a primary customer for a given person. There should be a valid relationship between the person and the customer.

PrimaryCustomerRelationshipId

long

The unique identifier of the primary customer relationship.

PrimaryEmailAddress

string

The e-mail address of the person.

PrimaryEmailId

long

The primary contact point e-mail ID of the person.

PrimaryFormattedAddress

string

The primary formatted address of the person.

PrimaryFormattedPhoneNumber

string

The primary telephone number formatted in the local format of the person.

PrimaryLanguage

string

The standard name for a language.

PrimaryPhoneAreaCode

string

The area code within a country code.

PrimaryPhoneCountryCode

string

The international country code for a telephone number. For example, it is 33 for France.

PrimaryPhoneExtension

string

The additional number required after initial connection to an internal telephone system.

PrimaryPhoneId

long

The primary contact point phone ID of the person.

PrimaryPhoneLineType

string

The lookup code for the type of phone line. For example, general, fax, inbound or outbound, and so on.

PrimaryPhoneNumber

string

The telephone number in local format. The number should not include country code, area code, or extension.

PrimaryPhonePurpose

string

The contact point type, such as business or personal.

PrimaryURL

string

The uniform resource locator.

PrimaryWebId

long

The unique identifier of the primary uniform resource locator.

Pronunciation

string

The person pronunciation.

RentOwnInd

string

Indicates if the person rents or owns his or her residence. Lookup values include rent, own, lease, and so on.

RequestId

long

A system-generated read-only attribute used by the application framework.

SalesAffinityCode

string

The affinity of a person towards the deploying organization.

SalesBuyingRoleCode

string

The role of a person in the buying process.

Salutation

string

The phrase used to address a party in any correspondence.

Status

string

The status of the record.

SuffixOverriddenFlag

boolean

This attribute has Y if the suffix is overridden by user and N if not. Default value is N.

UniqueNameSuffix

string

Identifies system generated or manually overridden suffix.

ValidatedFlag

boolean

Indicates whether the entity was validated. If the value is Y then the entity was validated.