Search Results jai_cmn_rg_i_trxs_pk




Overview
Explore in AI Chat

Overview

The JAI_CMN_RG_I_TRXS table is a core data repository within the Oracle E-Business Suite Asia/Pacific Localizations module (product code JA). Its primary function is to store transactional information required for generating the RG 1 Register, a statutory quantity register mandated by specific tax regulations in certain Asia/Pacific jurisdictions, notably India. This table acts as the system of record for tracking inventory item quantities as they relate to tax reporting, capturing details necessary for compliance with local excise or goods and services tax laws. Its role is integral to the localized legal and financial reporting processes within supported EBS deployments.

Key Information Stored

The table is structured to uniquely identify and quantify inventory transactions per financial period and organizational entity. The primary key (JAI_CMN_RG_I_TRXS_PK) is the system-generated REGISTER_ID. A unique key (JAI_CMN_RG_I_TRXS_UK1) enforces business rule integrity across a combination of ORGANIZATION_ID, LOCATION_ID, FIN_YEAR, INVENTORY_ITEM_ID, and SLNO (serial number). Key columns include ORGANIZATION_ID and LOCATION_ID for entity and place of business context, FIN_YEAR for the applicable financial year, and INVENTORY_ITEM_ID to identify the specific stock-keeping unit. The table also holds identifiers for trading partners (VENDOR_ID, CUSTOMER_ID and their respective site IDs) and the CHARGE_ACCOUNT_ID, which links to a GL_CODE_COMBINATIONS record for the associated accounting charge.

Common Use Cases and Queries

The primary use case is the generation of the statutory RG 1 Register report, which summarizes quantity-based inventory movements for a given period and location for tax authority review. Common queries involve extracting data for audit trails, reconciling physical inventory with book inventory for tax purposes, and analyzing item-level transaction patterns. A typical reporting query would join to inventory and party tables to present a readable register.

  • Sample Query for Register Data:
    SELECT rg.trx_date,
    rg.quantity,
    item.segment1 item_code,
    hp.party_name vendor_name
    FROM ja.jai_cmn_rg_i_trxs rg,
    mtl_system_items_b item,
    hz_parties hp
    WHERE rg.inventory_item_id = item.inventory_item_id
    AND rg.organization_id = item.organization_id
    AND rg.vendor_id = hp.party_id(+)
    AND rg.organization_id = :p_org_id
    AND rg.fin_year = :p_fin_year;

Related Objects

JAI_CMN_RG_I_TRXS maintains significant relational integrity through foreign key constraints to fundamental EBS tables. Key dependencies include JAI_INV_ITM_SETUPS for localized inventory item setups and JAI_CMN_FIN_YEARS for valid financial year definitions. It links to GL_CODE_COMBINATIONS for the general ledger account and to HR_LOCATIONS_ALL for the physical business location. Relationships with HZ_PARTIES and HZ_PARTY_SITES connect the register entries to the Trading Community Architecture for comprehensive vendor and customer data. This table is also likely referenced by various JA localization packages and forms that process RG 1 data and generate compliance reports.

  • INDEX: JA.JAI_CMN_RG_I_TRXS_PK 12.2.2

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

  • INDEX: JA.JAI_CMN_RG_I_TRXS_PK 12.1.1

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

  • Table: JAI_CMN_RG_I_TRXS 12.1.1

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_CMN_RG_I_TRXS,  object_name:JAI_CMN_RG_I_TRXS,  status:VALID,  product: JA - Asia/Pacific Localizations ,  description: Stores Information required for RG 1 Register. It is a Quantity Register. ,  implementation_dba_data: JA.JAI_CMN_RG_I_TRXS , 

  • Table: JAI_CMN_RG_I_TRXS 12.2.2

    owner:JA,  object_type:TABLE,  fnd_design_data:JA.JAI_CMN_RG_I_TRXS,  object_name:JAI_CMN_RG_I_TRXS,  status:VALID,  product: JA - Asia/Pacific Localizations ,  description: Stores Information required for RG 1 Register. It is a Quantity Register. ,  implementation_dba_data: JA.JAI_CMN_RG_I_TRXS , 

  • 12.1.1 DBA Data 12.1.1

  • 12.2.2 DBA Data 12.2.2

  • TABLE: JA.JAI_CMN_RG_I_TRXS 12.2.2

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

  • TABLE: JA.JAI_CMN_RG_I_TRXS 12.1.1

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

  • 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. ,