Search Results ic_taxn_cls_pk

Overview

The IC_TAXN_CLS table is a core data object within the Oracle E-Business Suite (EBS) Process Manufacturing Inventory (GMI) module. It serves as the master repository for defining and storing item tax classifications. These classifications are critical for determining the appropriate tax rules and rates applied to manufactured items during financial transactions, such as sales and procurement. The table's primary role is to provide a standardized set of tax codes that can be consistently assigned to inventory items, ensuring accurate tax calculation and compliance within the manufacturing and distribution processes of Oracle EBS.

Key Information Stored

Based on the provided ETRM metadata, the central column in the IC_TAXN_CLS table is ICTAX_CLASS, which constitutes the table's primary key (IC_TAXN_CLS_PK). This column stores the unique identifier for each tax class. While the specific list of other columns is not detailed in the excerpt, a table of this nature typically includes descriptive fields such as a class description, an effective date range (from/to), and potentially an inactive date flag. The primary function is to maintain this controlled list of valid tax class codes, which are then referenced by numerous transactional and master data tables across the system.

Common Use Cases and Queries

A primary use case is the assignment of a tax class to an item within the Item Master (IC_ITEM_MST). This linkage dictates the tax treatment for all transactions involving that item. Common reporting and validation queries involve joining IC_TAXN_CLS to related tables. For instance, to list all active items and their assigned tax class descriptions, a query would join IC_ITEM_MST to IC_TAXN_CLS. Another critical use is tax setup and maintenance, where administrators query the IC_TAXN_CLS table to review existing classifications before creating new ones or updating tax associations. A sample SQL pattern to retrieve all defined tax classes would be: SELECT ictax_class, description FROM ic_taxn_cls WHERE NVL(disable_flag, 'N') = 'N' ORDER BY ictax_class;.

Related Objects

The IC_TAXN_CLS table has integral relationships with several key EBS objects, as indicated by its foreign key constraints. The IC_ITEM_MST table references it via the TAX_CLASS column, binding the tax classification to the item definition. For detailed tax rule assignment, the IC_TAXN_ASC (Tax Association) table references IC_TAXN_CLS, linking the class to specific tax codes and jurisdictions. Transactional tax history (TX_HIST_TAX) and tax authority details (TX_TAXA_DTL) also reference this table to preserve the tax class context of calculated taxes. Furthermore, it is linked to IC_TEXT_HDR for storing descriptive text, highlighting its role as a master configuration entity within the Process Manufacturing tax infrastructure.