Search Results jai_cmn_taxes_all

Overview

The JAI_CMN_TAXES_ALL table is a core master data object within the Oracle E-Business Suite Asia/Pacific Localizations module (Product JA). It serves as the central repository for defining and storing localization-specific tax regimes, particularly those mandated for countries like India. Its primary role is to establish and maintain the fundamental tax codes and rules that drive automated tax calculations, withholding (TDS), and reporting within localized financial transactions for both Payables (AP) and Receivables (AR). The table's "ALL" suffix indicates it is a multi-organization access enabled (MOAC) table, storing data partitioned by the ORG_ID column.

Key Information Stored

While the provided metadata does not list all columns, the primary and foreign key relationships reveal critical data points. The table is uniquely identified by TAX_ID (primary key) and TAX_NAME (unique key). Essential stored information includes the linkage to the general ledger via TAX_ACCOUNT_ID, which references GL_CODE_COMBINATIONS to determine the accounting flexfield for tax liability. For withholding tax scenarios, it stores vendor details through VENDOR_ID and VENDOR_SITE_ID, referencing HZ_PARTIES and HZ_PARTY_SITES respectively. Other typical columns in such a master table would include effective dates, tax rates, tax types (e.g., VAT, TDS, WCT), and jurisdiction indicators, which configure the tax's behavior across the localized transaction lifecycle.

Common Use Cases and Queries

This table is central to localization-specific tax processing. Common operational and reporting use cases include validating tax setup for a transaction, identifying the GL account for a specific tax, and analyzing all defined taxes for a legal entity. Sample SQL patterns often involve joining to related transaction tables.

• Tax Setup Validation: SELECT tax_id, tax_name FROM jai_cmn_taxes_all WHERE org_id = :p_org_id AND enabled_flag = 'Y' ORDER BY tax_name;
• Identifying Tax GL Account: SELECT jct.tax_name, gcc.segment1, gcc.segment2 FROM jai_cmn_taxes_all jct, gl_code_combinations gcc WHERE jct.tax_account_id = gcc.code_combination_id AND jct.tax_id = :p_tax_id;
• Transaction Tax Analysis: Joining to transaction detail tables like JAI_AR_TRX_TAX_LINES to report on applied taxes for invoices.

Related Objects

JAI_CMN_TAXES_ALL has extensive relationships, acting as a parent table for numerous transactional and setup entities within the localization, particularly for Indian Tax Deducted at Source (TDS) and Works Contract Tax (WCT). Key child tables, as per the foreign key metadata, include:

• Payables (AP) TDS Processing: JAI_AP_TDS_INVOICES, JAI_AP_TDS_PAYMENTS, JAI_AP_TDS_PREPAYMENTS, JAI_AP_TDS_VENDOR_HDRS, JAI_AP_ETDS_T.
• Payables Tax Matching: JAI_AP_MATCH_INV_TAXES, JAI_AP_TDS_INV_TAXES.
• Receivables (AR) Tax Processing: JAI_AR_TRX_TAX_LINES, JAI_AR_TRX_INS_LINES_T.
• Core Setup: It references master tables GL_CODE_COMBINATIONS and HZ_PARTIES for account and third-party data.

This network of dependencies underscores its critical role as the authoritative source of tax definitions for the JA localization module in both Oracle EBS 12.1.1 and 12.2.2.