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

Contact

The trading community person's profile information. For example this person is a married woman whose previous last name was Smith.

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

Loyalty Member

Contained by

Sales Account

Handled by

Loyalty Member Service

Handled by

Company and User Registration

Handled by

Sales Account Service

Handled by

Sales Party

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

The alias name of the person.

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

Specifies the enrichment status of the person.

DateOfBirth

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

The date the person was born.

DateOfDeath

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

The date when the person died.

DeceasedFlag

boolean

Indicates whether the person is deceased or not. If the value is True, then the person is deceased.

DeclaredEthnicity

string

The declared ethnicity of the person.

Department

string

The free form text used to name the department.

DepartmentCode

string

The list of possible values for department codes.

Distance

decimal

The distance from the input location.

DoNotCallFlag

boolean

Flag to indicate if the user can send e-mail to the person or not. If the value is True, then e-mail cannot be sent to the person.

DoNotContactFlag

boolean

Flag to indicate if the user can contact(phone/email/mail/) the person or not. If the value is True, then the person cannot be contacted.

DoNotEmailFlag

boolean

Flag to indicate if the user can email the person or not. If the value is True, then the user cannot e-mail the person.

DoNotMailFlag

boolean

Flag to indicate 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

Indicates that this row represents the latest change in the day.

EffectiveSequence

int

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

Flag to indicate if the person is a key contact. If the value is True, then the person is a key contact.

Gender

string

The gender (male, female, unknown) of the person.

HeadOfHouseholdFlag

boolean

Not Used.

HouseholdIncomeAmount

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

Not Used.

HouseholdSize

decimal

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 job title.

JobTitleCode

string

The code given to the job title.

LastContactDate

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

The date on which the contact was last contacted.

LastEnrichmentDate

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

Specifies date this person was last enriched in DaaS.

LastKnownGPS

string

The geophysical location (GPS point) that was last reported for the person.

LastSourceUpdateDate

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

The date on which the record was last updated by the source system.

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 system that last updated this 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 person's marital status 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 person's name 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

Information about the person.

PersonInitials

string

The name initials of the person.

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 capture the last name prefix (e.g. 'fon', 'van', etc.) for a person. 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, in "Tom Jones III", the "III".

PersonPreNameAdjunct

string

The salutary introduction such as Mr., Herr, etc.

PersonPreviousLastName

string

The previous last name or surname of the person.

PersonProfileId

long
The unique identifier for 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. Typically, the city and the 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 customers party identifier of a primary customer for a given person. There should be a valid relationship between the person and a customer.

PrimaryCustomerName

string

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

PrimaryCustomerRelationshipId

long

The identifier of the primary customer relationship.

PrimaryEmailAddress

string

The e-mail address of the person.

PrimaryEmailId

long

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

PrimaryFormattedAddress

string

The primary formatted address of the person.

PrimaryFormattedPhoneNumber

string

The primary telephone number formatted in the local format.

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 pronunciation of the person.

RentOwnInd

string

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

RequestId

long

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

SalesAffinityCode

string

The person's affinity towards the deploying organization.

SalesBuyingRoleCode

string

The person's role in the buying process.

Salutation

string

Phrase used to address a party in any correspondence.

Status

string

The status of the record.

SuffixOverriddenFlag

boolean

Indicates if the suffix is overridden by the user. If the value is True, then the suffix is overridden. The default value is False.

UniqueNameSuffix

string

Captures system-generated or manually overridden suffix.

ValidatedFlag

boolean

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