Search Results reported_new

Overview

APPS.FV_FACTS_TB_V is a reporting view in Oracle EBS Financials that surfaces trial balance (TB) fact records captured by the Treasury/funds management (FV) subsystem. It is one of the ETRM (Enterprise Treasury/Funds) integration views used to expose accounting facts staged in FV_FACTS_TEMP to downstream reporting, reconciliation, and GL integration processes. The view is defined specifically for records whose integration record category is REPORTED_NEW and whose integration record type is TB, meaning it presents only newly reported trial balance facts — the freshly captured fact rows that have not yet been superseded by other categories.

Because the view joins to GL_ACCESS_SET_LEDGERS and filters by GL_ACCESS_SET_ID via FND_PROFILE.VALUE, it is access-set aware: users see only the ledgers their responsibility is authorized to access. This makes it suitable for embedded reporting, dashboard queries, and integration extracts that must respect Oracle EBS data security.

Underlying Base Objects

• FV_FACTS_TEMP (SYNONYM) — the primary fact staging table; supplies most columns and the REPORTED_NEW/TB filter.
• FV_TREASURY_SYMBOLS (SYNONYM) — joined on TREASURY_SYMBOL_ID to provide the treasury symbol and set of books.
• GL_ACCESS_SET_LEDGERS (TABLE) — joined on the profile-driven access set to enforce ledger security.
• GL_LEDGERS (SYNONYM) — joined on LEDGER_ID to supply the ledger and CHART_OF_ACCOUNTS_ID.
• FND_ID_FLEX_SEGMENTS — used to resolve the GL accounting flexfield structure and segment columns.
• FND_SEGMENT_ATTRIBUTE_VALUES — linked to flex segments via APPLICATION_COLUMN_NAME.
• FND_FLEX_VALUES_TL — provides the translated segment value DESCRIPTION.
• FND_FLEX_VALUES — the base flex value table.
• FND_PROFILE (PACKAGE) — resolves the current GL_ACCESS_SET_ID.

Key Columns

• PARENT_SGL_ACCT_NUMBER, SGL_ACCT_NUMBER, TBAL_ACCT_NUM — Treasury/Standard General Ledger account identifiers.
• BEGIN_AMT / END_AMT — aliases of FVFT.AMOUNT and FVFT.AMOUNT + PERIOD_ACTIVITY, yielding opening and closing balances.
• PERIOD_ACTIVITY, DR_AMOUNT (AMOUNT1), CR_AMOUNT (AMOUNT2) — movement and debit/credit split amounts.
• CODE_COMBINATION_ID and SEGMENT1–SEGMENT30 — the full accounting flexfield key.
• APPOR_CAT_B_DTL, APPOR_CAT_B_TXT, APPOR_CAT_CODE, BEA_CATEGORY, BUDGET_FUNCTION, AUTHORITY_TYPE — Treasury appropriation and budget classification attributes.
• ADVANCE_FLAG, DEFICIENCY_FLAG, DEF_LIQUID_FLAG, INDEF_DEF_FLAG, LEGISLATION_FLAG, PYA_FLAG, REIMBURSEABLE_FLAG — funds control and Treasury status flags.
• TREASURY_SYMBOL, CURRENCY_CODE, DESCRIPTION, YEAR_BUDGET_AUTH, PUBLIC_LAW — reference and descriptive attributes.

Common Use Cases and Queries

Typical uses include reconciliation of reported Treasury trial balances against GL balances, extraction feeds to federal reporting, and validation of appropriation category attributes on newly reported facts.

SELECT sgl_acct_number, treasury_symbol, currency_code,
       begin_amt, period_activity, end_amt
FROM   apps.fv_facts_tb_v
WHERE  treasury_symbol = :p_symbol;

Filtering for funds control exceptions:

SELECT code_combination_id, deficiency_flag, pya_flag, dr_amount, cr_amount
FROM   apps.fv_facts_tb_v
WHERE  deficiency_flag = 'Y'
   OR  pya_flag = 'Y';

Because the view already enforces REPORTED_NEW and TB selection plus access-set security, queries can be issued directly without additional ledger predicates, though adding TREASURY_SYMBOL_ID or CODE_COMBINATION_ID filters improves performance on large fact volumes.