Search Results fud1_id




Overview
Explore in AI Chat

Overview

The view FII_GL_JE_SUMMARY_B_S_V belongs to the Financial Intelligence (FII) product family within Oracle E-Business Suite. FII was Oracle's early analytical layer for financial consolidation and reporting, predating the broader Oracle Business Intelligence Applications. In EBS 12.1.1 and 12.2.2, the FII schema is documented as Obsolete and, per the ETRM metadata, is not implemented in this database. The view therefore exists only as documented metadata for legacy reference and does not participate in active reporting or integration flows in current environments.

The _S_V suffix denotes a "summary view" — a simplified projection over a base summary table. Its purpose was to expose pre-aggregated General Ledger journal entry data, denominated in the functional currency, to downstream financial intelligence reporting engines. Rather than querying raw GL balances or journal lines, FII consumers read curated, dimension-aware summary rows.

Underlying Base Objects

The ETRM metadata records a single underlying base object: FII_GL_JE_SUMMARY_B. The view performs a straight column projection with two aliasing operations:

No joins, filters, or aggregation logic are applied in the view definition; all summarization occurs in the base table. Because the FII schema is obsolete in 12.1.1 and 12.2.2, the base table is similarly absent from a standard implementation, and the view cannot be queried successfully in those releases.

Key Columns

  • TIME_ID – Foreign key to the FII time dimension; identifies the accounting period of the summarized data.
  • PERIOD_TYPE_ID – Identifies the period type (e.g., month, quarter) associated with the time dimension.
  • PROD_CATEGORY_ID – Product category dimension identifier.
  • JE_SOURCE / JE_CATEGORY – Standard GL journal source and category, enabling filtering by transaction origin.
  • LEDGER_ID – Identifies the ledger (set of books in older terminology) of the summarized entries.
  • CHART_OF_ACCOUNTS_ID – Chart of accounts for the ledger.
  • FUNCTIONAL_CURRENCY – The functional currency code. This is the column most directly relevant to the user's search term and confirms the view stores amounts already translated into functional currency.
  • AMOUNT_B / AMOUNT_G – Entered/base amount and the generalized (functional-currency) amount, respectively.
  • FIN_CATEGORY_ID, COMPANY_ID, COST_CENTER_ID, FUD1_ID, FUD2_ID – FII dimension keys for financial category, company, cost center, and two user-defined dimensions.
  • CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN – Standard audit columns.

Common Use Cases and Queries

Historically, this view supported functional-currency financial reporting, period-over-period analysis, and dimension-sliced GL summarization. A representative query would be:

SELECT ledger_id, functional_currency, je_source, je_category,
       SUM(amount_g) AS total_functional
FROM   fii_gl_je_summary_b_s_v
WHERE  time_id = :p_time_id
GROUP  BY ledger_id, functional_currency, je_source, je_category;

In EBS 12.1.1 and 12.2.2 the view is unavailable; equivalent reporting should be sourced from GL_BALANCES, GL_JE_LINES, or Oracle Fusion/OBIA financial subject areas. The metadata is retained for migration traceability only.