Search Results hr.per_addresses
The HR.PER_ADDRESSES
table is a critical component within Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2, specifically designed to store address-related information for persons (employees, contingent workers, applicants, etc.) registered in the Human Resources (HR) module. This table is part of the Oracle HRMS (Human Resource Management System) data model and plays a fundamental role in maintaining accurate and structured address data, which is leveraged across multiple EBS modules, including Payroll, Benefits, and Self-Service HR (SSHR).
### **Table Structure and Key Columns**
The HR.PER_ADDRESSES
table contains columns that capture comprehensive address details, including geographic, postal, and contact information. Below are some of the key columns:
- **PERSON_ID**: A foreign key referencing HR.PER_ALL_PEOPLE_F
, linking the address to a specific person.
- **ADDRESS_ID**: The primary key, uniquely identifying each address record.
- **DATE_FROM** and **DATE_TO**: Define the validity period of the address (effective dating).
- **ADDRESS_TYPE**: Classifies the address (e.g., Home, Work, Mailing, Permanent).
- **ADDRESS_LINE1**, **ADDRESS_LINE2**, **ADDRESS_LINE3**: Store street-level address components.
- **TOWN_OR_CITY**: The city or town name.
- **REGION_1**, **REGION_2**, **REGION_3**: Used for state/province or additional regional subdivisions.
- **POSTAL_CODE**: The postal or ZIP code.
- **COUNTRY**: The country code (references FND_TERRITORIES
).
- **TELEPHONE_NUMBER**, **FAX_NUMBER**: Contact details associated with the address.
- **PRIMARY_FLAG**: Indicates whether the address is the primary address for the person.
### **Functional Usage in Oracle EBS**
1. **Employee Data Management**:
The table stores multiple addresses per person, allowing organizations to track home, work, and mailing addresses. This is essential for payroll processing, tax reporting, and benefits administration.
2. **Global Compliance & Localization**:
The structure supports international address formats, accommodating varying regional requirements (e.g., different postal systems, mandatory fields per country).
3. **Integration with Other Modules**:
- **Payroll**: Address data is used for tax jurisdiction determination and statutory reporting.
- **Benefits**: Eligibility for location-based benefits (e.g., transportation allowances) is derived from this table.
- **Self-Service HR (SSHR)**: Employees can update their addresses via self-service portals, with changes written to PER_ADDRESSES
.
4. **Effective Dating**:
The DATE_FROM
and DATE_TO
columns enable historical tracking of address changes, critical for audits and compliance.
### **Technical Considerations**
- **Indexing**: The table is indexed on PERSON_ID
, ADDRESS_ID
, and PRIMARY_FLAG
for performance optimization.
- **APIs**: Oracle provides PL/SQL APIs (e.g., HR_ADDRESS_API
) to create, update, or delete addresses programmatically while maintaining data integrity.
- **Validation**: Country-specific validations (e.g., postal code formats) are enforced via Oracle’s Territory definitions (FND_TERRITORIES
).
### **Common Customizations & Extensions**
- **Additional Attributes**: Organizations may extend the table to include custom address fields (e.g., Geo-coordinates) via Descriptive Flexfields (DFFs).
- **Data Migration**: During EBS implementations, legacy address data is mapped and loaded into PER_ADDRESSES
using interfaces like HR_LOAD
or Data Conversion scripts.
### **Conclusion**
The HR.PER_ADDRESSES
table is a foundational element in Oracle EBS HRMS, ensuring accurate and flexible address management. Its integration with core HR processes, support for global address formats, and compliance with effective dating make it indispensable for organizations running Oracle EBS 12.1.1 or 12.2.2. Proper utilization of this table enhances data consistency, reporting accuracy, and operational efficiency across the enterprise.
-
VIEW: HR.PER_ADDRESSES#
12.2.2
-
TABLE: HR.PER_ADDRESSES
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_ADDRESSES, object_name:PER_ADDRESSES, status:VALID,
-
VIEW: HR.PER_ADDRESSES#
12.2.2
owner:HR, object_type:VIEW, object_name:PER_ADDRESSES#, status:VALID,
-
TABLE: HR.PER_ADDRESSES
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_ADDRESSES, object_name:PER_ADDRESSES, status:VALID,
-
HR.PER_ADDRESSES dependencies on STANDARD
12.1.1
-
HR.PER_ADDRESSES# dependencies on STANDARD
12.2.2
-
HR.PER_ADDRESSES dependencies on STANDARD
12.2.2
-
INDEX: HR.PER_ADDRESSES_N3
12.1.1
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_N3, status:VALID,
-
INDEX: HR.PER_ADDRESSES_N2
12.1.1
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_N2, status:VALID,
-
INDEX: HR.SYS_IL0000043714C00069$$
12.1.1
owner:HR, object_type:INDEX, object_name:SYS_IL0000043714C00069$$, status:VALID,
-
INDEX: HR.PER_ADDRESSES_FK1
12.2.2
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_FK1, status:VALID,
-
INDEX: HR.SYS_IL0000043714C00068$$
12.2.2
owner:HR, object_type:INDEX, object_name:SYS_IL0000043714C00068$$, status:VALID,
-
INDEX: HR.SYS_IL0000043714C00069$$
12.2.2
owner:HR, object_type:INDEX, object_name:SYS_IL0000043714C00069$$, status:VALID,
-
Table: PER_ADDRESSES
12.1.1
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_ADDRESSES, object_name:PER_ADDRESSES, status:VALID, product: PER - Human Resources , description: Address information for people. , implementation_dba_data: HR.PER_ADDRESSES ,
-
INDEX: HR.PER_ADDRESSES_SPT
12.1.1
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_SPT, status:VALID,
-
INDEX: HR.PER_ADDRESSES_N4
12.1.1
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_N4, status:VALID,
-
INDEX: HR.PER_ADDRESSES_PK
12.1.1
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_PK, status:VALID,
-
INDEX: HR.PER_ADDRESSES_SPT
12.2.2
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_SPT, status:VALID,
-
TRIGGER: HR.DR$PER_ADDRESSES_N4TC
12.1.1
owner:HR, object_type:TRIGGER, object_name:DR$PER_ADDRESSES_N4TC, status:VALID,
-
Table: PER_ADDRESSES
12.2.2
owner:HR, object_type:TABLE, fnd_design_data:PER.PER_ADDRESSES, object_name:PER_ADDRESSES, status:VALID, product: PER - Human Resources , description: Address information for people. , implementation_dba_data: HR.PER_ADDRESSES ,
-
INDEX: HR.PER_ADDRESSES_FK1
12.1.1
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_FK1, status:VALID,
-
INDEX: HR.SYS_IL0000043714C00068$$
12.1.1
owner:HR, object_type:INDEX, object_name:SYS_IL0000043714C00068$$, status:VALID,
-
INDEX: HR.PER_ADDRESSES_N2
12.2.2
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_N2, status:VALID,
-
INDEX: HR.PER_ADDRESSES_N3
12.2.2
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_N3, status:VALID,
-
TRIGGER: APPS.GHR_PER_ADDRESSES_AFIUD
12.2.2
owner:APPS, object_type:TRIGGER, object_name:GHR_PER_ADDRESSES_AFIUD, status:VALID,
-
TRIGGER: HR.DR$PER_ADDRESSES_N4TC
12.2.2
owner:HR, object_type:TRIGGER, object_name:DR$PER_ADDRESSES_N4TC, status:VALID,
-
TRIGGER: APPS.PER_ADDRESSES_WHO
12.2.2
owner:APPS, object_type:TRIGGER, object_name:PER_ADDRESSES_WHO, status:VALID,
-
TRIGGER: APPS.BEN_EXT_ADD_EVT
12.2.2
owner:APPS, object_type:TRIGGER, object_name:BEN_EXT_ADD_EVT, status:VALID,
-
TRIGGER: APPS.PER_ADDRESSES_OVN
12.2.2
owner:APPS, object_type:TRIGGER, object_name:PER_ADDRESSES_OVN, status:VALID,
-
SYNONYM: PUBLIC.PER_ADDRESSES
12.1.1
owner:PUBLIC, object_type:SYNONYM, object_name:PER_ADDRESSES, status:VALID,
-
INDEX: HR.PER_ADDRESSES_N4
12.2.2
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_N4, status:VALID,
-
INDEX: HR.SYS_IL0000043714C00070$$
12.2.2
owner:HR, object_type:INDEX, object_name:SYS_IL0000043714C00070$$, status:VALID,
-
INDEX: HR.PER_ADDRESSES_PK
12.2.2
owner:HR, object_type:INDEX, object_name:PER_ADDRESSES_PK, status:VALID,
-
TRIGGER: APPS.PERADDRESSES_56U_DYT
12.1.1
owner:APPS, object_type:TRIGGER, object_name:PERADDRESSES_56U_DYT, status:VALID,
-
TRIGGER: APPS.GHR_PER_ADDRESSES_AFIUD
12.1.1
owner:APPS, object_type:TRIGGER, object_name:GHR_PER_ADDRESSES_AFIUD, status:VALID,
-
TRIGGER: APPS.PERADDRESSES_1136I_DYT
12.2.2
owner:APPS, object_type:TRIGGER, object_name:PERADDRESSES_1136I_DYT, status:VALID,
-
TRIGGER: APPS.HR_PA_MAINTN_ADDR_HIST_BRI
12.1.1
owner:APPS, object_type:TRIGGER, object_name:HR_PA_MAINTN_ADDR_HIST_BRI, status:VALID,
-
TRIGGER: APPS.HR_PA_MAINTN_ADDR_HIST_BRU
12.1.1
owner:APPS, object_type:TRIGGER, object_name:HR_PA_MAINTN_ADDR_HIST_BRU, status:VALID,
-
TRIGGER: APPS.HR_PA_MAINTN_ADDR_HIST_BRI
12.2.2
owner:APPS, object_type:TRIGGER, object_name:HR_PA_MAINTN_ADDR_HIST_BRI, status:VALID,
-
TRIGGER: APPS.HR_PA_MAINTN_ADDR_HIST_BRU
12.2.2
owner:APPS, object_type:TRIGGER, object_name:HR_PA_MAINTN_ADDR_HIST_BRU, status:VALID,
-
TRIGGER: APPS.BEN_EXT_ADD_EVT
12.1.1
owner:APPS, object_type:TRIGGER, object_name:BEN_EXT_ADD_EVT, status:VALID,
-
TRIGGER: APPS.PER_ADDRESSES_WHO
12.1.1
owner:APPS, object_type:TRIGGER, object_name:PER_ADDRESSES_WHO, status:VALID,
-
TRIGGER: APPS.PER_ADDRESSES_OVN
12.1.1
owner:APPS, object_type:TRIGGER, object_name:PER_ADDRESSES_OVN, status:VALID,
-
TRIGGER: APPS.PERADDRESSES_56U_DYT
12.2.2
owner:APPS, object_type:TRIGGER, object_name:PERADDRESSES_56U_DYT, status:VALID,
-
TRIGGER: APPS.PERADDRESSES_1136I_DYT
12.1.1
owner:APPS, object_type:TRIGGER, object_name:PERADDRESSES_1136I_DYT, status:VALID,
-
SYNONYM: APPS.PER_ADDRESSES
12.1.1
owner:APPS, object_type:SYNONYM, object_name:PER_ADDRESSES, status:VALID,
-
SYNONYM: APPS.PER_ADDRESSES
12.2.2
owner:APPS, object_type:SYNONYM, object_name:PER_ADDRESSES, status:VALID,
-
eTRM - PER Tables and Views
12.2.2
description: Table to store NQF Training info for a person ,
-
eTRM - PER Tables and Views
12.1.1
description: Table to store NQF Training info for a person ,
-
eTRM - PER Tables and Views
12.2.2
description: Table to store NQF Training info for a person ,