Search Results zx_id_tcc_mapping_all

Overview

The AR_VAT_TAX_ALL_B table is a core master data repository within Oracle E-Business Suite (EBS) Receivables (AR) module, specifically for versions 12.1.1 and 12.2.2. It stores the fundamental definition of tax codes and their associated rates as configured through the application's "Tax Codes and Rates" window. This table serves as the system of record for Value-Added Tax (VAT) and other tax regimes, enabling the calculation and posting of tax on transactions. Its role is central to the tax engine, linking tax definitions to transactional data such as invoices, cash receipts, and revenue distributions.

Key Information Stored

The table's primary key structure, consisting of TAX_CODE and START_DATE, indicates it is designed to store historical rate changes for each tax code, allowing for accurate tax calculations based on the transaction date. While the provided metadata does not list all columns, the foreign key relationships reveal critical stored information. Each record is uniquely identified by a VAT_TAX_ID (as per the AR_VAT_TAX_ALL_B_UK unique key). Essential data points include the SET_OF_BOOKS_ID for ledger-specific tax setups and the TAX_ACCOUNT_ID, which links to the GL_CODE_COMBINATIONS table to define the general ledger account used for posting the tax amount.

Common Use Cases and Queries

This table is primarily referenced for tax determination, validation, and reporting. Common use cases include validating the active tax rate for a given date, troubleshooting tax calculation errors on transactions, and generating reports of all configured tax codes. A typical query would join transaction lines to this table to retrieve the applicable tax rate and account. For example, to find the tax details applied to an invoice line:

• SELECT trx_line.vat_tax_id, tax.tax_code, tax.tax_account_id FROM ra_customer_trx_lines_all trx_line JOIN ar_vat_tax_all_b tax ON trx_line.vat_tax_id = tax.vat_tax_id AND trx_line.trx_date BETWEEN tax.start_date AND NVL(tax.end_date, SYSDATE) WHERE trx_line.customer_trx_id = :p_trx_id;

Another common pattern is querying the table directly to list all tax codes for a specific ledger: SELECT tax_code, start_date, tax_account_id FROM ar_vat_tax_all_b WHERE set_of_books_id = :p_sob_id ORDER BY tax_code, start_date.

Related Objects

The AR_VAT_TAX_ALL_B table has extensive integration across EBS, as evidenced by its foreign key relationships. Key related objects include:

• RA_CUSTOMER_TRX_LINES_ALL: Transaction lines store the VAT_TAX_ID to link to the specific tax code applied.
• AR_CASH_RECEIPTS_ALL: References VAT_TAX_ID for tax on receipts.
• GL_CODE_COMBINATIONS: Provides the accounting flexfield (TAX_ACCOUNT_ID) for the tax liability account.
• AR_TAX_GROUP_CODES_ALL: Links tax codes into tax groups via TAX_CODE_ID and TAX_GROUP_ID.
• Project Accounting (PA) Tables: Multiple PA tables (e.g., PA_CUST_REV_DIST_LINES_ALL, PA_DRAFT_INVOICE_ITEMS) reference OUTPUT_VAT_TAX_ID for project-related tax calculations.
• E-Business Tax (ZX) Tables: Tables like ZX_ID_TCC_MAPPING_ALL and ZX_LINES_DET_FACTORS reference this table, illustrating its integration with the advanced E-Business Tax subsystem for historical and mapping purposes.