Search Results fv_legal_entities_u3

Overview

FV_LEGAL_ENTITIES is a Federal Financials (FV) module table whose documentation describes it as holding agency information. Within Oracle E-Business Suite 12.1.1 and 12.2.2, the table acts as a registry of the legal entities recognized by the federal accounting configuration, associating each registered legal entity with the set of books and operating organization under which it is recognized. The table is therefore a configuration and reference object: transaction and subledger tables across Payables, Receivables, Cash Management, Payments, Leasing, Tax, Costing, and localized reporting components store a LEGAL_ENTITY_ID that resolves back to this registry.

The ETRM metadata notes that the table was not implemented in the source database from which the documentation was harvested, so column-level definitions are unavailable in that extract; the documented facts are the primary key definitions and the extensive set of foreign-key relationships. Based on the documented FK structure, FV_LEGAL_ENTITIES functions as a standalone entity: it is not modeled as a dependent child of another hub in the dataset, and no link table role is documented for it. The heuristic Data Vault classification of "standalone" suggests modeling the object as a hub, with its unique-key columns serving as business keys and the referencing subledger tables providing candidate link or satellite context.

Key Information Stored

Documented metadata identifies three unique indexes on this table, which together define both the surrogate identity and the business uniqueness rules:

• LEGAL_ENTITY_ID — the declared primary key under FV_LEGAL_ENTITIES_U1. Nearly every referencing foreign key in the system points at this column, making it the primary join path throughout EBS.
• SET_OF_BOOKS_ID and ORGANIZATION_ID — together forming the composite unique index FV_LEGAL_ENTITIES_U2, expressing that a legal entity is defined once per set of books and operating organization combination.
• ORGANIZATION_ID — additionally unique on its own under FV_LEGAL_ENTITIES_U3, indicating a one-to-one association between an operating organization and its legal entity registration.

Because the columns beyond these unique keys are not documented in the ETRM extract, attribute-level detail such as agency names, addresses, tax identifiers, or enablement flags should be verified directly against the 12.1.1 or 12.2.2 instance using the data dictionary rather than assumed from this documentation.

Common Use Cases and Queries

The most frequent patterns involving FV_LEGAL_ENTITIES are identifier resolution and reporting joins. A typical lookup resolves a legal entity identifier to its owning organization and book context:

• Joining AP_INVOICES_ALL, RA_CUSTOMER_TRX_ALL, or IBY_PAYMENTS_ALL to FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID to attribute subledger activity to the correct agency for federal reporting.
• Filtering by SET_OF_BOOKS_ID to constrain transaction extracts to a single accounting book, a common requirement for period-end federal reports.
• Resolving ORGANIZATION_ID through FV_OPERATING_UNITS_ALL, which itself references FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID, to move from the legal entity registry into operating unit granularity.
• Validating integrity after data conversion or upgrade by confirming that every distinct LEGAL_ENTITY_ID in the subledger interfaces exists in FV_LEGAL_ENTITIES.
• Reporting audit trails via GL_LEGAL_ENTITIES_BSVS and GL_LEDGER_LE_BSV_GT, which carry LEGAL_ENTITY_ID and depend on the registry for balance sheet value set assignments.

Related Objects

The FK metadata documents an exceptionally broad dependency footprint. The following are among the most significant referencing objects:

• AP_INVOICES_ALL, AP_CHECKS_ALL, and AP_RECURRING_PAYMENTS_ALL — join on LEGAL_ENTITY_ID to attribute payables activity to an agency.
• RA_CUSTOMER_TRX_ALL, AR_CASH_RECEIPTS_ALL, and RA_INTERFACE_LINES_ALL — receivables transactions and receipts carrying the legal entity identifier.
• IBY_PAYMENTS_ALL, IBY_DOCS_PAYABLE_ALL, and IBY_BATCHES_ALL — payment processing objects in the Payments module.
• FV_OPERATING_UNITS_ALL — the closest Federal Financials companion table, referencing FV_LEGAL_ENTITIES on LEGAL_ENTITY_ID.
• GL_LEGAL_ENTITIES_BSVS and GL_LEDGER_LE_BSV_GT — General Ledger balance sheet value set assignments keyed by legal entity.
• CE_BANK_ACCT_USES_ALL and CE_STATEMENT_RECONCILS_ALL — cash management bank account usage and reconciliation records.
• XLE_ENTITY_PROFILES — the legal entity profile used by the Subledger Accounting and legal entity architecture, sharing the LEGAL_ENTITY_ID join column.

Collectively, these relationships confirm that FV_LEGAL_ENTITIES serves as a central reference point for legal entity identification across the EBS application suite.