Location Details

The details about a geographical or physical location. For example, 500 Oracle Parkway, Redwood Shores, CA 94065.

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

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	Location Locale
Contains	Location Profile
Contains	Source System Reference
Contains	Trading Community Location Profile Additional Information
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.
AddressEffectiveDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date when the address becomes effective.
AddressExpirationDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date when the address is no longer active.
AddressLinesPhonetic	string	The phonetic or kana representation of the Kanji address lines (used in Japan).
AddressStyle	string	The context value for Flexible Address Format descriptive flex field. Do not use this column, join to the FND_TERRITORIES table via COUNTRY = TERRITORY_CODE to retrieve the address style for the country.
Building	string	The specific building name or number at a given address.
City	string	The name of the city.
ClliCode	string	Common Language Location Identifier (CLLI) code.
Comments	string	The comments for the record.
Country	string	The name of the country.
County	string	The name of the county.
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.
DateValidated	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date when the address was last validated.
Description	string	The free text description of the record.
Distance	decimal	The distance from the input location.
DoNotValidateFlag	boolean	Indicates that a particular location should not validated, regardless of the current validation status code. If the value is Yes, then the location is not validated. The default is No.
EffectiveDate	{http://xmlns.oracle.com/adf/svc/types/}date-Date	The date when the location becomes valid.
FaLocationId	long	Foreign key to the FA_LOCATIONS table.
FloorNumber	string	The floor number of the address.
GeometryStatusCode	string	The spatial data integration status for given location.
HouseType	string	Indicates the building type for the building in the address. A list of valid values are defined in the lookup HZ_HOUSE_TYPE.
InternalFlag	boolean	The denormalized value of the INTERNAL_FLAG in HZ_PERSON_PROFILES/HZ_ORGANIZATION_PROFILES.
Language	string	The language used in the location.
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.
Latitude	decimal	The latitude information for the address. The latitude information for the location is used for spatial proximity and containment purposes.
LocationDirections	string	The directions to the address location.
LocationId	long	The identifier of the location. It is the foreign key to the HZ_LOCATIONS table. Primary Key
LocationInformation	Trading Community Location Profile Additional Information	The detailed information about the location.
LocationLocale	Location Locale	The location or address information in the local language.
LocationProfile	Location Profile	The profile information of the location.
Longitude	decimal	The longitude information for the address. The longitude information for the location is used for spatial proximity and containment purposes.
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.
OrigSystem	string	The source system name.
OrigSystemReference	string	The identifier for the record from the original system.
OriginalSystemReference	Source System Reference	The identifier for the record from the original system.
Position	string	The primary direction such as North or East that is used to access the location.
PostalCode	string	The postal code element of the address.
PostalPlus4Code	string	The four-digit extension to the United States Postal ZIP code for the address.
Province	string	The name of the province.
RequestId	long	A system-generated read-only attribute used by the application framework.
SalesTaxGeocode	string	The US Sales Tax Jurisdiction code. This provides a Jurisdiction Code (also called as Geocode) defined by either Vertex or Taxware. This value is passed as a ship-to location jurisdiction code to the tax partner API.
SalesTaxInsideCityLimits	string	Indicates if the location is inside the boundary of a city. Used to calculate state and local taxes in the United States. If the value is 1, then the location is within city limits.
ShortDescription	string	The short description of the location.
State	string	The name of the state.
StatusFlag	boolean	The record status flag used to soft delete the record. The accepted values are: 'A' (active), 'I' (inactive), 'D' (logically deleted), and 'M' (merged). The default is 'A'.
TimezoneCode	string	The code of the time zone for the location.
ValidatedFlag	boolean	Indicates whether the entity was validated. If the value is Y then the entity was validated.
ValidationStatusCode	string	A standardized status code describing the results of the validation. The value is internally set by system during address cleansing.