Search Results gl_rx_trial_balance_pkg




Overview
Explore in AI Chat

Overview

APPS.GL_RX_TRIAL_BALANCE_PKG is a General Ledger utility package that supports the global consolidation and trial balance extraction process in Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its primary purpose is to build the rows of a trial balance extract that reconciles General Ledger account balances for a given ledger, period, and chart of accounts structure. This functionality is central to regulatory reporting and to the Global Consolidation System workflow, where subsidiary and parent ledgers must be mapped and balanced before consolidation and elimination entries can be processed.

The package is classified as an OTHER API under ETRM, meaning it is not part of the supported public API surface for external integration. It is an internal implementation object invoked by the trial balance concurrent program and related consolidation routines. Its status is VALID in the APPS schema, with dependencies on SYS.STANDARD and the standard PL/SQL runtime.

Key Procedures and Functions

The package exposes a single documented procedure:

  • CREATE_ROWS — Populates the trial balance interface table (GL_RX_TRIAL_BALANCE_ITF) with the account and balance rows required for extraction. It resolves the active chart of accounts and segment structure, validates the ledger and accounting period, and derives code combination balances to materialize the trial balance output set.

Parameter lists are not documented in the ETRM metadata and are intentionally omitted here. Invocation is expected to occur from the parent concurrent program flow rather than directly.

Tables Accessed

The package reads setup, ledger, period, and account combination data, and writes to the trial balance interface table:

  • FND_APPLICATION — Resolves the application context and ownership of the ledger and reporting entities.
  • FND_CONCURRENT_REQUESTS — Reads concurrent request information to tie the extraction to the running trial balance program instance.
  • FND_ID_FLEXS, FND_ID_FLEX_SEGMENTS, FND_ID_FLEX_SEGMENTS_TL — Provide the key flexfield definition and segment structure used to format the trial balance columns.
  • FND_FLEX_VALUE_SETS, FND_FLEX_VALUES_TL — Supply validated segment values and their translated descriptions for reporting.
  • GL_LEDGERS — Identifies the ledger, chart of accounts, currency, and accounting calendar configuration.
  • GL_PERIOD_STATUSES — Determines period open/close status and the periods eligible for extraction.
  • GL_CODE_COMBINATIONS — Supplies the account combinations that form the trial balance rows.
  • GL_RX_TRIAL_BALANCE_ITF — The interface/output table populated by CREATE_ROWS, subsequently consumed by downstream consolidation programs.
  • DBMS_SQL — Utilized for dynamic SQL construction, enabling flexible account balance queries against the appropriate GL balance tables.

Usage Notes

GL_RX_TRIAL_BALANCE_PKG is not intended for direct invocation from forms or external code. It is invoked internally as part of the trial balance extraction and global consolidation concurrent programs within General Ledger. Because ETRM documents no referencing packages and no public API classification, customizations should avoid calling CREATE_ROWS directly; instead, the standard concurrent program should be submitted, and any customization should operate on GL_RX_TRIAL_BALANCE_ITF after population. The dependency on DBMS_SQL indicates dynamic query generation, so performance is sensitive to the volume of code combinations in the ledger and the number of periods selected. In 12.2.2, the package continues to function against the same ETRM-documented objects; upgrades from 12.1.1 preserve the interface table contract, though administrators should re-validate the package after patching to confirm VALID status in the APPS schema.