Search Results hz_locations




Here's a comprehensive description of the HZ_LOCATIONS table in Oracle E-Business Suite (EBS):

Table Name: HZ_LOCATIONS
Module: Oracle Fusion Customer Master (HZ)

Purpose:
The HZ_LOCATIONS table stores physical location information used across Oracle E-Business Suite applications, including customer and supplier addresses, shipping and billing locations, etc.

Key Columns:
1. LOCATION_ID (Primary Key)
- Unique identifier for each location
- Automatically generated sequence number
- Used to link locations to other entities

2. LOCATION_TYPE_CODE
- Defines the type of location (e.g., SHIPPING, BILLING, REMIT)
- Helps categorize different address purposes

3. ADDRESS1, ADDRESS2, ADDRESS3
- Street address fields
- Store physical address details

4. CITY
- City name for the location

5. STATE
- State or province name

6. POSTAL_CODE
- Zip or postal code

7. COUNTRY
- Country name or code

8. DESCRIPTION
- Optional descriptive text about the location

9. STATUS
- Active/Inactive status of the location

10. TIMEZONE_CODE
- Timezone information for the location

Common Usage:
- Customer address management
- Supplier location tracking
- Shipping address references
- Billing address storage

Typical Relationships:
- Links to HZ_PARTY_SITES
- Connected with HZ_CUST_ACCOUNTS
- Used in AR and PO modules

Best Practices:
- Maintain clean, standardized location data
- Validate addresses during entry
- Use location IDs for referencing