Search Results xle_etb_profiles_u1

Overview

The XLE.XLE_ETB_PROFILES table is a core E-Business Tax (ETRM) object that stores the general information identifying a Party (HZ_PARTIES) with the classification of Establishment. In the Oracle E-Business Suite 12.1.1 and 12.2.2 architectures, this table supports the legal establishment registry used by tax determination, party tax profiles, and legal entity configuration. Each row associates an establishment with a party, a legal entity, and a geography, and carries effective dating plus a developer flexfield for extensibility.

From a Data Vault modeling perspective, the metadata's heuristic classification is standalone. XLE_ETB_PROFILES functions effectively as a hub-like key registry for establishments, since the unique index XLE_ETB_PROFILES_U1 on ESTABLISHMENT_ID provides the single natural business key per row. It also behaves as a lightweight satellite through its effective-dated attributes (EFFECTIVE_FROM, EFFECTIVE_TO, MAIN_ESTABLISHMENT_FLAG) and audit columns. This classification is a modeling suggestion and should not be interpreted as a physical Data Vault implementation within EBS.

Key Information Stored

The table's columns (61 documented in ETRM 12.2.2) fall into identification, geographic, temporal, and descriptive groups. The most significant columns are:

• ESTABLISHMENT_ID (NUMBER 15) — surrogate primary key and the sole column in the unique index XLE_ETB_PROFILES_U1; the business-key candidate for the establishment.
• PARTY_ID (NUMBER 15) — foreign reference to HZ_PARTIES identifying the party classified as an establishment; indexed non-uniquely via XLE_ETB_PROFILES_N3.
• LEGAL_ENTITY_ID (NUMBER 15) — foreign reference to FV_LEGAL_ENTITIES; indexed non-uniquely via XLE_ETB_PROFILES_N2.
• GEOGRAPHY_ID (NUMBER 15) — the geography associated with the establishment.
• NAME (VARCHAR2 240) — establishment name; indexed non-uniquely via XLE_ETB_PROFILES_N1.
• MAIN_ESTABLISHMENT_FLAG (VARCHAR2) — indicates whether this record is the primary establishment for its party or legal entity.
• MAIN_EFFECTIVE_FROM / MAIN_EFFECTIVE_TO (DATE) — validity window during which the main-establishment designation applies.
• EFFECTIVE_FROM / EFFECTIVE_TO (DATE) — general effective dating for the establishment record.
• ETB_INFORMATION_CONTEXT and ETB_INFORMATION1..20 (VARCHAR2) — developer flexfield context and segments for customer-defined attributes.
• ACTIVITY_CODE / SUB_ACTIVITY_CODE / TYPE_OF_COMPANY (VARCHAR2) — classification codes describing the establishment's business activity and company type.
• ATTRIBUTE_CATEGORY, ATTRIBUTE1..20, OBJECT_VERSION_NUMBER, and the standard WHO columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) — descriptive flexfield and concurrency/audit infrastructure.

Common Use Cases and Queries

Tax and legal-entity configuration teams use XLE_ETB_PROFILES to resolve the establishment tied to a party, to determine the main establishment for reporting, and to validate that a legal entity's establishments are correctly registered. A typical lookup joins the unique key to related master data:

• Fetch all establishments for a legal entity:
  SELECT establishment_id, name, party_id, main_establishment_flag FROM xle.xle_etb_profiles WHERE legal_entity_id = :p_legal_entity_id AND (effective_to IS NULL OR effective_to >= SYSDATE);
• Resolve an establishment's parent party and geography:
  SELECT e.establishment_id, e.name, p.party_name, e.geography_id FROM xle.xle_etb_profiles e JOIN hz_parties p ON p.party_id = e.party_id WHERE e.establishment_id = :p_establishment_id;
• Identify main establishments whose validity covers a given date:
  SELECT establishment_id, name FROM xle.xle_etb_profiles WHERE main_establishment_flag = 'Y' AND :p_date BETWEEN main_effective_from AND NVL(main_effective_to, :p_date);
• Report on establishment activity classifications using the ETB_INFORMATION flexfield segments, joined to FND lookup contexts defined in ETB_INFORMATION_CONTEXT.

These patterns support downstream tax registration, reporting, and legal-establishment audit queries.

Related Objects

The following objects are the most significant direct relationships, per the documented foreign keys and index metadata:

• PER_ESTABLISHMENTS — referenced by XLE_ETB_PROFILES.ESTABLISHMENT_ID; the HR establishment definition that anchors this profile.
• FV_LEGAL_ENTITIES — referenced by XLE_ETB_PROFILES.LEGAL_ENTITY_ID; the legal entity owning the establishment.
• HZ_PARTIES — the party classification source; joined via PARTY_ID.
• HZ_PARTY_SITES / HZ_LOCATIONS — geography resolution for GEOGRAPHY_ID.
• XLE_ENTITY_PROFILES — legal entity tax profile sibling used in tax determination.
• ZX_REGIMES / ZX_PARTY_TAX_PROFILE — ETRM tax setup objects that consume establishment data.
• XLE_ETB_PROFILES_U1 / _N1 / _N2 / _N3 — the four supporting indexes on APPS_TS_TX_IDX that accelerate the access paths above.