Search Results create_trx_balance




Overview
Explore in AI Chat

Overview

The APPS.JL_CO_GL_NIT_MANAGEMENT package is a Latin American localizations component belonging to the Oracle E-Business Suite (EBS) Global Accounting Engine (subledger) framework, commonly known as JL or the "NIT" (Número de Identificación Tributaria) related management logic used in Colombian and other Latin American legislations. Its principal business function is to construct, calculate, and reverse subledger transaction balances that must be transferred to the General Ledger through the JL_CO_GL_TRX staging table. The package provides the bridge between transactional subledger data (payables, receivables, cash management, and costing write-offs) and the General Accounting Engine's transfer mechanism, ensuring that each accounting event is recorded with a proper code combination, period name, journal entry identifiers, and reversal linkage.

The header comment ($Header: jlcoglbs.pls 120.4.12010000.1 2008/07/31) indicates the source file has been stable since the 12.1.x code line and is shipped in both 12.1.1 and 12.2.2 environments under the APPS schema, classified as API usage type OTHER.

Key Procedures and Functions

The package exposes three documented procedures that together form the transaction-balance lifecycle:

  • CREATE_TRX_BALANCE — The main entry point that creates balance rows in the JL_CO_GL_TRX staging table. It accepts a process type, set of books identifier, accounting period, a reconciliation/record identifier, and a batch identifier, together with standard EBS concurrent program OUT parameters (errbuf, retcode). This signature confirms the procedure is designed to be invoked as the executable of a concurrent program.
  • CALCULATE_BALANCE — Computes the aggregate accounting balance for a given code combination (p_cid), set of books, and user context. This procedure is responsible for summing debits and credits from the underlying subledger sources before the balance is written or validated.
  • REVERSE_BALANCE — Produces the reversing entries required when a previously transferred or calculated balance must be backed out. It uses a local PL/SQL record type (reverse_rec_type) and an associative array collection (reverse_rec_tbl) to capture the original journal entry header, line number, accounting date, currency, and the reversal header reference, enabling precise linkage between original and reversed GL entries.

Tables Accessed

The package reads and writes the staging table JL_CO_GL_TRX, which holds the transaction lines destined for General Ledger transfer. To populate and validate these rows it draws on a broad set of EBS subledger tables accessed through APPS synonyms, including Payables (AP_BANK_ACCOUNTS_ALL, AP_BANK_BRANCHES, AP_CHECKS_ALL, AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS_ALL, AP_INVOICE_LINES_ALL, AP_PAYMENT_HISTORY_ALL, AP_PREPAY_APP_DISTS, AP_SUPPLIERS), Receivables (AR_CASH_RECEIPTS_ALL), Cash Management (CE_BANK_ACCOUNTS, CE_BANK_ACCT_USES_ALL), and Costing (CST_WRITE_OFFS). FND_NEW_MESSAGES provides Oracle Application Object Library message text for error reporting in the concurrent program context. No other packages are documented as calling this package.

Usage Notes

Because CREATE_TRX_BALANCE declares errbuf and retcode output parameters, it is typically registered as the PL/SQL executable of a concurrent program within the Latin American localizations responsibility, scheduled during period close or GL transfer processing. CALCULATE_BALANCE and REVERSE_BALANCE are normally invoked internally by that driver or directly from custom code when a targeted adjustment or reversal is required. In 12.1.1 and 12.2.2 the package remains an APPS-owned, non-public-API object; extensions should treat it as a dependent component of the JL subledger-to-GL flow rather than a supported integration point, and should not reference the reverse_rec_tbl package-level global directly.