Search Results pa_legal_entity_it




Overview
Explore in AI Chat

Overview

The PA_LEGAL_ENTITY_IT table is a core data object within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2, specifically for the Projects (PA) module. It serves as the primary repository for legal entity information used by the Oracle Project Analysis Collection Pack. This pack is a component designed to extract, transform, and load project-related data into a data warehouse for analytical reporting. The table's role is to provide a master list of legal entities that are associated with project financial data, enabling accurate aggregation and reporting across organizational and legal boundaries. Its existence is critical for ensuring that project costing, revenue, and other financial metrics are correctly attributed to the appropriate legal entity for compliance and management reporting.

Key Information Stored

Based on the provided metadata, the table's structure centers on identifying the legal entity and its relationship to the financial setup. The primary key column is LEGAL_ENTITY, which stores the unique identifier for a legal entity within the system. A second critical column is SET_OF_BOOKS, which links the legal entity to its specific accounting ledger or chart of accounts. This foreign key relationship ensures that project transactions for a given legal entity are posted to the correct set of books. While the full column list is not detailed in the excerpt, the table's purpose implies it likely contains other descriptive or control attributes necessary for the Analysis Collection Pack's ETL processes.

Common Use Cases and Queries

The primary use case for this table is within the data extraction logic of the Project Analysis Collection Pack. It is queried to build the dimension for legal entities in the project analytics star schema. Common operational queries involve joining this table to project transaction sources to decorate raw data with legal entity context. A fundamental reporting query pattern is to retrieve the list of legal entities with their associated ledgers:

  • SELECT legal_entity, set_of_books FROM pa.pa_legal_entity_it;

For data validation or reconciliation purposes, administrators may query the integrity of the foreign key relationship to the set of books:

  • SELECT le.* FROM pa.pa_legal_entity_it le WHERE NOT EXISTS (SELECT 1 FROM pa_set_of_books_it sob WHERE sob.set_of_books = le.set_of_books);

Related Objects

The PA_LEGAL_ENTITY_IT table has documented foreign key relationships with two other tables in the Project Analysis Collection Pack schema, as per the provided metadata:

  • PA_SET_OF_BOOKS_IT: The PA_LEGAL_ENTITY_IT.SET_OF_BOOK column is a foreign key to this table, linking each legal entity to its corresponding accounting ledger.
  • PA_OPER_UNITS_IT: This table holds a foreign key reference (PA_OPER_UNITS_IT.LEGAL_ENTITY) back to the PA_LEGAL_ENTITY_IT table. This relationship associates operating units with their governing legal entity, a crucial link for organizational reporting hierarchies within project analytics.

The primary key constraint PA_LEGAL_ENTITY_IT_PK on the LEGAL_ENTITY column enforces uniqueness and is referenced by the foreign key in PA_OPER_UNITS_IT.