Search Results ap_tax_codes_all

Overview

The AP_TAX_CODES_ALL table is a core repository for tax code configuration within Oracle E-Business Suite Payables (AP). It stores the master definition of tax codes used for calculating and recording taxes on invoices, purchase orders, and requisitions. In the context of Oracle EBS 12.1.1 and 12.2.2, this table plays a critical role in the legacy tax engine, providing the tax rate and accounting information that the system applies to transactions. Its data is fundamental for ensuring accurate tax calculations, proper tax liability accounting, and the generation of withholding (AWT) payments to tax authorities.

Key Information Stored

The table's primary key is the TAX_ID column, which uniquely identifies each tax code. Based on the documented foreign key relationships, other critical columns include SET_OF_BOOKS_ID, which links the tax code to a specific ledger, and TAX_CODE_COMBINATION_ID, which defines the general ledger liability account for the tax amount. For withholding tax functionality, AWT_VENDOR_ID and AWT_VENDOR_SITE_ID specify the payee vendor. The TAX_RECOVERY_RULE_ID links to recovery rate schedules, and OFFSET_TAX_CODE_ID enables the definition of tax codes that offset one another. The table also stores the tax code name, rate, effective dates, and various control flags governing its application.

Common Use Cases and Queries

A primary use case is troubleshooting tax calculation errors on invoices by verifying the active tax code definitions. Developers and analysts frequently query this table to support reporting on tax liabilities or to validate setups during migrations. A common query retrieves all tax codes for a specific ledger, including their accounting flexfield:

• SELECT tax_id, tax_code, tax_rate, tax_code_combination_id FROM ap_tax_codes_all WHERE set_of_books_id = :ledger_id AND SYSDATE BETWEEN effective_from AND NVL(effective_to, SYSDATE);

Another critical scenario involves understanding the mapping to the newer Oracle E-Business Tax (EBTax) engine, as indicated by the user's search for "zx_id_tcc_mapping_all." The foreign key from ZX_ID_TCC_MAPPING_ALL.TAX_RATE_CODE_ID to AP_TAX_CODES_ALL.TAX_ID is a key integration point, mapping legacy tax codes to EBTax tax regime, tax, and rate codes.

Related Objects

AP_TAX_CODES_ALL has extensive relationships across financial, procurement, and tax modules, as documented in the ETRM metadata. Key foreign key dependencies include:

• GL_SETS_OF_BOOKS_11I / GL_CODE_COMBINATIONS: For ledger and accounting context (SET_OF_BOOKS_ID, TAX_CODE_COMBINATION_ID).
• AP_INVOICE_DISTRIBUTIONS_ALL: Invoice lines store the applied TAX_CODE_ID.
• PO_LINE_LOCATIONS_ALL / PO_REQUISITION_LINES_ALL: Purchase order shipment and requisition lines reference TAX_CODE_ID.
• AP_TAX_RECVRY_RULES_ALL: Linked via TAX_RECOVERY_RULE_ID for tax recovery rules.
• ZX_ID_TCC_MAPPING_ALL: Critical for EBTax integration, mapping TAX_ID to EBTax entities (TAX_RATE_CODE_ID).
• ZX_LINES_DET_FACTORS: Stores historical tax code references (HISTORICAL_TAX_CODE_ID) for reporting.
• PO_VENDORS / PO_VENDOR_SITES_ALL: For AWT vendor setup (AWT_VENDOR_ID, AWT_VENDOR_SITE_ID).