Results for “beginning_balance”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FV_FACTS1_PERIOD_BALANCES_V is an Oracle E-Business Suite (EBS) view owned by the APPS schema within the Federal Financials (FV) product. It is a reporting artifact of the FACTS I (Financial Accounting and Cost Tracking System) subsystem, which underpins U.S. federal agency budgetary and proprietary reporting. The view consolidates period-level balance data — reported, ending, and differential amounts — into a single denormalized structure with a consistent column layout suitable for downstream reporting, extract, and integration programs.
Functionally, the view presents one row per accounting period per reporting entity, keyed by chart-of-accounts combination (CCID), set of books, accounting period, and fund attributes. It distinguishes two classes of data through a UNION ALL: rows drawn from FV_FACTS1_PERIOD_ATTRIBUTES belonging to reporting group '1' (the "reported" balances, flagged with REPORTED_STATUS = 'R' and BALANCE_TYPE = 'G'), and rows drawn from the differential/elimination side of the same attributes set joined against party classification attributes. This dual construction supports the FACTS I requirement to present both published period balances and the eliminations adjustments required for consolidated federal-wide reporting. The ACCOUNT_TYPE column is carried through from the attributes table and is one of the primary search terms users apply to this view, since it separates asset, liability, net position, revenue, and expense classes.
Underlying Base Objects
Per the documented ETRM metadata for 12.2.2, the view is defined over the following base objects, all exposed to APPS as synonyms:
- FV_FACTS1_PERIOD_ATTRIBUTES — the principal source, supplying CCID, SET_OF_BOOKS_ID, PERIOD_YEAR, PERIOD_NUM, PERIOD_NAME, FUND_GROUP, ACCOUNT_NUMBER, FUND_VALUE, DEPT_ID, BUREAU_ID, G_NG_INDICATOR, END_BAL_IND, USSGL_ACCOUNT, EXCH_NON_EXCH, CUST_NON_CUST, BUDGET_SUBFUNCTION, ACCOUNT_TYPE, and the period balance amounts (BALANCE_AMOUNT, BEGIN_BALANCE, PERIOD_CY_DR_BAL, PERIOD_CY_CR_BAL, PERIOD_BEGIN_BAL).
- FV_FACTS1_LINE_BALANCES — line-level balance detail underlying the FACTS1 fact set.
- FV_FACTS1_DIFF_BALANCES — differential balance figures used in eliminations processing.
- FV_FACTS_ENDING_BALANCES — ending-balance repository for the FACTS fact tables.
The first branch of the UNION ALL filters A.REPORTED_GROUP = '1'. The second branch applies DECODE logic on G_NG_INDICATOR, PARTY_CLASSIFICATION, and ELIMINATIONS_DEPT to derive trading-partner and elimination department values, and returns zero for BEGINNING_BALANCE, PERIOD_DR, PERIOD_CR, and PERIOD_BEGIN_BAL, since the differential rows carry only the adjustment amount (B.AMOUNT).
Key Columns
- CCID — code combination identifier linking to GL_CODE_COMBINATIONS.
- SET_OF_BOOKS_ID — the ledger/set of books the balance belongs to.
- PERIOD_YEAR, PERIOD_NUM, PERIOD_NAME — accounting period identification.
- FUND_GROUP, FUND_VALUE, DEPT_ID, BUREAU_ID — federal fund and organizational attributes.
- ACCOUNT_TYPE — the GL account type classification (A/L/O/R/E) of the natural account, used to segment balances for statement presentation.
- G_NG_INDICATOR — government/non-government indicator, recalculated in the second branch based on party classification.
- END_BAL_IND — identifies the ending-balance indicator.
- REPORTED_STATUS — hard-coded 'R' for reported rows.
- USSGL_ACCOUNT, EXCH_NON_EXCH, CUST_NON_CUST, BUDGET_SUBFUNCTION — U.S. Standard General Ledger and Treasury reporting attributes.
- AMOUNT, BEGINNING_BALANCE, PERIOD_DR, PERIOD_CR, PERIOD_BEGIN_BAL — period activity and balance measures; note the alias mapping BALANCE_AMOUNT to AMOUNT.
- D_C_INDICATOR — DECODE(SIGN(BALANCE_AMOUNT), -1, 'C', 'D'), i.e. debit/credit sign.
- BALANCE_TYPE — 'G' for general ledger–sourced balances.
- ELIMINATIONS_DEPT, RECIPIENT_NAME — trading-partner and eliminations attributes.
Common Use Cases and Queries
Federal agencies and integrators use this view to feed USSGL crosswalks, Treasury reporting extracts, and Federal Financials reconciliation reports. A typical usage filters by set of books, period, and account type to isolate balance classes.
SELECT ccid, period_name, account_type, ussgl_account,
g_ng_indicator, amount, d_c_indicator
FROM apps.fv_facts1_period_balances_v
WHERE set_of_books_id = :p_sob_id
AND period_year = :p_year
AND period_num = :p_num
AND account_type = :p_account_type
ORDER BY ccid;
A second common pattern aggregates by account type to compare reported versus offsetting balances within an eliminations cycle:
SELECT account_type,
SUM(CASE WHEN g_ng_indicator = 'Y' THEN amount ELSE 0 END) gov_amount,
SUM(CASE WHEN g_ng_indicator = 'N' THEN amount ELSE 0 END) non_gov_amount
FROM apps.fv_facts1_period_balances_v
WHERE set_of_books_id = :p_sob_id
AND period_name = :p_period
GROUP BY account_type;
Because the view is read-only and defined with UNION ALL, queries should filter aggressively on SET_OF_BOOKS_ID and period columns to avoid unnecessary scans of the underlying synonym objects. All access should be through the APPS synonym in a reporting or a custom schema granted SELECT privilege on FV_FACTS1_PERIOD_BALANCES_V.
-
APPS.FV_FACTS1_PERIOD_BALANCES_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
Stores the FACTS-I yearly ending balances
-
Information about a consolidated billing invoice
-
Information about a consolidated billing invoice
-
This table is used by FACTS I Interface process to store Period Ending Balances.
-
APPS.FV_FACTS_PERIOD_BALANCES_TB_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
APPS.FV_FACTS_PERIOD_BALANCES_TB_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
Stores the FACTS-I yearly ending balances
-
View: CEFV_BANK_STATEMENTS 12.2.2
Business View
APPS.CEFV_BANK_STATEMENTS·↳ CE_BANK_ACCOUNTS·↳ CE_STATEMENT_HEADERS·↳ HR_ALL_ORGANIZATION_UNITS·Explore CE module →
-
View: FV_FACTS1_TB_V 12.2.2
This is view is used to publish FACTS-I Trial balance information in Rxi
APPS.FV_FACTS1_TB_V·↳ FND_FLEX_VALUES·↳ FND_FLEX_VALUES_TL·↳ FND_ID_FLEX_SEGMENTS·Explore FV module →
-
View: FV_TBAL_BY_TS_V 12.2.2
Lists the treasury symbol processed by the FACTS II Trial balance process
APPS.FV_TBAL_BY_TS_V·↳ FND_FLEX_VALUES·↳ FND_FLEX_VALUES_TL·↳ FND_ID_FLEX_SEGMENTS·Explore FV module →
-
View: CEBV_BANK_STATEMENTS 12.1.1
Business View
APPS.CEBV_BANK_STATEMENTS·↳ CE_STATEMENT_HEADERS·Explore CE module →
-
View: CEBV_BANK_STATEMENTS 12.2.2
Business View
APPS.CEBV_BANK_STATEMENTS·↳ CE_STATEMENT_HEADERS·Explore CE module →
-
Temporary work table populated with summary data used in FACTS report generation
-
View: CEFV_BANK_STATEMENTS 12.1.1
Business View
APPS.CEFV_BANK_STATEMENTS·↳ CE_BANK_ACCOUNTS·↳ CE_STATEMENT_HEADERS·↳ HR_ALL_ORGANIZATION_UNITS·Explore CE module →
-
APPS.FV_FACTS1_PERIOD_BALANCES_V·↳ FV_FACTS1_DIFF_BALANCES·↳ FV_FACTS1_LINE_BALANCES·↳ FV_FACTS1_PERIOD_ATTRIBUTES·Explore FV module →
-
This table is used by FACTS I Interface process to store Period Ending Balances.
-
View: FV_FACTS1_TB_V 12.1.1
This is view is used to publish FACTS-I Trial balance information in Rxi
APPS.FV_FACTS1_TB_V·↳ FND_FLEX_VALUES·↳ FND_FLEX_VALUES_TL·↳ FND_ID_FLEX_SEGMENTS·Explore FV module →
-
View: FV_TBAL_BY_TS_V 12.1.1
Lists the treasury symbol processed by the FACTS II Trial balance process
APPS.FV_TBAL_BY_TS_V·↳ FND_FLEX_VALUES·↳ FND_FLEX_VALUES_TL·↳ FND_ID_FLEX_SEGMENTS·Explore FV module →
-
Temporary work table populated with summary data used in FACTS report generation
-
VIEW: FV.FV_FACTS_REPORT_T2# 12.2.2
-
VIEW: FV.FV_GTAS1_REPORT_T2# 12.2.2
-
View: AR_TA_RECON_INFO 12.1.1
SINGLE_ORG view
Not implemented in this database·Explore AR module →
-
VIEW: AR.AR_CONS_INV_ALL# 12.2.2
-
View: AR_TA_RECON_INFO 12.2.2
SINGLE_ORG view
Not implemented in this database·Explore AR module →
-
VIEW: FV.FV_GTAS_REPORT_T2# 12.2.2
-
VIEW: APPS.FV_TBAL_BY_TS_V 12.2.2
-
VIEW: FV.FV_GTAS1_REPORT_T2# 12.2.2
-
VIEW: FV.FV_GTAS_REPORT_T2# 12.2.2