Location Profile

The profile information of a location.

QName: {http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/}LocationProfile

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

Contained by

Location Details

Handled by

Trading Community Location

Handled by

Company and User Registration

Handled by

Partner Service

Attributes

The following table describes attributes in the service data object.

Name Type Description

AddrElementAttribute1

string

The additional address element to support flexible address format.

AddrElementAttribute2

string

The additional address element to support flexible address format.

AddrElementAttribute3

string

The additional address element to support flexible address format.

AddrElementAttribute4

string

The additional address element to support flexible address format.

AddrElementAttribute5

string

The additional address element to support flexible address format.

Address1

string

The first line of the address.

Address2

string

The second line of the address.

Address3

string

The third line of the address.

Address4

string

The fourth line of the address.

Building

string

The specific building name or number at a given address.

City

string

The name of the city.

Country

string

The name of the country.

County

string

The name of the county.

CreatedBy

string

The user who created the record.

CreationDate

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

The date when the record was created.

DateValidated

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

The date when the address was last validated.

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 whether the row has the latest change in the day. If the value is True, then this row has the latest change in the day.

EffectiveSequence

int

The order of the different changes made during the 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.

FloorNumber

string

The floor number of the address.

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.

LastUpdatedBy

string

The user who last updated the record.

LocationId

long

The identifier of the location. It is the foreign key to the HZ_LOCATIONS table.

LocationProfileId

long

The unique Identifier for a location profile.
  • Primary Key

ObjectVersionNumber

int

The number used to implement locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to determine whether another session has updated the row.

PostalCode

string

The postal code element of the address.

Province

string

The name of the province.

RequestId

long

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

State

string

The name of the state.

ValidationSstFlag

boolean

Indicates if the location information has been validated. If the value is Y, then the location has been validated.

ValidationStatusCode

string

A standardized status code describing the results of the validation. The value is internally set by system during address cleansing.