Search Results fv_sf133_oneyear




Overview
Explore in AI Chat

Overview

The APPS.FV_SF133_ONEYEAR package is a PL/SQL reporting utility within the Oracle E-Business Suite Treasury (ETRM) module. Its name reflects its purpose: generating the Standard Form 133 (SF-133), the "Report on Budget Execution and Budgetary Resources" used by U.S. federal agencies, for a one-year reporting basis. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user and resolves unqualified object references through that schema rather than through the package owner. This is significant because the package relies on APPS synonyms to reach underlying Treasury and General Ledger objects.

The package exposes a single public entry point, MAIN, and a public variable, sf133_runmode, which is initialized to the default value 'NO'. The header timestamp (120.3.12010000.2, last modified 2009) places it within the standard 12.1.1 code line, and it remains available in 12.2.2 as a documented ETRM object with an API classification of OTHER. The user query referencing a one-year review or decision period aligns with the one-year reporting scope this package embodies.

Key Procedures and Functions

  • MAIN — The sole documented procedure. It is the procedural driver that executes the SF-133 one-year report generation. It accepts an inbound run_mode selector, a ledger (set_of_books_id), the GL accounting period year and period name, and two Treasury symbol parameters (treasury_symbol_r1 and treasury_symbol_r2) that scope the reporting lines to specific Treasury Account Symbols. It also returns the standard concurrent-program OUT parameters errbuf and retcode, confirming it is designed to run as a concurrent program. No additional procedures or functions are documented; all business logic is contained within this single entry point.
  • sf133_runmode — A package-level VARCHAR2 variable defaulting to 'NO'. It governs the operational mode of the report run and is referenced internally by MAIN.

Tables Accessed

The package reads and writes the following documented objects via APPS synonyms:

Usage Notes

Because MAIN returns errbuf and retcode, FV_SF133_ONEYEAR is intended to be registered and invoked as an Oracle EBS concurrent program, typically scheduled for period-end or fiscal-year-end federal budget execution reporting. The caller supplies the ledger, period, and Treasury symbols as concurrent program parameters. The metadata records that the package is referenced by one other package, indicating it participates in a larger Treasury reporting chain. The AUTHID CURRENT_USER declaration permits invocation under a calling schema's privileges, which is relevant when custom code wraps the procedure. The one-year designation distinguishes it from longer-horizon SF-133 variants; the "one-year" scope corresponds directly to the query context concerning a one-year review or decision period following reconsideration.