Search Results fv_funds_avail_pkg




Overview
Explore in AI Chat

Overview

FV_FUNDS_AVAIL_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the Funds Availability feature set within Oracle Public Sector / Federal Financials. The package is documented in ETRM 12.2.2 with an API classification of OTHER, meaning it is not a published, supported open interface but an internal program unit that drives the Funds Availability reporting and inquiry process. Its principal entry point, Main, is a concurrent-program style driver: it accepts an error buffer and return code along with a set of report parameters, then orchestrates the work required to determine and report available funds balances across a chart of accounts.

The core business purpose is to compare budgetary resources against expenditures and commitments so that agencies can confirm funds availability before executing transactions. The package resolves the accounting flexfield structure, identifies the qualifier and balancing segments, gathers the relevant account ranges and period statuses, and produces the output that underlies the Funds Availability report.

Key Procedures and Functions

  • Main — The primary driver procedure invoked by the concurrent program. It receives the set of books, chart of accounts, summary type, report definition, Treasury symbol, flexfield low/high ranges, period name, currency, and units, and controls the overall execution flow.
  • Get_Qualifier_Segments — Identifies the qualifier segments of the accounting flexfield that participate in the funds availability calculation.
  • Get_Application_Col_Names — Resolves the column names used by the application when building the report output.
  • Get_Segment_Values — Retrieves the segment values for a supplied segment count, populating the working set used downstream.
  • Populate_CCIDs — Builds the concatenated accounting flexfield identifier (CCID) values from caller-supplied select_cl and where_cl fragments. This is the procedure most commonly targeted by developers searching for "populate_ccids," because it is the mechanism by which the package materializes valid account combinations for the funds availability query.
  • Treasury_Symbol_attributes — Loads attributes associated with the Treasury Symbol that governs the reporting entity.
  • Get_Bfy_Segment — Derives the budget fiscal year segment used to align balances to the correct fiscal period.
  • Submit_Reports — Submits the associated reports once the data set has been assembled.
  • Create_Transactions — Creates transaction records from concatenated segments, fund value, report and column identifiers, amount, and set of books.

Tables Accessed

The package reads and writes through APPS synonyms. Flexfield metadata is drawn from FND_ID_FLEX_STRUCTURES, FND_ID_FLEX_SEGMENTS, and FND_FLEX_VALUES. Report and parameter configuration come from FV_FUNDS_AVAIL_REP_DEF, FV_FUNDS_AVAIL_ACCT_RANGES, FV_FUND_PARAMETERS, FV_TREASURY_SYMBOLS, and FV_PYA_FISCALYEAR_SEGMENT. Working data is staged in FV_FUNDS_AVAIL_TEMP, while GL_PERIOD_STATUSES supplies period open/close state and FND_CURRENCIES supplies currency attributes. PLITBLM is a standard Oracle interleaved array/table type used for bulk processing.

Usage Notes

In 12.1.1 and 12.2.2 this package is normally invoked indirectly — through the Funds Availability concurrent program, related forms, or internal callers — rather than by direct customer callouts. Because it is classified OTHER and is not designated a public API, custom code should avoid calling it directly; the internal procedures may change between releases. Developers investigating "populate_ccids" typically do so to understand how CCIDs are constructed for funds availability queries, but any reuse should be treated as unsupported and validated after patching or upgrade.