Search Results ap_reporting_entity_lines_pk

Overview

AP.AP_REPORTING_ENTITY_LINES_ALL is a Payables module table that stores the balancing segment information associated with a tax reporting entity. In Oracle EBS Releases 12.1.1 and 12.2.2, tax reporting entities allow an organization to group one or more balancing segment values under a single tax reporting unit, so that transactional tax data (for example, 1099 or global withholding reporting) can be aggregated and reported consistently. This table supplies the crucial mapping between a reporting entity recorded in AP_REPORTING_ENTITIES_ALL and the ledger balancing segment value (typically the company segment) that falls under it.

The object resides in the AP schema and is classified as VALID in the ETRM 12.2.2 repository. Its heuristic Data Vault classification is satellite-leaning, which suggests it is best modeled as a descriptive satellite attached to the reporting entity hub, with the balancing segment value acting as a dependent business attribute rather than an independent entity.

Key Information Stored

The table contains nine documented columns. The most significant are:

• BALANCING_SEGMENT_VALUE — The balancing segment value (company) that is assigned to the tax reporting entity. This column participates in the primary key.
• TAX_ENTITY_ID — Foreign key to AP_REPORTING_ENTITIES_ALL; identifies the parent tax reporting entity to which the balancing segment belongs.
• DESCRIPTION — Free-text description of the balancing segment line, useful for reporting labels.
• ORG_ID — Operating unit / organization identifier; enforces multi-org security and appears in the unique index.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard audit columns capturing who last modified the row and when.
• CREATION_DATE, CREATED_BY — Standard audit columns capturing row creation metadata.

The surrogate primary key is AP_REPORTING_ENTITY_LINES_PK, defined on BALANCING_SEGMENT_VALUE. The business-key candidate is the unique index AP_REPORTING_ENTITY_LINES_U1, defined on the combination (BALANCING_SEGMENT_VALUE, ORG_ID). This design ensures a balancing segment value is unique per operating unit.

Common Use Cases and Queries

Typical scenarios include determining which balancing segment values map to a given tax reporting entity, validating that a transaction’s company segment is properly assigned before tax reporting runs, and building reports that summarize Payables activity by reporting entity.

A common join pattern retrieves the reporting entity name alongside its balancing segments:

• SELECT l.balancing_segment_value, l.description, e.entity_name
• FROM ap.ap_reporting_entity_lines_all l,
•      ap.ap_reporting_entities_all e
• WHERE l.tax_entity_id = e.tax_entity_id
•   AND l.org_id = :p_org_id;

Multi-org queries should always constrain ORG_ID to respect operating unit security. Reconciliation queries frequently join to GL_CODE_COMBINATIONS via the balancing segment value to verify that each company segment has an assigned reporting entity, and to AP_INVOICES_ALL to confirm tax-reportable invoices fall under a valid entity.

Related Objects

• AP_REPORTING_ENTITIES_ALL — Parent table; joined on TAX_ENTITY_ID. Holds the reporting entity definition and tax entity identifier.
• AP_REPORTING_ENTITY_LINES_PK / U1 — Primary key and unique index enforcing uniqueness of balancing segment value per operating unit.
• GL_CODE_COMBINATIONS — Supplies the balancing segment value definition used for validation and reporting.
• AP_INVOICES_ALL — Source of tax-reportable transactions aggregated by reporting entity.
• AP_INVOICE_LINES_ALL — Line-level detail often aggregated when producing tax reports by entity.
• AP_TAX_CODES_ALL — Defines the tax codes applied to invoices reported under each entity.
• AP_SUPPLIERS / AP_SUPPLIER_SITES_ALL — Vendor data frequently joined when producing 1099-style reporting by reporting entity.

Together these objects support the tax reporting entity framework within Payables, with AP_REPORTING_ENTITY_LINES_ALL serving as the essential link between ledger balancing segments and the reporting entities that govern statutory tax reporting.