Search Results jai_cmn_rg_23ac_i_trxs

Overview

The table JAI_CMN_RG_23AC_I_TRXS is a core data repository within the Asia/Pacific Localizations (JA) module of Oracle E-Business Suite (EBS) versions 12.1.1 and 12.2.2. It is specifically designed to manage RG23A and RG23C records, which are statutory quantity registers mandated by Indian excise law. This table, often referred to as the Quantity Register, tracks the movement of excisable goods for manufacturing (RG23A) and trading (RG23C) activities. Its primary role is to maintain a detailed audit trail of inventory receipts, issues, and balances for excise purposes, ensuring compliance with regulatory reporting requirements.

Key Information Stored

The table's structure is defined by its primary and foreign keys, which link it to major transactional and master data entities in EBS. The primary key is REGISTER_ID, uniquely identifying each quantity register transaction record. Critical foreign key relationships define the data's scope. These include links to inventory items and organizations (JAI_INV_ITM_SETUPS), suppliers and customers (HZ_PARTIES, HZ_PARTY_SITES), purchase order details (PO_HEADERS_ALL, PO_LINES_ALL), financial accounts (GL_CODE_COMBINATIONS), and the financial year (JAI_CMN_FIN_YEARS). A significant structural link is to the companion table JAI_CMN_RG_23AC_II_TRXS via REGISTER_ID_PART_II, indicating a partitioned design where Part I likely holds core transactional data.

Common Use Cases and Queries

This table is central to excise compliance reporting and reconciliation. Common operational and reporting scenarios include generating statutory RG23 register reports for audit, reconciling book inventory with excise-registered quantities, and tracking duty credit availability. Key queries often involve joining with related tables to present a complete view. For example, to analyze quantity movements for a specific item and financial year, a query would join with inventory and financial year tables. Another critical pattern is tracing a purchase order's excise quantity registration by joining with PO tables and supplier data. Troubleshooting often involves queries to find unlinked or orphaned records by checking the integrity of its numerous foreign key relationships.

Related Objects

JAI_CMN_RG_23AC_I_TRXS is a hub within a network of localization objects. Its most direct relationship is with the Part II table, JAI_CMN_RG_23AC_II_TRXS, with which it shares a bidirectional foreign key. It is heavily dependent on core EBS modules for master data: Inventory (JAI_INV_ITM_SETUPS), Purchasing (PO_HEADERS_ALL, PO_LINES_ALL, PO_LINE_LOCATIONS_ALL), General Ledger (GL_CODE_COMBINATIONS), and Trading Community Architecture (HZ_PARTIES, HZ_PARTY_SITES). It also references the localization table for financial year maintenance (JAI_CMN_FIN_YEARS). This extensive integration underscores its role in bridging localized excise logic with standard EBS transaction flows.