Search Results jai_cmn_rg_23ac_ii_trxs

Overview

The table JAI_CMN_RG_23AC_II_TRXS is a core data object within the Oracle E-Business Suite Asia/Pacific Localizations module (product code JA). It is specifically designed for legal and financial compliance in jurisdictions, such as India, that require detailed excise duty tracking. The table serves as the "Amount Register," storing the detailed transactional records for RG23A and RG23C registers, Part II. These statutory registers are mandated by excise authorities to account for the payment of excise duty on raw materials and capital goods (RG23A) and finished goods (RG23C). Its role is to maintain a complete, auditable ledger of duty amounts related to procurement, production, and sales, forming the foundation for excise reporting and reconciliation within EBS releases 12.1.1 and 12.2.2.

Key Information Stored

The table's primary purpose is to record excise duty financial transactions linked to specific inventory items, parties, and accounting periods. Its primary key is REGISTER_ID, which uniquely identifies each Part II entry. Critical foreign key columns establish the necessary relationships to other master and transactional data. These include INVENTORY_ITEM_ID and ORGANIZATION_ID to link to inventory items, CUSTOMER_ID and VENDOR_ID to link to trading partners via HZ_PARTIES, and CHARGE_ACCOUNT_ID to link to the applicable general ledger account in GL_CODE_COMBINATIONS. Other significant columns track the financial year (FIN_YEAR), link to a corresponding Part I register entry (REGISTER_ID_PART_I), associate with a period balance (PERIOD_BALANCE_ID), and reference location and site information. The table essentially stores the monetary dimensions of excise transactions.

Common Use Cases and Queries

This table is central to statutory excise reporting and internal audits. Common operational and reporting scenarios include generating the RG23A/C Part II register for a specified financial period, reconciling excise duty paid on inputs with duty payable on outputs, and tracing duty credit availed against specific purchase invoices. A typical query would join this table to item, party, and general ledger tables to produce a comprehensive register extract. For example:

• Register Extract: SELECT ii.REGISTER_ID, hzp.party_name CUSTOMER, msi.segment1 ITEM_CODE, ii.duty_amount, gcc.segment1||'.'||gcc.segment2 ACCOUNT FROM JAI_CMN_RG_23AC_II_TRXS ii, HZ_PARTIES hzp, MTL_SYSTEM_ITEMS_B msi, GL_CODE_COMBINATIONS gcc WHERE ii.CUSTOMER_ID = hzp.party_id AND ii.INVENTORY_ITEM_ID = msi.inventory_item_id AND ii.ORGANIZATION_ID = msi.organization_id AND ii.CHARGE_ACCOUNT_ID = gcc.code_combination_id AND ii.FIN_YEAR = '2023-2024';
• Reconciliation: Data from this table is aggregated and compared with entries in JAI_CMN_RG_23AC_I_TRXS (Part I) and general ledger excise accounts to ensure financial accuracy.
• Audit Support: Provides the detailed audit trail required by excise authorities, linking duty payments to specific transactions, parties, and inventory items.

Related Objects

JAI_CMN_RG_23AC_II_TRXS is a central hub within the excise register schema, with numerous documented foreign key relationships. The primary key (REGISTER_ID) is referenced by tables such as JAI_CMN_RG_COMP_DTLS and JAI_CMN_RG_ROUND_HDRS. Its key foreign key dependencies include:

• JAI_CMN_RG_23AC_I_TRXS: Linked via REGISTER_ID_PART_I and REGISTER_ID_PART_II, establishing the core relationship between Part I and Part II register entries.
• JAI_INV_ITM_SETUPS: Joined on INVENTORY_ITEM_ID and ORGANIZATION_ID for item-specific excise setup data.
• HZ_PARTIES: Joined on CUSTOMER_ID, VENDOR_ID, and CUSTOMER_SITE_ID for supplier and customer information.
• GL_CODE_COMBINATIONS: Joined on CHARGE_ACCOUNT_ID for the general ledger account charged with the duty.
• JAI_CMN_FIN_YEARS, JAI_CMN_RG_PERIOD_BALS, JAI_CMN_RG_ROUND_HDRS: Joined for financial period, balance, and rounding rule context, respectively.
• JAI_PA_DRAFT_INVOICES: References this table via EXCISE_REGISTER_ID, linking draft invoices to excise register entries.