Results for “ap_reporting_entities_all”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AP.AP_REPORTING_ENTITIES_ALL is a Payables-owned table that stores tax identification information for tax reporting entities used in Oracle E-Business Suite. In 12.1.1 and 12.2.2, it functions as the master reference list of legal reporting entities (the organizations that file 1099 and related tax reports), each carrying the identifiers required by tax authorities, such as entity name, taxpayer identification number, and jurisdiction-specific registration numbers. The table spans 37 documented columns, and its "_ALL" suffix indicates that it is partitioned by operating unit through the ORG_ID column, with multiple organization (MOAC) access controlled at the row level. Rows are consumed by the 1096 data tables and by reporting entity line definitions, making this table the hub from which statutory tax reporting is assembled. From a Data Vault modeling perspective, the table is best characterized as hub-leaning: its primary key TAX_ENTITY_ID is a stable surrogate identifier, while descriptive attributes such as entity name and location behave like satellite or reference data attached to that hub. The foreign key to HR_LOCATIONS_ALL reinforces the role of the entity as a referenced location-based business object rather than a transactional artifact.

Key Information Stored

The surrogate primary key is TAX_ENTITY_ID, defined by the constraint AP_REPORTING_ENTITIES_PK. Three unique indexes supplement it as business-key candidates: AP_REPORTING_ENTITIES_U1 on (ENTITY_NAME, ORG_ID), AP_REPORTING_ENTITIES_U2 on (TAX_IDENTIFICATION_NUM, ORG_ID), and AP_REPORTING_ENTITIES_U3 on TAX_ENTITY_ID. The most significant business columns include:

• ENTITY_NAME — the legal name of the reporting entity; unique within an operating unit.
• TAX_IDENTIFICATION_NUM — the federal or national taxpayer identification number; unique within an operating unit.
• LOCATION_ID — foreign key to HR_LOCATIONS_ALL, supplying the entity's registered address.
• ORG_ID — operating unit partition key enforcing MOAC security.
• PRIMARY_ENTITY_FLAG — indicates whether the entity is the primary reporting entity.
• UNIQUE_TAX_REFERENCE_NUM, ACCOUNTS_OFFICE_REFERENCE, TAX_OFFICE_NUMBER, PAYE_REFERENCE, CIS_SENDER_ID — jurisdiction-specific registration and reference identifiers used on statutory returns.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard audit columns.
• GLOBAL_ATTRIBUTE_CATEGORY and GLOBAL_ATTRIBUTE1 through GLOBAL_ATTRIBUTE20 — the extensibility (DDF) flexfield for customer-specific data.

Common Use Cases and Queries

Typical usage centers on identifying which entity filed a given tax report and on validating that an entity's identifiers are correct before submission. Payables and tax reporting reports join AP_REPORTING_ENTITIES_ALL to the 1096 data tables through TAX_ENTITY_ID. A representative query retrieves entity identifiers for an operating unit:

• SELECT tax_entity_id, entity_name, tax_identification_num FROM ap_reporting_entities_all WHERE org_id = :p_org_id;
• SELECT a.*, l.address_line_1, l.city FROM ap_reporting_entities_all a, hr_locations_all l WHERE a.location_id = l.location_id;
• SELECT d.*, e.entity_name FROM ap_1096_data_all d, ap_reporting_entities_all e WHERE d.tax_entity_id = e.tax_entity_id;

These patterns support 1099/1096 reporting, entity lookup during supplier tax setup, and reconciliation of reporting entity lines against the registered identification details.

Related Objects

• HR_LOCATIONS_ALL — referenced by AP_REPORTING_ENTITIES_ALL.LOCATION_ID for the entity address.
• AP_1096_DATA_ALL — references this table via TAX_ENTITY_ID; holds 1096 summary reporting data.
• AP_REPORTING_ENTITY_LINES_ALL — references this table via TAX_ENTITY_ID; stores entity line definitions.
• FV_1096_DATA_ALL — additional 1096 reporting data referencing TAX_ENTITY_ID.
• AP_REPORTING_ENTITIES_PK / _U1 / _U2 / _U3 — the primary and unique constraints that define entity integrity.