Search Results get_period_year

Overview

FV_FACTS_TRX_REGISTER is an Oracle E-Business Suite package owned by APPS that supports the FACTS (Federal Agencies' Centralized Trial-Balance System) transaction register extraction process. FACTS is the U.S. Treasury mechanism through which federal agencies report their financial activity, and the transaction register represents the line-level accounting detail that agencies submit for consolidation into government-wide financial statements. Within Oracle EBS 12.1.1 and 12.2.2, this package provides the PL/SQL logic behind the FACTS transaction register concurrent program, which gathers subledger and general ledger activity for a selected ledger, chart of accounts, currency, treasury symbol range, and accounting period range, then formats the results for Treasury submission. The package header carries a 120.9 header revision, confirming it is part of the standard, Oracle-shipped federal financials codebase rather than a customer extension. As an OTHER-classified API, it is not documented as a general-purpose integration interface; it is intended primarily for internal invocation by its associated concurrent program.

Key Procedures and Functions

The package exposes thirteen documented procedures and functions. MAIN is the entry point called by the concurrent program and orchestrates all subsequent processing steps. PROCESS_PERIOD_INFO derives the period number range and loads it into internal globals used for filtering accounted activity. GET_QUALIFIER_SEGMENTS identifies the accounting and balancing segments of the chart of accounts, which drive how FACTS attributes are qualified. JOURNAL_PROCESS performs the core journal-level extraction and processing of transaction data. GET_DOC_USER, GET_FUND_GROUP_INFO, GET_SGL_PARENT, GET_USSGL_INFO, GET_PERIOD_YEAR, and GET_COHORT_INFO are supporting lookups that resolve document and user identifiers, fund group classification, Standard General Ledger parent values, USSGL attribute information, period-to-year mapping, and cohort (transaction grouping) information respectively. PURGE_FACTS_TRANSACTIONS removes previously staged FACTS transaction data, while LOAD_FACTS_ATTRIBUTES and RESET_FACTS_ATTRIBUTES populate and clear the FACTS attribute values associated with extracted transactions.

For users searching on get_period_year, this is a documented helper routine within the package that resolves the fiscal year associated with a given accounting period, information needed when constructing FACTS transaction register records and when evaluating period ranges passed to MAIN.

Tables Accessed

The package reads from a broad set of AP, AR, and GL tables through APPS synonyms. Payables activity is sourced from AP_INVOICES_ALL, AP_INVOICE_DISTRIBUTIONS and AP_INVOICE_DISTRIBUTIONS_ALL, AP_CHECKS_ALL, AP_INVOICE_PAYMENTS_ALL, AP_PAYMENT_HIST_DISTS, and the accounting event tables AP_ACCOUNTING_EVENTS, AP_ACCOUNTING_EVENTS_ALL, AP_AE_HEADERS_ALL, and AP_AE_LINES_ALL. Receivables activity is sourced from AR_ADJUSTMENTS_ALL, AR_CASH_RECEIPTS_ALL, AR_CASH_RECEIPT_HISTORY_ALL, and AR_DISTRIBUTIONS_ALL. General ledger balances and period information are drawn from GL_BALANCES, which supplies the accounted amounts and period context used to build the register and to support period-to-year derivation.

Usage Notes

FV_FACTS_TRX_REGISTER is normally invoked through its associated FACTS transaction register concurrent program rather than called directly from forms or custom code. MAIN accepts the standard concurrent program error buffer and return code parameters along with ledger, chart of accounts, currency, treasury symbol range, period name range, GL posted date range, source, category, report identifier, attribute set, and output format arguments. Because it is classified as OTHER and is referenced by no other documented packages, customizations should avoid depending on its internal procedures, as Oracle may change them between patch levels. Sites extending federal reporting typically configure the FACTS attribute set and submit the concurrent program for the required reporting period, letting the package handle extraction, attribute loading, and staging.