Search Results fnd_territories




The FND_TERRITORIES table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a fundamental repository for storing country and territory information, serving as a critical reference for global compliance, localization, and reporting. This table is part of the Oracle Application Object Library (FND) and is extensively used across modules to ensure accurate geographical data alignment with legal, financial, and operational requirements. Below is a detailed analysis of its structure, purpose, and integration within Oracle EBS.

Purpose and Importance

The FND_TERRITORIES table maintains standardized ISO country codes, names, and associated attributes required for multinational operations. It supports localization features such as tax calculations, legal entity setups, and address validations. Compliance with international standards (e.g., ISO 3166) ensures consistency in cross-border transactions, regulatory reporting, and system integrations.

Key Columns and Descriptions

  • TERRITORY_CODE: Primary key storing the ISO 2-character country code (e.g., 'US' for United States).
  • TERRITORY_SHORT_NAME: Abbreviated country name (e.g., 'U.S.A.').
  • TERRITORY_NAME: Full country name (e.g., 'United States of America').
  • ISO_NUMERIC_CODE: ISO 3-digit numeric code (e.g., '840' for the U.S.).
  • ISO_ALPHA_3_CODE: ISO 3-character alphabetic code (e.g., 'USA').
  • START_DATE_ACTIVE and END_DATE_ACTIVE: Define the validity period for the territory record.
  • ADDRESS_STYLE: Dictates formatting rules for postal addresses.
  • TELEPHONE_NUMBERING_STYLE: Specifies phone number formatting conventions.
  • VAT_REQUIRED_FLAG: Indicates if Value-Added Tax (VAT) applies.

Integration with Oracle EBS Modules

  1. Financials (GL, AP, AR): Validates country-specific tax rules, currency defaults, and invoice addressing.
  2. Human Resources (HRMS): Ensures compliance with labor laws and payroll regulations based on employee location.
  3. Supply Chain (OM, INV): Facilitates shipping and customs documentation by referencing territory codes.
  4. Multi-Org Access Control (MOAC): Aligns operating units with legal jurisdictions.

Technical Considerations

  • Indexes: Optimized for queries on TERRITORY_CODE and ISO_NUMERIC_CODE.
  • APIs: Accessed via FND_TERRITORY_PUB for programmatic updates or validations.
  • Seed Data: Pre-populated by Oracle; custom entries require careful validation to avoid conflicts.

Example Use Case

When configuring a new legal entity in Belgium, the system references FND_TERRITORIES to enforce Belgian VAT rules (VAT_REQUIRED_FLAG='Y'), format addresses (ADDRESS_STYLE='BE'), and validate ISO codes (TERRITORY_CODE='BE', ISO_ALPHA_3_CODE='BEL').

Best Practices

  • Audit the table periodically for obsolete or missing territories.
  • Leverage Oracle's patch utilities for updates to avoid manual errors.
  • Use descriptive flexfields (DFFs) for custom attributes without modifying core columns.
In summary, FND_TERRITORIES is a cornerstone table in Oracle EBS, ensuring global operational consistency and compliance. Its structured design and integration capabilities make it indispensable for multinational deployments.