Search Results end_amt

Overview

FV_FACTS_TB_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the Federal Financials (FV) product family. Its documented purpose is to publish FACTS II Trial Balance information in the RXi (Report eXchange interface) format. FACTS II (Federal Agencies' Centralized Trial-Balance System II) is the U.S. Treasury mechanism through which federal agencies submit pre-closing trial-balance data at the Treasury Account Symbol (TAS) level, and this view functions as the extraction layer that presents ledger balances and their associated federal attributes in the structure expected by that submission process.

The view is registered as VALID in the APPS schema and is present in both Oracle EBS 12.1.1 and 12.2.2 environments. Because it is a view rather than a base table, it holds no data of its own; it projects and joins data that has already been staged by the FACTS II processing programs into the temporary interface table FV_FACTS_TEMP. This makes FV_FACTS_TB_V a read-only presentation object intended for reporting and integration consumers rather than for direct transactional use.

Underlying Base Objects

The view is defined over a join of several objects. The driving object is FV_FACTS_TEMP (referenced through a synonym), which stores staged FACTS II trial-balance records filtered by the view to record category 'REPORTED_NEW' and record type 'TB'. Supporting objects include FV_TREASURY_SYMBOLS, which supplies the Treasury Account Symbol and links to the set of books; FND_ID_FLEX_SEGMENTS, which identifies the accounting flexfield structure and the segment being reported; FND_FLEX_VALUES and FND_FLEX_VALUES_TL, which provide the segment value and its translated description; and GL_SETS_OF_BOOKS, which supplies the ledger currency code.

The documented metadata also lists GL_ACCESS_SET_LEDGERS, GL_LEDGERS, FND_PROFILE, and FND_SEGMENT_ATTRIBUTE_VALUES among the referenced base objects, reflecting the view's dependence on ledger and access-set security context in 12.2.2 multi-ledger configurations. Two session context values are central to the join logic: SYS_CONTEXT('FV_CONTEXT','CHART_OF_ACCOUNTS_ID') and SYS_CONTEXT('FV_CONTEXT','ACCT_SEGMENT'), which drive the flexfield structure and segment selection respectively.

Key Columns

• PARENT_SGL_ACCT_NUMBER, SGL_ACCT_NUMBER: the Standard General Ledger account identifiers used for FACTS II reporting.
• TBAL_ACCT_NUM, TBAL_FUND_VALUE: the Treasury trial-balance account number and fund value used to align reported balances with Treasury conventions.
• BEGIN_AMT, PERIOD_ACTIVITY, END_AMT: opening balance, activity for the reporting period, and derived ending balance (BEGIN_AMT + PERIOD_ACTIVITY).
• DR_AMOUNT (AMOUNT1), CR_AMOUNT (AMOUNT2): debit and credit amounts supporting the trial-balance presentation.
• TREASURY_SYMBOL, TREASURY_SYMBOL_ID: the TAS under which the balance is reported, joined from FV_TREASURY_SYMBOLS.
• CURRENCY_CODE: the ledger currency, derived from GL_SETS_OF_BOOKS.
• Federal attribute columns: AUTHORITY_TYPE, BUDGET_FUNCTION, BEA_CATEGORY, APPOR_CAT_CODE, AVAILABILITY_FLAG, BORROWING_SOURCE, COHORT, DEFICIENCY_FLAG, REIMBURSEABLE_FLAG, TRANSACTION_PARTNER, TRANSFER_DEPT_ID, and PUBLIC_LAW, which carry the reporting classifications required by Treasury.
• SEGMENT1 through SEGMENT30: the account segments of the accounting flexfield, exposed individually for reporting flexibility.
• DESCRIPTION: the translated flexfield value description.

Common Use Cases and Queries

Typical usage is the extraction of trial-balance data for Treasury reporting and reconciliation. A common query retrieves ending balances by fund and account for the reporting period:

SELECT tbal_fund_value, tbal_acct_num, treasury_symbol,
       begin_amt, period_activity, end_amt
FROM   apps.fv_facts_tb_v
WHERE  availability_flag = 'Y'
ORDER BY tbal_fund_value, tbal_acct_num;

Debit and credit analysis may be performed directly against the DR_AMOUNT and CR_AMOUNT columns, while ledger-level reconciliation uses CURRENCY_CODE combined with the segment columns. Because the view resolves the accounting segment through session context, consumers generally run it from within the Federal Financials application, where FV_CONTEXT is initialized, rather than from ad hoc SQL sessions without the appropriate context. For 12.2.2 deployments, queries should also account for the data access set restriction implied by GL_ACCESS_SET_LEDGERS, since only ledgers accessible to the session are returned.