Search Results ic_taxn_asc




Overview
Explore in AI Chat

Overview

The IC_TAXN_ASC table is a core data object within the Oracle E-Business Suite Process Manufacturing (GMI) inventory module. It serves a critical configuration and transactional role by defining the association between inventory items and their corresponding tax classifications. This table acts as the central repository that links an item's master record to a specific tax class, enabling the system to apply the correct tax rules and rates during procurement, sales, and manufacturing transactions. Its integrity is essential for ensuring accurate tax calculations and compliance within the Process Manufacturing environment.

Key Information Stored

The table's structure is designed to maintain a unique relationship between an item and its tax class. Its primary key is a composite of two columns, ensuring a one-to-one mapping for a given item. The most significant columns include:

  • ITEM_ID: A foreign key that uniquely identifies the inventory item from the IC_ITEM_MST or IC_ITEM_MST_B table.
  • ICTAX_CLASS: A foreign key that references the IC_TAXN_CLS table, storing the code for the specific item tax class assigned to the item.
  • TEXT_CODE: An optional foreign key linking to the IC_TEXT_HDR table, potentially used to store descriptive notes or legal text related to the tax association.

Common Use Cases and Queries

This table is primarily queried during transaction processing and for tax reporting and maintenance. A common operational query retrieves the tax class for a specific item to determine the applicable tax rate during order entry or invoice creation. For example: SELECT ictax_class FROM gmi.ic_taxn_asc WHERE item_id = :p_item_id;. Administrators frequently use this table to audit or update tax assignments across the item catalog, such as finding all items associated with a particular tax class for a regulatory change. Reporting use cases include generating lists of items by tax classification for financial analysis or compliance audits, often joining with IC_ITEM_MST for item descriptions and IC_TAXN_CLS for class details.

Related Objects

As indicated by its foreign keys, IC_TAXN_ASC is deeply integrated with other foundational tables in the GMI schema. Its primary relationships are:

  • IC_ITEM_MST / IC_ITEM_MST_B: The master item tables, which define the inventory items themselves.
  • IC_TAXN_CLS: The table defining the valid tax classes, to which the ICTAX_CLASS column points.
  • IC_TEXT_HDR: The table storing optional descriptive text blocks referenced by the TEXT_CODE.

These relationships ensure data integrity, cascading from the master definition of an item and a tax class down to their specific association in the IC_TAXN_ASC table.