Search Results jai_rgm_item_gen_docs




Overview
Explore in AI Chat

Overview

The JAI_RGM_ITEM_GEN_DOCS table is a core data repository within the Oracle E-Business Suite Asia/Pacific Localizations module (product JA). Its primary function is to store transactional metadata for documents generated during Tax Collected at Source (TCS) processing, a critical statutory requirement in jurisdictions such as India. The table acts as a central ledger, maintaining the relationship between original source transactions and the subsequent TCS documents generated for them. This ensures auditability and traceability for TCS compliance reporting and reconciliation within the financial system.

Key Information Stored

While the full column list is not detailed in the provided metadata, the structure and foreign key relationships define its key data elements. The table's primary key is the TRANSACTION_ID, which uniquely identifies each TCS document generation event. Two critical foreign key columns establish links to core Receivables transactions: SOURCE_DOCUMENT_ID references AR_CASH_RECEIPTS_ALL (for receipt-based TCS), and GENERATED_DOC_ID references RA_CUSTOMER_TRX_ALL (for the generated TCS invoice document). This design captures the complete lifecycle—from the originating receipt that triggered the TCS obligation to the formal tax invoice created.

Common Use Cases and Queries

The table is essential for compliance audits, troubleshooting TCS generation issues, and generating internal reports. Common operational and reporting queries include tracing the generation history for a specific receipt or invoice, and identifying TCS documents created within a specific period for reconciliation.

  • Trace TCS Document for a Receipt: SELECT igd.* FROM jai_rgm_item_gen_docs igd, ar_cash_receipts_all acr WHERE igd.source_document_id = acr.cash_receipt_id AND acr.receipt_number = '&RECEIPT_NUM';
  • Report Generated TCS Invoices for a Date Range: SELECT rcta.trx_number, igd.transaction_id, rcta.creation_date FROM jai_rgm_item_gen_docs igd, ra_customer_trx_all rcta WHERE igd.generated_doc_id = rcta.customer_trx_id AND rcta.creation_date BETWEEN :p_start_date AND :p_end_date;

Related Objects

JAI_RGM_ITEM_GEN_DOCS is integrally connected to several key EBS objects, primarily within the Receivables and localization modules. Its most direct relationships are through its defined foreign keys: it sources data from AR_CASH_RECEIPTS_ALL and RA_CUSTOMER_TRX_ALL. Furthermore, it has a recursive or hierarchical relationship with the JAI_RGM_REFS_ALL table, which references it via both PARENT_TRANSACTION_ID and TRANSACTION_ID columns. This suggests JAI_RGM_REFS_ALL may store additional reference or line-level details for the document generation events recorded in JAI_RGM_ITEM_GEN_DOCS, forming a complete TCS transaction model.