Search Results p_to_period_name

Overview

FV_GTAS_GL_PKG is a PL/SQL package owned by the APPS schema in Oracle E-Business Suite, documented in ETRM for release 12.2.2 and present in 12.1.1. Its name associates it with the Federal Financials product family (FV) and specifically with GTAS — the Governmentwide Treasury Account Symbol Adjusted Trial Balance System, the U.S. Treasury reporting mechanism through which federal agencies submit budgetary and proprietary trial balance data. The package supports the extraction and aggregation of general ledger and subledger activity required to produce GTAS submissions, mapping EBS accounting data into the Treasury Account Symbol and fund balance structures mandated by Treasury reporting rules.

The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the definer. Its specification contains a single public procedure, MAIN, which serves as the primary entry point for the GTAS processing cycle. The header comment indicates a last revision dated 2012, consistent with ongoing federal reporting maintenance across the 12.1.1 and 12.2.2 code lines.

Key Procedures and Functions

The package exposes one documented procedure:

• MAIN — The controlling routine for the GTAS general ledger process. It accepts an error buffer and error code as standard OUT parameters for diagnostic reporting, a set of book identifier and a target period name that scope the run to a specific ledger and accounting period, and a flag controlling whether activity balances are recreated. When the recreate flag is set to 'N', the procedure reuses existing balances; when set to 'Y', it rebuilds activity balances before extraction. MAIN orchestrates the reading of transaction and accounting data, validation against the Governmentwide Treasury Account Symbol attributes, and the preparation of the balances used for GTAS reporting.

The documented metadata lists no functions and no other public or private procedures. No parameter lists beyond those shown in the specification are asserted.

Tables Accessed

Although the package body is not reproduced in full, the documented referenced tables fall into three groups:

• Federal Financials setup and transaction tables — FV_BE_TRX_HDRS, FV_BE_TRX_DTLS, FV_BE_TRANSACTION_TYPES, FV_BE_TRX_SUB_TYPES, FV_BUDGET_LEVELS. These hold the budgetary execution transactions, transaction type and subtype hierarchies, and budget level definitions that determine how activity is classified for Treasury reporting.
• Payables and Receivables subledger sources — AP_CHECKS_ALL, AP_INVOICES_ALL, AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_HIST_DISTS, AP_SUPPLIERS, AR_CASH_RECEIPTS_ALL. The procedure reads disbursement, invoice, payment distribution, supplier, and cash receipt data to derive proprietary and budgetary activity that flows into the reported balances.
• Flexfield and foundation tables — FND_FLEX_VALUES, FND_ID_FLEX_SEGMENTS, FND_APPLICATION, FND_LANGUAGES. These provide the key flexfield structure and segment values, including the Treasury Account Symbol components, plus application registration and language context needed for validation and lookups.

Usage Notes

Because MAIN is the sole documented entry point, the package is normally invoked from within the Federal Financials GTAS reporting flow — either from a concurrent program, from submission logic in the FV module, or from custom PL/SQL that explicitly calls FV_GTAS_GL_PKG.MAIN with the ledger, period, and recreate-activity flag. Callers must supply the OUT error buffer and code and check them on return. No other packaged objects reference this package according to the documented metadata, so dependencies flow inward to the AP, AR, FND, and FV tables rather than outward to other custom packages.