Search Results iby_paymentcard

Overview

FND_TERRITORIES is a reference (lookup) table owned by the APPLSYS schema and delivered as part of the FND – Application Object Library product in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the master list of territories, which in EBS terminology correspond to countries and nationally recognized geographic/political entities. Nearly every EBS module that records an address, a bank, a tax registration, a multicurrency transaction, or a party record ultimately resolves a country reference against this table. Because it holds the authoritative single-row-per-territory definition, it is a foundational master data object rather than a transactional one.

From a modeling perspective, the mined relationship structure classifies FND_TERRITORIES as a hub-leaning object — a centrally referenced dimension whose primary key is consumed by many downstream fact and detail tables. In Data Vault terms it behaves like a hub (business key = territory) with descriptive satellite attributes carried in the same table and in its translated counterpart.

Key Information Stored

The documented physical schema contains 17 columns. The most consequential are:

• TERRITORY_CODE — the primary key (FND_TERRITORIES_PK) and the business identifier propagated to all referencing tables. It uses the ISO two-character country code convention for standard entries but also holds EBS-specific and historical codes.
• ISO_TERRITORY_CODE and ISO_NUMERIC_CODE — the ISO 3166 alpha and numeric equivalents, used for interfaces and external data exchange.
• ALTERNATE_TERRITORY_CODE — a secondary code used for legacy or third-party compatibility mappings.
• ADDRESS_STYLE and ADDRESS_VALIDATION — control how address entry and validation behave for the territory, driving the EBS address formatting engine.
• BANK_INFO_STYLE and BANK_INFO_VALIDATION — govern the bank account entry format and validation rules applied by Oracle Payments and Cash Management for that country.
• NLS_TERRITORY — links the territory to NLS (National Language Support) territory settings.
• EU_CODE — indicates EU membership, used in VAT/tax determination logic.
• OBSOLETE_FLAG — flags territories no longer selectable for new transactions while retaining historical references.
• ZD_EDITION_NAME — part of the unique key FND_TERRITORIES_U1 (TERRITORY_CODE, ZD_EDITION_NAME), together with the standard audit columns LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, and LAST_UPDATE_LOGIN.

Common Use Cases and Queries

Typical usage includes populating country LOVs, resolving codes to names (via FND_TERRITORIES_TL), and validating address and bank reference data. A frequent reporting pattern joins the translated view:

• SELECT t.territory_code, t.iso_territory_code, t.obsolete_flag FROM fnd_territories t WHERE t.obsolete_flag = 'N';
• SELECT t.territory_code, tl.territory_short_name FROM fnd_territories_tl tl WHERE tl.language = USERENV('LANG');
• Joining to party/location data: SELECT l.location_id, t.territory_code FROM hz_locations l, fnd_territories t WHERE l.country = t.territory_code;

Queries also support tax regime lookups (ZX_REGIMES_B.COUNTRY_CODE), bank instruction country resolution (IBY_*), and inventory country assignments (MTL_COUNTRY_ASSIGNMENTS).

Related Objects

FND_TERRITORIES is referenced by an extensive set of downstream tables. The most significant relationships include:

• FND_TERRITORIES_TL — the translation table keyed on TERRITORY_CODE, holding language-specific names.
• HZ_LOCATIONS — join on COUNTRY = TERRITORY_CODE for address geography.
• HZ_PARTIES and HZ_ORGANIZATION_PROFILES — join on HOME_COUNTRY for party/organization domicile.
• HZ_GEOGRAPHIES — join on GEOGRAPHY_CODE, bridging country to geography hierarchy.
• IBY_PAYMENTS_H and IBY_BANK_INSTRUCTIONS_B — join on COUNTRY / TERRITORY_CODE for payment and bank routing.
• ZX_REGIMES_B and ZX_PARTY_TAX_PROFILE — join on COUNTRY_CODE for tax regime and tax profile determination.
• FND_CURRENCIES — join on ISSUING_TERRITORY_CODE to associate currencies with issuing territories.
• MTL_COUNTRY_ASSIGNMENTS — joins inventory organizations to countries.

These dependencies confirm FND_TERRITORIES as a shared hub whose integrity directly affects address, tax, payment, and party processing across the EBS data model.