Search Results ap_1096_data_all




Overview
Explore in AI Chat

Overview

AP_1096_DATA_ALL is a Payables (AP) module table in Oracle E-Business Suite 12.1.1 and 12.2.2, owned by the AP schema with a status of VALID. It stores summary payment information for 1099 type suppliers, providing the aggregated totals that support 1099 reporting and tax withholding compliance for reporting entities. Rather than holding line-level payment detail, the table consolidates summarized amounts and document counts associated with a given tax reporting entity and operating unit.

From a heuristic Data Vault classification (mined from the foreign key structure), this table is satellite-leaning. It carries descriptive and aggregated measures — totals and counts — rather than serving as an independent hub of unique business entities or as a pure link between two hubs. Under this modeling suggestion, AP_1096_DATA_ALL would be treated as a satellite attached to the reporting entity hub represented by AP_REPORTING_ENTITIES_ALL, keyed through TAX_ENTITY_ID.

Key Information Stored

The table is documented with seven columns in ETRM 12.2.2. The most important columns include:

  • TAX_ENTITY_ID — The foreign key to AP_REPORTING_ENTITIES_ALL that identifies the tax reporting entity to which the summarized 1099 information belongs.
  • TOTAL_REPORTED — The summarized amount reported for the 1099 supplier population associated with the tax entity.
  • TOTAL_WITHHELD — The summarized amount withheld for tax purposes.
  • NUMBER_OF_DOCUMENTS — The count of documents aggregated into the summary, capturing the volume behind the reported totals.
  • ORG_ID — The operating unit identifier, enabling multi-org (partitioned) access and reporting by organization.
  • LAST_UPDATE_DATE — The date of the most recent modification to the summary record.
  • LAST_UPDATED_BY — The user identifier responsible for the most recent update.

The metadata does not document a surrogate primary key column or a unique business key index for this table. Combined with ORG_ID, TAX_ENTITY_ID functions as the primary business-key candidate for identifying a summary row within an operating unit; this table is multi-org partitioned, and ORG_ID should be included in every query.

Common Use Cases and Queries

Typical usages center on 1099 reporting, tax withholding reconciliation, and reporting entity rollups.

  • Summarizing reported and withheld totals per tax entity for a reporting period.
  • Reconciling document counts against underlying payment and invoice detail.
  • Joining summarized totals to the reporting entity definition to obtain entity names and attributes.

A representative query pattern joining the reporting entity dimension:

SELECT d.TAX_ENTITY_ID, d.ORG_ID, d.TOTAL_REPORTED, d.TOTAL_WITHHELD, d.NUMBER_OF_DOCUMENTS, d.LAST_UPDATE_DATE FROM AP.AP_1096_DATA_ALL d, AP.AP_REPORTING_ENTITIES_ALL e WHERE d.TAX_ENTITY_ID = e.TAX_ENTITY_ID AND d.ORG_ID = :p_org_id;

Related Objects

The most significant related object is the reporting entity table referenced by the documented foreign key relationship:

  • AP_REPORTING_ENTITIES_ALL — Referenced by AP_1096_DATA_ALL.TAX_ENTITY_ID; supplies the reporting entity definition for each summarized 1099 row.

Because the documented metadata lists only this single foreign key relationship, the related-object set is intentionally limited. Additional 1099 and payment-detail dependencies (such as supplier and payment tables in the AP module) are known to exist functionally, but they are not enumerated in the provided ETRM relationship data and should be confirmed against the actual AP 1099 reporting schema before being treated as documented dependencies.