Search Results transfer_source_id

Overview

The JAI_RGM_DIS_SRC_TAXES table is a core data object within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) releases 12.1.1 and 12.2.2. It is specifically designed to support tax-related functionality for regional goods movement, such as distribution or transfer between organizations. As documented, its primary role is to store detailed tax and amount information that has been transferred from a source organization. This table acts as a critical child record in the transactional flow, capturing the tax breakdown for a given transfer, which is essential for accurate financial accounting and compliance reporting in regulated jurisdictions.

Key Information Stored

The table's structure is centered around linking tax line details to a parent transfer header and providing a unique identifier for downstream processing. The primary key, TRANSFER_SOURCE_ID, is a unique identifier for each tax line record stored in this table. A critical foreign key, TRANSFER_ID, links each tax line to its corresponding parent header record in the JAI_RGM_DIS_SRC_HDRS table, establishing the core transactional relationship. While the full column list is not detailed in the provided metadata, based on its described purpose, the table typically stores data such as the tax code or rate applied, the taxable amount, the calculated tax amount, and potentially the tax jurisdiction or recovery type for the sourced transaction.

Common Use Cases and Queries

This table is primarily accessed for generating detailed tax reports for inter-organization transfers, reconciling tax amounts during period-end close, and supporting audit inquiries. A common reporting requirement is to aggregate all tax amounts for a specific transfer document. The following sample query demonstrates joining to the header table to achieve this, using the documented foreign key relationship:

• SELECT src_hdr.transfer_number, SUM(src_tax.tax_amount) FROM jai_rgm_dis_src_taxes src_tax JOIN jai_rgm_dis_src_hdrs src_hdr ON src_tax.transfer_id = src_hdr.transfer_id WHERE src_hdr.transfer_date BETWEEN :p_start_date AND :p_end_date GROUP BY src_hdr.transfer_number;

Another critical use case involves tracing the propagation of source tax details to destination records, which is enabled by the TRANSFER_SOURCE_ID column being referenced by destination tables.

Related Objects

The JAI_RGM_DIS_SRC_TAXES table is integral to a defined hierarchy of tables managing the distribution process. Its documented relationships are as follows:

• Parent Reference (Foreign Key): The table references JAI_RGM_DIS_SRC_HDRS via the TRANSFER_ID column. This links every tax line to its master transfer transaction.
• Child References (Foreign Keys to this table): Two key tables reference JAI_RGM_DIS_SRC_TAXES using its primary key:
  • JAI_RGM_DIS_DES_HDRS references it via TRANSFER_SOURCE_ID, likely to associate a destination header with its originating source tax data.
  • JAI_RGM_DIS_DES_TAXES references it via TRANSFER_SOURCE_ID, creating a direct lineage between source and destination tax line items, which is vital for audit trails and reconciliation.