Search Results cleanup_process

Overview

FV_GTAS_TBAL_TRX_PKG is an Oracle EBS Federal Financials package body owned by APPS and classified under ETRM as OTHER (not a public API). It supports the Governmentwide Treasury Account Symbol (GTAS) Trial Balance reporting process, which is a mandatory U.S. federal treasury reporting requirement executed through Oracle Federal Financials. The package consolidates General Ledger balances and derives the reporting attributes required to map a ledger's chart of accounts to a Treasury Account Symbol (TAS) and produce a trial balance extract in the FV_GTAS1_REPORT_T2 staging structure.

The body declares package-level globals that reveal its operating context: the set of books (ledger) identifier, period name, chart of accounts identifier, fiscal year, low and high period numbers, balancing and accounting segment names, accounting value set identifier, and several dynamically constructed SQL clause fragments (accounting identifier flex clause, main account clause, segments WHERE clause, and TAS clause). These globals are populated once per run and reused by the internal procedures, reflecting a batch, single-run design rather than a stateless API. An internal error-handling log buffer (gbl_error_code, gbl_error_buf) and a LOG utility are also declared, consistent with a concurrent-program execution model where diagnostics are written to a log rather than raised to an interactive caller.

Key Procedures and Functions

• TRIAL_BALANCE_MAIN — The principal driver routine. It orchestrates the trial balance build, opening the reporting period context, resolving segment configuration, executing the balance and TAS rollup logic, and staging the results. Because it is the entry point associated with the user's search term, it is the procedure most likely referenced by the concurrent program definition or report trigger.
• BUILD_SEGS_WHERE_CLAUSE — Constructs the dynamic SQL WHERE fragments used to filter code combinations. It resolves the balancing and accounting segment names for the ledger's chart of accounts and assembles the segment predicates (including the TAS and main account clauses) that downstream queries apply against GL_CODE_COMBINATIONS.
• BEFOREREPORT — A report-level initialization procedure, typically invoked by the Oracle Reports trigger of the same name. It establishes the session context (ledger, period, chart of accounts, fiscal year) and prepares the package globals prior to the main trial balance processing.

Internal helper procedures documented in the source excerpt include GET_SEGMENT_NAMES (identifies the balancing and accounting segments from flexfield metadata and raises invalid_bal_segment / invalid_acc_segment exceptions when they cannot be determined), LOG, CLEANUP_PROCESS, and ROLLUP_PROCESS (annotated in the source as added for the trial balance report).

Tables Accessed

• GL_LEDGERS / GL_SETS_OF_BOOKS — Resolves the ledger identifier and chart of accounts identifier that anchor all subsequent processing.
• GL_PERIOD_STATUSES — Supplies the period name, period number, and fiscal year used to scope the balance inquiry and to derive the low and high period ranges.
• GL_BALANCES — The primary source of beginning and ending account balances aggregated into the trial balance.
• GL_CODE_COMBINATIONS — Provides account combinations evaluated against the dynamically built segment WHERE clause.
• FND_ID_FLEX_SEGMENTS / FND_ID_FLEX_STRUCTURES — Key flexfield metadata used by GET_SEGMENT_NAMES to identify the balancing and accounting segment qualifiers and the associated value set.
• FV_GTAS1_REPORT_T2 — The GTAS trial balance staging/report table populated with the derived Treasury Account Symbol results.
• FV_TREASURY_SYMBOLS — Treasury symbol reference data used to map and validate the TAS values assigned to each account.

Usage Notes

FV_GTAS_TBAL_TRX_PKG is invoked in the context of the GTAS Trial Balance report or concurrent program in Oracle Federal Financials, not from a standard EBS data-entry form. BEFOREREPORT is designed to be called from the Oracle Reports BeforeReport trigger, which sets the ledger and period parameters before TRIAL_BALANCE_MAIN performs the extraction. The presence of package globals and a LOG routine indicates that the package is intended for a single sequential execution per concurrent request; concurrent invocations against the same session state should be avoided. The package is referenced by one other package in the ETRM metadata, so modifications to its signature or global state may affect dependent objects. Because the object is classified as OTHER and carries a private header, its procedures should not be treated as supported APIs for custom development; customizations should instead consume FV_GTAS1_REPORT_T2 or the delivered concurrent program output.