Search Results jai_rgm_dis_des_taxes




Overview
Explore in AI Chat

Overview

The JAI_RGM_DIS_DES_TAXES table is a core transactional data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is specifically designed to support regional tax compliance, particularly for jurisdictions requiring detailed tracking of tax transfers between different legal entities or tax jurisdictions. As documented, its primary role is to store the detailed line-level records for destination taxes and the corresponding transfer amounts. This table functions as a child table in the tax transfer process, linking source tax liabilities to their allocated destination records, thereby enabling accurate financial reporting and audit trails for inter-company or inter-regional tax settlements.

Key Information Stored

While the provided ETRM excerpt does not list specific columns beyond the key identifiers, the structure and relationships define its critical data elements. The primary key, TRANSFER_DESTINATION_LINE_ID, uniquely identifies each destination tax line. The foreign key columns are essential for establishing relationships: TRANSFER_SOURCE_ID links back to the originating tax record in the JAI_RGM_DIS_SRC_TAXES table, and TRANSFER_DESTINATION_ID links to the header information in the JAI_RGM_DIS_DES_HDRS table. Typically, such a table would also store detailed amounts (e.g., tax base, tax rate, calculated tax amount), tax type identifiers, legal entity codes, and effective dates to fully describe the tax obligation being transferred to the destination.

Common Use Cases and Queries

This table is central to generating tax transfer reports, reconciling inter-company tax postings, and supporting statutory audits. A common operational use case is tracing the complete journey of a tax amount from its source transaction to its final destination settlement. A typical analytical query would join this table to its parent and source tables to report on all transfers for a period. For example:

  • Identifying the total tax transferred to a specific destination entity: SELECT SUM(tax_amount), transfer_destination_id FROM jai_rgm_dis_des_taxes WHERE ... GROUP BY transfer_destination_id;
  • Reconciling source and destination totals by joining to JAI_RGM_DIS_SRC_TAXES on the TRANSFER_SOURCE_ID column.
  • Supporting audit trails by providing line-level detail for every tax transfer documented in the system.

Related Objects

The JAI_RGM_DIS_DES_TAXES table is a nexus within a specific sub-schema for tax distribution. Its documented relationships are critical for data integrity:

  • Primary Key Constraint (JAI_RGM_DIS_DES_TAXES_PK): Enforces uniqueness on the TRANSFER_DESTINATION_LINE_ID column.
  • Foreign Key to JAI_RGM_DIS_SRC_TAXES: The TRANSFER_SOURCE_ID column references a source tax line. This relationship ensures every destination tax allocation can be traced back to its original source liability.
  • Foreign Key to JAI_RGM_DIS_DES_HDRS: The TRANSFER_DESTINATION_ID column references a destination header. This groups multiple tax line details under a single transfer document or batch header for the destination.

This structure indicates that JAI_RGM_DIS_DES_TAXES is a child table to both JAI_RGM_DIS_DES_HDRS (for header info) and JAI_RGM_DIS_SRC_TAXES (for source lineage), forming a critical link in the tax transfer chain.