Results for “product_fisc_classification”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AR_TAX_GROUP_CODES_ALL is a Receivables (AR) module table that stores the individual tax codes belonging to a tax group, along with the conditions and exceptions that govern how each tax code applies. In Oracle EBS 12.1.1 and 12.2.2, tax groups are used to bundle multiple tax codes so a single tax group can be assigned to a transaction line, letting the system derive and calculate the appropriate taxes during AutoInvoice and manual transaction entry.

Each row represents the intersection of a tax group and one of its member tax codes, plus optional condition and exception components that control when the tax applies. The primary key is AR_TAX_GROUP_CODES_PK, defined on the TAX_GROUP_CODE_ID column. The table is partitioned conceptually by operating unit via ORG_ID, and the _ALL suffix confirms it is a multi-org object requiring an ORG_ID predicate in queries.

Based on the foreign-key topology, the heuristic Data Vault classification is satellite-leaning: the table carries descriptive and control attributes (display order, dates, enabled flag, fiscal classifications) that describe and qualify relationships, rather than acting as a standalone hub or a pure link. It is best modeled as satellite-style context around the tax group and tax code entities.

Key Information Stored

The table contains 57 columns. The most significant for functional and reporting purposes are:

• TAX_GROUP_CODE_ID – surrogate primary key, generated per row (AR_TAX_GROUP_CODES_PK).
• TAX_GROUP_ID – foreign key to AR_VAT_TAX_ALL_B identifying the parent tax group.
• TAX_CODE_ID – foreign key to AR_VAT_TAX_ALL_B identifying the member tax code.
• TAX_GROUP_TYPE – classifies the grouping context (for example, standard or special tax grouping).
• TAX_CONDITION_ID / TAX_EXCEPTION_ID – foreign keys to AR_TAX_CONDITIONS_ALL, defining the condition that triggers the code and any exception that suppresses it.
• DISPLAY_ORDER – sequencing used when multiple codes appear in a group.
• COMPOUNDING_PRECEDENCE – controls calculation order for compounded taxes.
• START_DATE / END_DATE – effective dating for the group-code association.
• ENABLED_FLAG – active/inactive status of the association.
• ORG_ID – operating unit, enforcing multi-org security.
• PRODUCT_FISC_CLASSIFICATION, TRX_BUSINESS_CATEGORY_CODE, PARTY_FISC_CLASSIFICATION – fiscal classification for product, transaction business category, and party, used in tax determination.
• Standard audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE) and the ATTRIBUTE1–15 / GLOBAL_ATTRIBUTE1–20 descriptive flexfield columns.

The business-key candidate is the combination of TAX_GROUP_ID, TAX_CODE_ID, TAX_CONDITION_ID, TAX_EXCEPTION_ID and ORG_ID, which uniquely identifies a group-code association within an operating unit.

Common Use Cases and Queries

Typical uses include configuration review, tax determination diagnostics, and reporting on which tax codes a group resolves to for a given transaction.

Listing all tax codes in a group:

SELECT tgd.tax_group_code_id, tgd.tax_group_id, tgd.tax_code_id,
       tgd.display_order, tgd.enabled_flag, tgd.start_date, tgd.end_date
FROM   ar_tax_group_codes_all tgd
WHERE  tgd.tax_group_id = :p_tax_group_id
AND    tgd.org_id = :p_org_id
AND    SYSDATE BETWEEN NVL(tgd.start_date, SYSDATE)
                    AND NVL(tgd.end_date, SYSDATE + 1)
ORDER BY tgd.display_order;

Joining to resolve tax code names and conditions:

SELECT tg.tax_group_code, tc.tax_code, tgd.display_order
FROM   ar_tax_group_codes_all tgd,
       ar_vat_tax_all_b tg,
       ar_vat_tax_all_b tc
WHERE  tgd.tax_group_id = tg.tax_id
AND    tgd.tax_code_id  = tc.tax_id
AND    tgd.org_id = :p_org_id
AND    tgd.enabled_flag = 'Y';

These queries support receivables analysts verifying tax group setup, troubleshooting unexpected tax amounts on invoices, and building reconciliation extracts.

Related Objects

• AR_VAT_TAX_ALL_B – referenced twice via TAX_GROUP_ID and TAX_CODE_ID; the master tax code and tax group definition table.
• AR_TAX_CONDITIONS_ALL – referenced via TAX_CONDITION_ID and TAX_EXCEPTION_ID; defines applicability conditions and exceptions.
• AR_DISTRIBUTIONS_ALL – references AR_TAX_GROUP_CODES_ALL.TAX_GROUP_CODE_ID; captures tax lines on distributions.
• AR_MC_DISTRIBUTIONS_ALL – multi-currency counterpart referencing TAX_GROUP_CODE_ID.
• AR_TAX_GROUPS / AR_VAT_TAX_ALL views and the Receivables tax setup forms consume these associations during tax calculation.
• AR_INVOICE_API_PUB and AutoInvoice import logic resolve tax groups through this table when deriving invoice tax lines.