Search Results jai_rgm_trx_records

Overview

The JAI_RGM_TRX_RECORDS table is a core transactional repository within the Oracle E-Business Suite Asia/Pacific Localizations module (Product JA). Its primary function is to store detailed records for tax recovery and liability calculations across different tax regimes. This table acts as a central ledger for tracking tax-related financial entries generated from various source transactions within EBS, such as invoices or journal entries. It is integral to the localization's tax engine, ensuring accurate accounting for complex, region-specific tax rules in versions 12.1.1 and 12.2.2.

Key Information Stored

The table's structure is designed to link tax calculations to their originating documents and final accounting settlements. Key columns include the unique REPOSITORY_ID (primary key) and a composite unique key that ensures data integrity by combining identifiers like SOURCE, SOURCE_TRX_TYPE, ORGANIZATION_ID, LOCATION_ID, and TAX_TYPE. Critical transactional columns store the source document's table name (SOURCE_TABLE_NAME) and its unique identifier (SOURCE_DOCUMENT_ID), enabling traceability. Financial accounting is supported through foreign keys to General Ledger code combinations for the CHARGE_ACCOUNT_ID and BALANCING_ACCOUNT_ID. The table also links to processing batches (BATCH_ID) and finalized settlements (SETTLEMENT_ID).

Common Use Cases and Queries

This table is central to tax reporting, reconciliation, and audit processes. A common use case is reconciling tax liabilities for a specific organization and location before period-end closing. Developers or analysts may query it to trace the tax impact of a specific source transaction or to generate detailed tax registers. Sample query patterns include joining to source transaction tables or summarizing liabilities by tax type.

• Trace Tax Lines for an Invoice: SELECT * FROM jai_rgm_trx_records WHERE source_table_name = 'RA_CUSTOMER_TRX_ALL' AND source_document_id = <invoice_id>;
• Summarize Unsettled Liabilities by Tax Type: SELECT tax_type, SUM(tax_amount) FROM jai_rgm_trx_records WHERE settlement_id IS NULL GROUP BY tax_type;

Related Objects

JAI_RGM_TRX_RECORDS has defined relationships with several key EBS tables, forming a critical hub in the tax data model.

• Referenced By This Table (Foreign Keys):
  • JAI_RGM_CONC_REQUESTS via BATCH_ID (links to concurrent processing batches).
  • JAI_RGM_SETTLEMENTS via SETTLEMENT_ID (links to finalized tax settlement records).
  • GL_CODE_COMBINATIONS via CHARGE_ACCOUNT_ID and BALANCING_ACCOUNT_ID (links to accounting flexfields).
  • HR_ALL_ORGANIZATION_UNITS via ORGANIZATION_ID and INV_ORGANIZATION_ID (links to operating unit and inventory organization).
  • HR_LOCATIONS_ALL via LOCATION_ID (links to tax jurisdiction location).
• References This Table (Primary Key):
  • JAI_CMN_JOURNAL_ENTRIES via REPOSITORY_ID (journal entries are created from these tax records).