Search Results jai_cmn_tax_ctgs_all_pk




Overview
Explore in AI Chat

Overview

The JAI_CMN_TAX_CTGS_ALL table is a core master data table within the Oracle E-Business Suite Asia/Pacific Localizations module (Product JA). It functions as the central repository for defining and storing tax categories, which are critical for the calculation and application of excise and other localized taxes in jurisdictions such as India. Its primary role is to establish and maintain the link between these tax categories and excise item classes, enabling the system to determine the correct tax treatment for transactions involving inventory items, purchase orders, invoices, and sales orders. The table supports multi-organization access control through its ALL structure and ORG_ID column.

Key Information Stored

While the provided metadata does not list specific columns beyond key identifiers, the table's structure can be inferred from its relationships and purpose. The primary column is TAX_CATEGORY_ID, which serves as the unique identifier (Primary Key: JAI_CMN_TAX_CTGS_ALL_PK). The ORG_ID column links the tax category definition to an operating unit via a foreign key to HR_ALL_ORGANIZATION_UNITS. Other essential columns likely include descriptive fields such as TAX_CATEGORY_NAME or CODE, effective dates (CREATION_DATE, LAST_UPDATE_DATE), and columns defining the association to excise item classes. The table's description confirms it stores the definitive link between a tax category and an excise item class, a fundamental relationship for tax determination logic.

Common Use Cases and Queries

This table is central to tax configuration and transactional tax processing. Common use cases include the setup and maintenance of tax categories for new products or services, troubleshooting tax calculation errors on transactions, and generating reports on tax category usage. A frequent query involves joining the table to transactional lines to verify the applied tax category. For example, to audit tax categories on purchase order lines, one might use:

  • SELECT pol.line_num, pol.item_description, tc.tax_category_id, tc.tax_category_name FROM po_lines_all pol JOIN jai_cmn_tax_ctgs_all tc ON pol.tax_category_id = tc.tax_category_id WHERE pol.po_header_id = <PO_ID>;

Another critical scenario is during tax master data updates, where the table is referenced by change history tables like JAI_CMN_MTAX_HDRS_ALL and JAI_CMN_TAXCTG_UPDATES to track modifications from an old to a new tax category.

Related Objects

The JAI_CMN_TAX_CTGS_ALL table has extensive relationships, acting as a key reference for transactional and configuration sub-modules. It references HR_ALL_ORGANIZATION_UNITS via ORG_ID. Crucially, its TAX_CATEGORY_ID is referenced by a wide array of tables, demonstrating its integration across the financial and supply chain suites: