Results for “gl_oasis_summary_data”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FII_BIS_GLEPS_V is an internal database view shipped within the Oracle E-Business Suite Financial Intelligence (FII) product family. It is not a standalone reporting entity exposed to end users through standard concurrent programs; rather, it serves as a supporting query layer consumed by the GL Analyst Summary EPS Drill Down PM Viewer Report. The view derives Earnings Per Share (EPS) figures — specifically basic EPS, diluted EPS, basic weighted share counts, and diluted weighted share counts — by aggregating balances stored in the GL Oasis summary data structures and normalizing them against fiscal period definitions.

The view is documented as "Not implemented in this database" in the provided ETRM metadata, meaning it may not be deployed in every environment, and its presence depends on whether the Financial Intelligence / Oasis drill-down reporting components have been installed and configured. Its primary role is analytical: it converts period-to-date financial item balances into per-share metrics suitable for drill-down presentation in the PM Viewer.

Underlying Base Objects

The view is defined over a nested subquery rather than a single base table. The documented inner query references the following objects:

• GL_OASIS_SUMMARY_DATA — the core fact source, aliased both as S and SD2. It supplies FIN_ITEM_ID values such as SOBASIC, SODILUT, PREFDIV, and REVENUE, along with RELATIVE_PERIOD_POS and QUARTER_TO_DATE amounts.
• GL_PERIOD_STATUSES — provides PERIOD_YEAR, PERIOD_NUM, QUARTER_NUM, and SET_OF_BOOKS_ID to establish fiscal period context.
• GL_SETS_OF_BOOKS — supplies SET_OF_BOOKS_ID and ACCOUNTED_PERIOD_TYPE, linking the ledger to its period type.
• GL_PERIOD_TYPES — provides NUMBER_PER_FISCAL_YEAR, used to compute the relative period index.
• GL_LOOKUPS — supplies the OASIS_QUARTERS lookup values (Q1–Q4), mapped to QUARTER_NUM.

The documented "Referenced base objects" list is empty; the above relationships are inferred directly from the view text. The critical join condition restricts GL_PERIOD_STATUSES rows to those whose computed relative period does not exceed the maximum RELATIVE_PERIOD_POS stored for the ledger and financial item.

Key Columns

• SET_OF_BOOKS_ID — identifies the ledger from which the EPS figures are drawn.
• PERIOD_YEAR — the fiscal year associated with the summarized balances.
• QUARTER_NUM — the fiscal quarter (1–4) derived via the OASIS_QUARTERS lookup.
• RELATIVE_PERIOD — the computed relative period index (PERIOD_YEAR × NUMBER_PER_FISCAL_YEAR + PERIOD_NUM), used to align quarter-to-date balances with the drill-down position.
• BASIC — basic EPS, calculated as the ratio of applicable income items to basic weighted shares, defaulting to zero when no basic share balance exists.
• DILUTED — diluted EPS, calculated analogously using the SODILUT share base.
• BASIC_SHARES — the aggregate quarter-to-date balance for the SOBASIC financial item.
• DILUTED_SHARES — the aggregate quarter-to-date balance for the SODILUT financial item.

Common Use Cases and Queries

The view is primarily queried by the GL Analyst Summary EPS Drill Down PM Viewer Report. A typical investigative query retrieves quarterly EPS metrics for a given ledger and year:

• SELECT set_of_books_id, period_year, quarter_num, basic, diluted, basic_shares, diluted_shares FROM fii_bis_gleps_v WHERE set_of_books_id = :ledger_id AND period_year = :year ORDER BY quarter_num;
• Reconciling EPS values against the underlying GL_OASIS_SUMMARY_DATA balances for the SOBASIC, SODILUT, and PREFDIV financial items.
• Investigating relative_period mismatches by comparing the view's RELATIVE_PERIOD output with stored RELATIVE_PERIOD_POS values, a frequent cause of missing rows in drill-down results.
• Auditing quarter-to-date share counts across ledgers to validate weighted-average share calculations used in external financial disclosures.