Search Results process_parameters




Overview
Explore in AI Chat

Overview

FV_FACTS_GL_PKG_EXT is a PL/SQL extension package body owned by APPS within the Oracle E-Business Suite Federal Financials (FV) product family. In the 12.1.1 and 12.2.2 releases it forms part of the FACTS (Federal Accounting Compliance and Treasury System) integration layer that reconciles Federal subledger activity against the General Ledger. The package supports the posting and summarization of FACTS line balances into GL period and run contexts, and it exposes an extensible entry point that Oracle Development or implementing partners can use to tailor Federal FACTS processing without modifying the seeded, non-extensible package logic. The "_EXT" suffix indicates this is a deliberately extensible body, allowing customer-specific hooks to be layered on top of standard processing.

The header comment notes a revision history dating back to 2007, and the package continues to ship in the current 12.2.2 file system with the same structure. Its API classification in the ETRM metadata is "OTHER", reflecting that it is internal plumbing rather than a published open interface.

Key Procedures and Functions

The documented package exposes a single named program unit, MAIN. In the context of the excerpted source, the body also declares helper routines such as initialize_global_variables, which seeds package-level globals for module name, request ID, user ID, login ID, and concurrent program ID from FND_GLOBAL. A get_fed_system_parameters routine is described in comments as retrieving Federal system parameters by vendor and customer attribute. These supporting routines feed data into the MAIN driver, which represents the package's principal execution path. Because the ETRM metadata documents only MAIN at the API level, integrators should treat MAIN as the sanctioned invocation point and consider the remaining procedures as internal implementation.

Tables Accessed

The package reads and writes the following objects through APPS synonyms:

  • FND_CONCURRENT_PROGRAMS — resolves the concurrent program name and ID associated with the current request.
  • FV_FACTS1_RUN — holds FACTS run header information that drives the reconciliation cycle.
  • FV_FACTS1_LINE_BALANCES — the core FACTS line balance store that is summarized and pushed toward GL.
  • FV_SYSTEM_PARAMETERS — Federal system parameter values that govern processing behavior.
  • GL_PERIOD_STATUSES — validates accounting period open/closed status before posting or summarization.
  • DBMS_SQL — used for dynamic SQL construction, supporting flexible query generation.

Usage Notes

In practice, FV_FACTS_GL_PKG_EXT is invoked from concurrent programs within the Federal FACTS request set rather than from a user-facing form. It is not referenced by other packages, so the calling surface is entirely concurrent-program driven. This matters for the search term "process_parameters": parameter handling in this package centers on initialize_global_variables, which captures FND_GLOBAL context (request ID, user ID, login ID, concurrent program ID) at entry. Implementers extending this package should expect parameters to be supplied through the concurrent program definition and read via FND_GLOBAL or FV_SYSTEM_PARAMETERS rather than passed directly as formal arguments to MAIN. Because the body is extensible, custom logic should be added to the _EXT package rather than patched into the base FACTS GL package, preserving Oracle support for future 12.1.1 and 12.2.2 patch levels.