Search Results document_source

Overview

FV_FACTS_TRX_V is a read-only database view owned by the APPS schema within the FV – Federal Financials product family of Oracle E-Business Suite. Its documented purpose is to publish FACTS (Financial Accounting and Cost Tracking System) transaction register information to RXi, the reporting and extract layer used by federal agencies for external reporting. The view is classified as VALID, meaning it is compiled and available at runtime in both EBS 12.1.1 and 12.2.2 environments where Federal Financials has been implemented.

The view serves as a reporting-facing projection over the staging table FV_FACTS_TRX_TEMP. Rather than exposing raw staging rows, it joins the temporary transaction register to General Ledger code combinations, Treasury symbol definitions, and flexfield value descriptions, producing an enriched, human-readable transaction register suitable for downstream federal reporting and reconciliation. Because it is a view rather than a table, it introduces no additional storage and reflects the current contents of its base objects at query time.

Underlying Base Objects

The view is defined over the following documented base objects:

• FV_FACTS_TRX_TEMP (synonym) – the primary FACTS transaction register staging table supplying the bulk of the columns.
• GL_CODE_COMBINATIONS (synonym) – joined on CODE_COMBINATION_ID to resolve the accounting flexfield and expose SEGMENT1 through SEGMENT30.
• FV_TREASURY_SYMBOLS (synonym) – joined on TREASURY_SYMBOL_ID to supply TREASURY_SYMBOL.
• GL_SETS_OF_BOOKS / GL_LEDGERS – provide the CURRENCY_CODE associated with the SET_OF_BOOKS_ID.
• FND_ID_FLEX_SEGMENTS, FND_FLEX_VALUES, FND_FLEX_VALUES_TL – support flexfield segment resolution and description lookup, with FND_FLEX_VALUES_TL supplying the translated DESCRIPTION column.
• FND_SEGMENT_ATTRIBUTE_VALUES, FND_PROFILE, and GL_ACCESS_SET_LEDGERS – participate in segment attribute evaluation, profile option access, and ledger/access-set security filtering.

The join structure is driven from FV_FACTS_TRX_TEMP through CODE_COMBINATION_ID and TREASURY_SYMBOL_ID, with the remaining objects enriching the result set and enforcing access control.

Key Columns

The view exposes a broad set of transaction and accounting attributes. Principal columns include:

• SET_OF_BOOKS_ID / CURRENCY_CODE – identify the ledger and its currency.
• CODE_COMBINATION_ID / ACCOUNT_NUMBER / SEGMENT1–SEGMENT30 – the full accounting flexfield and its constituent segments.
• DEBIT / CREDIT and DEBIT_ACC / CREDIT_ACC – monetary amounts and DECODE-derived account labels that null out zero-value sides.
• DOCUMENT_SOURCE / DOCUMENT_NUMBER / ORIG_DOCNO – source identifiers; ORIG_DOCNO strips any suffix following a period in the document number.
• TRANSACTION_DATE / CREATION_DATE_TIME / JOURNAL_CREATION_DATE / JOURNAL_MODIFIED_DATE / PERIOD_NAME – temporal and period attributes.
• FED_NON_FED, TRADING_PARTNER, EXCH_NON_EXCH, CUST_NON_CUST – federal classification flags.
• TREASURY_SYMBOL, BUDGET_FUNCTION, BUDGET_SUBFUNCTION, YEAR_BUDGET_AUTH, PUBLIC_LAW, APPOR_CAT_CODE, AUTHORITY_TYPE – Treasury and budget authority attributes.
• ADVANCE_FLAG, COHORT, REIMBURSEABLE_FLAG, BEA_CATEGORY, BORROWING_SOURCE, DEF_LIQUID_FLAG, DEFICIENCY_FLAG – specialized federal accounting indicators.
• DESCRIPTION – translated flexfield description sourced from FND_FLEX_VALUES_TL.

Common Use Cases and Queries

Typical uses include FACTS transaction register extracts, RXi report sourcing, and reconciliation of staged federal transactions against General Ledger balances. A simple retrieval by ledger and period:

• SELECT document_number, transaction_date, account_number, debit, credit, treasury_symbol FROM apps.fv_facts_trx_v WHERE set_of_books_id = :p_sob AND period_name = :p_period;
• SELECT fed_non_fed, SUM(debit - credit) FROM apps.fv_facts_trx_v GROUP BY fed_non_fed;
• SELECT segment1, segment2, account_number, orig_docno FROM apps.fv_facts_trx_v WHERE journal_creation_date >= :p_from_date AND journal_creation_date < :p_to_date;

Because access is governed in part through GL_ACCESS_SET_LEDGERS, queries return only the ledgers the executing responsibility is authorized to view. Reports should therefore pass the appropriate ledger and period filters rather than scanning the view unfiltered.