Results for “fv_facts_transactions”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FV_FACTS_TRANSACTIONS is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite. It is a core component of the Federal Financials / FACTS II reporting subsystem, which supports United States federal agencies operating on the EBS Financials platform. FACTS II (Federal Agencies' Centralized Trial-Balance System II) is the Treasury-mandated reporting mechanism through which federal agencies submit trial-balance data in the USSGL (United States Standard General Ledger) chart of accounts. This package serves as the transaction-processing engine for those submissions, assembling federal transaction detail, validating it against edit checks, resolving footnote references, and generating the bulk submission files transmitted to Treasury. It is classified as a non-public, internal package (API classification OTHER) that is consumed by other FACTS packages rather than exposed as a customer-facing API.

Key Procedures and Functions

The documented package exposes three procedures:

• SUBMIT — Initiates the FACTS II transaction submission workflow. It is the entry point that a concurrent program or calling package invokes to kick off processing for a given submission run.
• MAIN — The principal processing routine. It drives the core logic of extracting federal transaction data, applying USSGL account derivation, evaluating footnote and attribute assignments, and staging records into the FACTS temporary and submission tables.
• CREATE_BULK_FILE — Produces the output bulk file formatted for Treasury submission, consolidating the staged transaction records into the expected flat-file layout. It coordinates with FND_REQUEST and FND_CONCURRENT to manage file-generation job context.

No parameter lists are documented in the ETRM metadata, so signatures should be confirmed against the deployed source before direct invocation.

Tables Accessed

This package reads and writes a broad set of FACTS and shared EBS tables. The federal accounting tables include FV_FACTS_FEDERAL_ACCOUNTS, FV_FACTS_USSGL_ACCOUNTS, FV_FACTS_BUDGET_ACCOUNTS, and FV_FACTS_BUD_FED_ACCTS, which supply account cross-references and budget mappings. Transaction and staging tables include FV_FACTS_TRANSACTIONS itself, FV_FACTS_TEMP, FV_FACTS_SUBMISSION (and its _S sequence), FV_FACTS_PRC_HDR and FV_FACTS_PRC_DTL for processing control, FV_FACTS_RUN, and FV_FACTSII_ENDING_BALANCES. Footnote handling draws on FV_FACTS_FOOTNOTE_HDR, FV_FACTS_FOOTNOTE_HDR_S, FV_FACTS_FOOTNOTE_LINES, and FV_FACTS_FOOTNOTE_LINES_S — the objects most relevant to the search term "fv_facts_footnote_hdr_s." Validation relies on FV_FACTS_EDIT_CHECK and FV_FACTS_EDIT_CHECK_STATUS, plus FV_FACTS_ATTRIBUTES. Supporting lookups include FV_BE_TRANSACTION_TYPES, FV_BE_TRX_DTLS, FV_FUND_PARAMETERS, FV_SYSTEM_PARAMETERS, FV_TREASURY_SYMBOLS, and FV_PYA_FISCALYEAR_MAP/SEGMENT. General Ledger sources include GL_CODE_COMBINATIONS, GL_JE_HEADERS, GL_JE_LINES, GL_LEDGERS_PUBLIC_V, GL_PERIOD_STATUSES, GL_SETS_OF_BOOKS, and GL_ACCESS_SET_SECURITY_PKG for data-access security. Flexfield metadata (FND_FLEX_VALUES, FND_FLEX_VALUES_TL, FND_FLEX_VALUE_HIERARCHIES, FND_FLEX_VALUE_SETS, FND_ID_FLEX_SEGMENTS) is used for USSGL segment resolution, while FND_GLOBAL, FND_PROFILE, FND_LOG, FND_REQUEST, and FND_CONCURRENT provide runtime context, logging, and concurrent-program coordination. DBMS_SQL supports dynamic SQL construction.

Usage Notes

FV_FACTS_TRANSACTIONS is not referenced by any database object, meaning it functions as a top-level driver rather than a utility library. It is referenced by three other packages, indicating it is called from within the FACTS processing chain. In practice, it is invoked through the FACTS II concurrent programs — typically the program that builds and validates federal transaction submissions and generates the bulk file submitted to Treasury. Because it depends on GL access-set security and FND_PROFILE, execution must occur under a valid APPS responsibility whose security profile grants access to the relevant ledger and federal account ranges. When troubleshooting footnote-related issues (such as the "fv_facts_footnote_hdr_s" search that surfaced this object), the footnote header, line, and sequence tables listed above should be inspected, as MAIN and CREATE_BULK_FILE read these to attach Treasury-required footnote references to transaction records. Direct custom invocation is possible but is not recommended without first confirming parameter signatures in the deployed package source, since the ETRM metadata documents procedure names only. Diagnostic output is available through FND_LOG, and job status through FND_CONCURRENT, which makes the concurrent request log the first place to look when submission processing fails.