Results for “reported_status”

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:

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.