Search Results service request tasks




The PN_ADDRESSES_ALL table in Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2 is a critical data structure within the Property Manager (PN) module. It stores comprehensive address information for properties, lease agreements, and related entities managed in the system. This table serves as a centralized repository for all address-related data, ensuring consistency and accessibility across various transactional and reporting processes in Oracle EBS.

Table Structure and Key Columns

The PN_ADDRESSES_ALL table contains the following key columns:
  • ADDRESS_ID: Primary key identifier for each address record.
  • ADDRESS_LINE_1 to ADDRESS_LINE_4: Detailed street address components.
  • CITY, STATE, POSTAL_CODE, PROVINCE, COUNTY: Geographic subdivisions of the address.
  • COUNTRY: ISO country code for international addresses.
  • STATUS: Indicates whether the address is active or inactive.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY: Standard Oracle audit columns.

Functional Integration

The table integrates with multiple Oracle EBS modules:
  • Property Manager (PN): Primary module utilizing this table for property and lease address storage.
  • Accounts Payable (AP): Vendor address information may reference PN_ADDRESSES_ALL.
  • Accounts Receivable (AR): Customer billing addresses may link to this table.
  • General Ledger (GL): Legal entity addresses may be stored here.

Technical Considerations

Key technical aspects of the table include:
  • Multi-Org Architecture: The "_ALL" suffix indicates the table contains data for all operating units.
  • Indexing Strategy: Typically indexed on ADDRESS_ID, COUNTRY, and POSTAL_CODE for performance.
  • Validation Rules: Enforces address format standards through validation triggers.
  • Storage Parameters: In 12.2.2, may utilize Oracle's Advanced Compression for space efficiency.

Data Relationships

The table maintains foreign key relationships with:
  • PN_PROPERTIES_ALL: Property location addresses
  • PN_LEASES_ALL: Lessor/Lessee addresses
  • PN_LOCATIONS_ALL: Physical location details

Customization Considerations

When extending the table:
  • Additional columns should follow Oracle's extension standards
  • Custom validation logic must maintain data integrity
  • Extensions should be registered in Oracle Application Developer

Upgrade Implications

Between 12.1.1 and 12.2.2:
  • Table structure remains largely consistent
  • New validation rules may be introduced in 12.2.2
  • Performance optimizations in later version

Best Practices

Recommended approaches for working with this table:
  • Use Oracle's address validation APIs rather than direct SQL
  • Maintain address standardization across all modules
  • Regularly purge obsolete addresses to maintain performance
The PN_ADDRESSES_ALL table represents a fundamental component of Oracle EBS's address management infrastructure, particularly within the Property Manager module. Its design reflects Oracle's comprehensive approach to global address handling, with flexibility to accommodate diverse international address formats while maintaining strict data integrity through relational constraints and validation logic.