Search Results jai_rgm_trx_refs_uk1




Overview
Explore in AI Chat

Overview

The JAI_RGM_TRX_REFS table is a core data repository within the JA (Asia/Pacific Localizations) product of Oracle E-Business Suite, specifically for versions 12.1.1 and 12.2.2. Its primary role is to store detailed tax information related to service tax for both Accounts Payable (AP) and Accounts Receivable (AR) invoices. This table is essential for the Regional Government Module (RGM), which manages complex tax compliance and reporting requirements for specific Asia/Pacific jurisdictions. It acts as a central reference point, linking transactional invoice data with associated tax calculations, party information, and processing batches.

Key Information Stored

The table's structure is defined by its primary and unique keys, which enforce data integrity for tax reference tracking. The primary key, REFERENCE_ID, uniquely identifies each tax reference record. A critical unique key (JAI_RGM_TRX_REFS_UK1) ensures data consistency across the SOURCE, INVOICE_ID, and LINE_ID columns, which together identify the specific invoice line from AP or AR that the tax data pertains to. Other significant columns include BATCH_ID, which links to concurrent processing batches; TAX_ID for the specific tax rate or rule; PARTY_ID and PARTY_SITE_ID for customer or supplier details; and ORGANIZATION_ID for the operating unit. The PARENT_REFERENCE_ID column supports hierarchical relationships between tax records, such as adjustments or corrections.

Common Use Cases and Queries

This table is primarily accessed for service tax reporting, reconciliation, and audit purposes. A common scenario involves generating a tax register for a specific period and organization. A typical query would join JAI_RGM_TRX_REFS to transactional and master data tables to produce a comprehensive report.

  • Tax Liability Report by Party: Query to summarize tax amounts by customer or supplier within a date range, joining to HZ_PARTIES and RA_CUSTOMER_TRX_ALL or AP_INVOICES_ALL.
  • Batch Reconciliation: SQL to verify all tax records processed in a specific concurrent request batch by filtering on BATCH_ID and joining to JAI_RGM_CONC_REQUESTS.
  • Detailed Invoice Tax Audit: A drill-down query linking an invoice line's tax details (from JAI_RGM_TRX_REFS) to the applied tax rate definition in JAI_CMN_TAXES_ALL for validation.

Related Objects

The table maintains defined foreign key relationships with several core EBS objects, as documented in the ETRM metadata. These relationships are critical for data integrity and join conditions in queries.

  • JAI_RGM_CONC_REQUESTS: Linked via BATCH_ID. This relationship tracks the concurrent process that created or modified the tax records.
  • HZ_PARTIES: Linked via PARTY_ID. Provides the customer or supplier master information.
  • HZ_PARTY_SITES: Linked via PARTY_SITE_ID. Provides the specific site or location of the trading party.
  • JAI_CMN_TAXES_ALL: Linked via TAX_ID. References the master definition of the tax rate or rule applied.
  • HR_ALL_ORGANIZATION_UNITS: Linked via ORGANIZATION_ID. Identifies the operating unit for the transaction.
  • Self-Referential Relationship: The PARENT_REFERENCE_ID column references the table's own REFERENCE_ID, creating a hierarchy for amended or linked tax records.
  • INDEX: JA.JAI_RGM_TRX_REFS_UK1 12.2.2

    owner:JA,  object_type:INDEX,  object_name:JAI_RGM_TRX_REFS_UK1,  status:VALID, 

  • Table: JAI_RGM_TRX_REFS 12.1.1

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_RGM_TRX_REFS,  object_name:JAI_RGM_TRX_REFS,  status:VALID,  product: JA - Asia/Pacific Localizations ,  description: Stores the tax information of AP and AR invoices for Service Tax ,  implementation_dba_data: JA.JAI_RGM_TRX_REFS , 

  • INDEX: JA.JAI_RGM_TRX_REFS_UK1 12.1.1

    owner:JA,  object_type:INDEX,  object_name:JAI_RGM_TRX_REFS_UK1,  status:VALID, 

  • Table: JAI_RGM_TRX_REFS 12.2.2

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_RGM_TRX_REFS,  object_name:JAI_RGM_TRX_REFS,  status:VALID,  product: JA - Asia/Pacific Localizations ,  description: Stores the tax information of AP and AR invoices for Service Tax ,  implementation_dba_data: JA.JAI_RGM_TRX_REFS , 

  • 12.1.1 DBA Data 12.1.1

  • TABLE: JA.JAI_RGM_TRX_REFS 12.2.2

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_RGM_TRX_REFS,  object_name:JAI_RGM_TRX_REFS,  status:VALID, 

  • TABLE: JA.JAI_RGM_TRX_REFS 12.1.1

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_RGM_TRX_REFS,  object_name:JAI_RGM_TRX_REFS,  status:VALID, 

  • 12.2.2 DBA Data 12.2.2

  • eTRM - JA Tables and Views 12.1.1

    description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. , 

  • eTRM - JA Tables and Views 12.2.2

    description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. , 

  • eTRM - JA Tables and Views 12.1.1

    description: The 'JA_CN_SYSTEM_PARAMETERS_ALL' table stores information defined by 'System Options' form, 'Electronic Accounting Book Export' program will get most data from data in the table. A legal entity can only have one record in the table. , 

  • eTRM - JA Tables and Views 12.2.2

    description: The 'JA_CN_VOUCHER_NUMBER' table stores the voucher number of GL journal lines. ,