Search Results fvfcchkb_pkg




Overview
Explore in AI Chat

Overview

FVFCCHKB_PKG is an Oracle E-Business Suite package owned by the APPS schema that supports the edit-checking framework of the Treasury FV (Federal Financials / FACTS) module. Its role is to execute validation, or "edit check," routines against data collected for a given treasury symbol and reporting period, ensuring that submissions comply with the reporting rules defined for that treasury symbol before they are processed further. The package is defined with AUTHID CURRENT_USER, meaning its SQL statements execute under the privileges of the invoking user rather than the definer, a characteristic typical of utility packages invoked from concurrent programs or higher-level processing logic. The single documented entry point, PERFORM_EDIT_CHECKS, accepts a treasury symbol identifier, a facts-run quarter identifier, and a reporting fiscal year, which together select the scope of data to be validated. The package belongs to the FV product family, which handles FACTS (Financial Application and Compliance Tracking System) data used for federal treasury reporting, and its naming — "CHKB" suggesting a check-based variant — indicates it is one of a family of edit-check processing packages.

Key Procedures and Functions

The package exposes one documented procedure, PERFORM_EDIT_CHECKS. This procedure performs the edit-check processing for a specified combination of treasury symbol, facts-run quarter, and reporting fiscal year. Its parameters are an error buffer and return code, both required by the Oracle concurrent program execution convention, followed by the treasury symbol ID, the facts-run quarter, and the reporting fiscal year, which together scope the edit checks to a specific reporting context. The procedure writes its status results into the edit-check status tables and returns success or failure through the standard retcode channel. No other procedures or functions are documented in the ETRM metadata for this package.

Tables Accessed

The package reads and writes several tables through APPS synonyms. FV_TREASURY_SYMBOLS and FV_FACTS_SUBMISSION provide the treasury symbol and submission context that define the scope of the edit run. FV_FACTS_TEMP holds the staged FACTS data being validated. FV_FACTS_EDIT_CHECK_STATUS receives the outcome of each edit check, while FV_FACTS_AUTHORIZATIONS supplies authorization information relevant to the checks. FV_FACTS_RT7_ACCOUNTS and FV_FACTS_RT7_CODES support the Report Type 7 (RT7) account and code validation logic, and FV_FACTS_USSGL_ACCOUNTS supports USSGL account validation. DUAL is referenced for scalar evaluations. Collectively these tables supply both the data under test and the rule and status repositories that record validation results.

Usage Notes

PERFORM_EDIT_CHECKS is typically invoked as a concurrent program from the FV module, where its error buffer and return code parameters match the standard concurrent program signature. It may also be called from forms or from custom PL/SQL code that needs to trigger edit checks programmatically for a specific treasury symbol, quarter, and fiscal year. Because the package uses AUTHID CURRENT_USER, callers must have appropriate privileges on the underlying FV tables. The package is not referenced by any other documented package, so it is consumed directly by user-facing or scheduled processes rather than by internal dependency chains. The low version number in the header comment reflects the package's age relative to later releases.