Search Results xle_sob_interface

Overview

XLE_SOB_INTERFACE is a table in the XLE schema, owned by the Legal Entity Configurator (XLE) module of Oracle E-Business Suite. The ETRM metadata explicitly states that this table is no longer used. In Oracle EBS Release 12.1.1 and 12.2.2, XLE provides the framework for defining legal entities, balancing segments, and their association with ledgers (sets of books). This table originally functioned as a staging or interface structure, capturing set-of-books definitions during a transitional data model before the Legal Entity Configurator became the authoritative source. Because Oracle has deprecated the object, it persists in the schema for backward compatibility only, and no active code path in the standard product reads from or writes to it.

From a heuristic Data Vault modeling perspective, XLE_SOB_INTERFACE is classified as a standalone structure. It exhibits only two outbound foreign keys and no documented inbound references, so it does not participate in a hub-and-link pattern. In practice it behaves like a satellite-like staging snapshot rather than a true integration hub. This classification should be treated as a modeling suggestion derived from FK topology, not as a normative Oracle design.

Key Information Stored

The table documents 16 columns. The most significant are:

• SET_OF_BOOKS_ID (surrogate/business key candidate, unique index XLE_SOB_INTERFACE_U1) — the numeric identifier of the ledger.
• SET_OF_BOOKS_NAME (business key candidate, unique index XLE_SOB_INTERFACE_U2) — the ledger name.
• CHART_OF_ACCOUNTS_ID — foreign key to GL_MGT_SEG_UPGRADE_H, tying the row to a chart of accounts definition.
• LEGAL_ENTITY_ID — foreign key to FV_LEGAL_ENTITIES, identifying the owning legal entity.
• BSV_FLEX_VALUE_SET_ID — the balancing segment value flexfield value set.
• OU_ASSOC_FLAG — indicates whether an operating unit is associated.
• ACCOUNTING_ENV_TYPE — the accounting environment classification.
• ASSIGNMENT_TYPE — the nature of the entity-to-ledger assignment.
• MAPPING_STATUS_FLAG — status of the mapping or migration process.
• BALANCING_SEGMENT_COLUMN_NAME — the column name used for the balancing segment.

Standard WHO columns (LAST_UPDATED_BY, CREATION_DATE, LAST_UPDATE_LOGIN, LAST_UPDATE_DATE, CREATED_BY) and OBJECT_VERSION_NUMBER provide audit trail and optimistic locking support.

Common Use Cases and Queries

Because the table is deprecated, the primary use cases are diagnostic and archival. DBAs and technical consultants query it during upgrades or data-migration projects to determine whether historical mappings were captured before the Legal Entity Configurator replaced the older set-of-books model. A typical query validating leftover data is:

SELECT sob.SET_OF_BOOKS_ID, sob.SET_OF_BOOKS_NAME, sob.MAPPING_STATUS_FLAG, le.LEGAL_ENTITY_ID FROM XLE.XLE_SOB_INTERFACE sob, FV.FV_LEGAL_ENTITIES le WHERE sob.LEGAL_ENTITY_ID = le.LEGAL_ENTITY_ID;

Reporting scenarios may join CHART_OF_ACCOUNTS_ID to GL_MGT_SEG_UPGRADE_H to reconcile legacy balancing-segment assignments. Before decommissioning or purging the table, administrators should confirm row counts and verify no custom extensions reference it. No supported concurrent program or public API is documented against this object.

Related Objects

• FV_LEGAL_ENTITIES — referenced via LEGAL_ENTITY_ID; the current authoritative source for legal entities.
• GL_MGT_SEG_UPGRADE_H — referenced via CHART_OF_ACCOUNTS_ID; holds chart-of-accounts upgrade history.
• XLE_SOB_INTERFACE_U1 and XLE_SOB_INTERFACE_U2 — unique indexes on SET_OF_BOOKS_ID and SET_OF_BOOKS_NAME.
• GL_LEDGERS and GL_LEDGER_CONFIGURATIONS — the replacement ledger/configuration model that superseded this interface in Release 12.
• XLE_ENTITY_PROFILES — the primary legal entity profile table used by the current XLE data model.

These relationships confirm the object's historical role and reinforce that migration or debugging work should target the current XLE and GL ledger tables rather than this deprecated interface.