Search Results fv_facts_edit_check




Overview
Explore in AI Chat

Overview

FV_FACTS_EDIT_CHECK is an Oracle E-Business Suite PL/SQL package owned by the APPS schema. It belongs to the Federal Financials (FV) product family and supports the Treasury reporting and FACTS II (Federal Agencies' Centralized Trial-Balance System) submission workflow. Its principal business function is to centralize the validation logic applied against FACTS transaction data before that data is consolidated, authorized, and transmitted to Treasury. The package encapsulates the edit checks that determine whether federal account balances, Treasury symbols, and USSGL account attributes conform to the rules required for a valid FACTS submission.

The package is classified as OTHER in the ETRM metadata, meaning it is not a public, documented open interface or standard callable API. It is instead an internal engine invoked by the FACTS transaction processing flow. FV_FACTS_EDIT_CHECK is a VALID object in the APPS schema and is referenced by FV_FACTS_EDIT_CHECK itself (recursive internal calls) and by FV_FACTS_TRANSACTIONS, confirming its role as a subordinate service to the broader FACTS transaction package.

Key Procedures and Functions

The ETRM documentation records a single public procedure on this package:

  • PERFORM_EDIT_CHECKS — The documented entry point. It drives the edit-check process across the current FACTS data set, evaluating balances and attributes against the applicable federal and Treasury rules and recording the resulting status for each check performed. Internally the procedure relies on the supporting tables described below to retrieve parameters, resolve account attributes, and persist status outcomes. No parameter list is documented, so invocation specifics should be derived from the calling package FV_FACTS_TRANSACTIONS.

Tables Accessed

The package references a broad set of APPS synonyms that together represent the FACTS validation and submission data model:

Usage Notes

FV_FACTS_EDIT_CHECK is not intended for direct end-user invocation. It is called programmatically from within the FACTS transaction processing flow, most notably by FV_FACTS_TRANSACTIONS, during the preparation of a FACTS II submission. Typical trigger points include running the FACTS edit/report process from the Federal Financials responsibility menu, where edit checks are executed prior to generating the Treasury submission file. Because the package writes to FV_FACTS_EDIT_CHECK_STATUS, results are persisted and can be reviewed by the user to correct rejected transactions before resubmission.

Customizations should avoid modifying this package directly; instead, extensions should invoke the documented entry point PERFORM_EDIT_CHECKS or read the resulting status records. As with all APPS-owned Federal Financials code, any changes must be applied through supported patching to preserve upgrade integrity across EBS 12.1.1 and 12.2.2.