Search Results tax_distribution_id

Overview

The table JAI_AP_MATCH_INV_TAXES is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite, versions 12.1.1 and 12.2.2. It is specifically designed to store transactional tax details that arise during the accounts payable invoice matching process. Its primary role is to capture and maintain records for miscellaneous distributions created for tax calculations on invoices that are matched to purchase orders and receipts. This table is integral to ensuring accurate tax accounting and compliance for localized tax regimes across the Asia/Pacific region, acting as a detailed subsidiary ledger for tax-related invoice distributions.

Key Information Stored

The table's structure centers on linking tax distributions to their originating transactional entities. The primary key is TAX_DISTRIBUTION_ID, which uniquely identifies each tax distribution record. Critical foreign key columns establish the necessary relationships to define the transaction's context. These include INVOICE_ID (linking to AP_INVOICES_ALL), SHIPMENT_HEADER_ID and SHIPMENT_LINE_ID (linking to RCV tables), and PO_DISTRIBUTION_ID (linking to purchase order distributions). For tax determination, it stores TAX_ID, referencing JAI_CMN_TAXES_ALL. Accounting is managed through several code combination IDs, such as CODE_COMBINATION_ID for the tax liability account and ACCT_PAY_CODE_COMBINATION_ID. The SET_OF_BOOKS_ID column ties the record to the specific ledger, ensuring multi-org integrity.

Common Use Cases and Queries

This table is primarily accessed for tax reconciliation, audit reporting, and troubleshooting invoice tax calculations. A common operational query involves verifying all tax distributions for a specific invoice to ensure proper accounting entries were generated. For example:

• SELECT * FROM jai_ap_match_inv_taxes WHERE invoice_id = <invoice_id>;

Another critical use case is tracing tax amounts from a purchase order receipt through to the final invoice payment. Analysts may join this table with RCV_TRANSACTIONS and PO_DISTRIBUTIONS_ALL to analyze tax variances between the ordered, received, and invoiced quantities. Reporting use cases often aggregate tax amounts by tax type, legal entity, or period for statutory compliance filings. Performance tuning may require monitoring the volume of records created during high-volume invoice processing runs.

Related Objects

JAI_AP_MATCH_INV_TAXES is a central hub with extensive dependencies on standard EBS and localization tables. Its key relationships, as defined by its foreign keys, include:

• AP_INVOICES_ALL: The core invoice header.
• RCV_SHIPMENT_HEADERS, RCV_SHIPMENT_LINES, RCV_TRANSACTIONS: For receipt matching context.
• PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL, PO_DISTRIBUTIONS_ALL: For purchase order matching context.
• JAI_CMN_TAXES_ALL: For the master tax definition and rates.
• GL_CODE_COMBINATIONS: For multiple accounting flexfields (liability, payment, variance).
• GL_LEDGERS: For the set of books/ledger context.

This network of relationships positions the table as a critical junction between the Procure-to-Pay cycle and the localized tax engine.