Results for “dr_invoice_date”

44 results




AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

JAI_CMN_RG_PLA_TRXS is a transaction register table owned by the JA schema within the Oracle E-Business Suite Asia/Pacific Localizations product (JA). In Oracle EBS 12.1.1 and 12.2.2 it stores the transaction information of the PLA (Price List Adjustment / excise-related register used in Indian localization scope) Register. Each row captures a register entry recording opening and closing balances, credit and debit components of excise duty, and associated document, vendor, item, bank, and accounting references.

Under a heuristic Data Vault classification derived from the foreign-key structure, this table leans toward a satellite. The primary key JAI_CMN_RG_PLA_TRXS_PK on REGISTER_ID acts as a surrogate key, and the many outbound foreign keys to reference and master data (items, parties, locations, GL accounts) suggest it functions primarily as a descriptive transactional record linked to core EBS master entities rather than acting as a hub or link itself.

Key Information Stored

The table contains 69 documented columns. The most significant are:

Common Use Cases and Queries

Typical usage covers excise/PLA register reporting, duty balance reconciliation, and posting control. A representative query retrieves register transactions for an organization and financial year:

  • SELECT register_id, financial_year, slno, transaction_date, opening_balance, closing_balance, posted_flag FROM ja.jai_cmn_rg_pla_trxs WHERE organization_id = :org AND fin_year = :year ORDER BY slno;
  • Balance reconciliation joins the item and party masters to validate closing balances and duty splits.
  • Unposted transaction extraction: WHERE posted_flag = 'N' to identify entries pending posting.
  • Excise document tracing by TR6_CHALLAN_NO or EXCISE_INVOICE_NO for statutory audit trails.
  • Duty accounting analysis mapping CHARGE_ACCOUNT_ID to GL_CODE_COMBINATIONS for account-level summaries.

Related Objects

The table maintains significant relationships with the following objects: