Search Results p_gei_view

Overview

APPS.JE_NO_GEI_SREPORT_V is a public Oracle EBS view in the Application Object Library (APPS) schema. Its documented status is VALID, and its FND Design Data reference is JE.JE_NO_GEI_SREPORT_V, placing it within the Journal Entry (JE) product family. The view is intended to be useful for custom reporting and other data requirements, exposing summarized accounting information derived from the General Ledger balances and account combination tables.

The distinguishing characteristic of this object is that it is not a statically defined view in the conventional sense. According to the object documentation, the view is recreated at runtime by the procedure P_GEI_VIEW, which is invoked by the report JENOGEIS. When recreated, the view's definition is based on profile values set by the Costing (Cst) application. This dynamic construction means the structure and content of the view may vary depending on the environment and profile option settings at the time the report executes. The object name searched, "p_gei_view," corresponds directly to this runtime procedure rather than to a stored database object, which explains why it is resolved through the JE_NO_GEI_SREPORT_V metadata entry.

Underlying Base Objects

The ETRM metadata documents that JE_NO_GEI_SREPORT_V references the following base objects:

• GL_BALANCES (referenced as a synonym) — the General Ledger balances table, which supplies the period balance amounts and the actual flag that drives the balancing information.
• GL_CODE_COMBINATIONS (referenced as a synonym) — the account combination table, which supplies the account number and the accounting flexfield segment values used to identify each balanced account.
• GL_SETS_OF_BOOKS (referenced as a view) — the set of books definition, providing the ledger context and book-level attributes associated with the balances.

The documented dependency list confirms these three General Ledger objects as the sole referenced base objects. Conversely, the view is referenced by APPS.JE_JENOGEIS_XMLP_PKG, the XML Publisher package associated with the JENOGEIS report, confirming its role as the data source for that concurrent program's output.

Key Columns

The view exposes eight columns, each documented as follows:

• AUTHORITY_TYPE (VARCHAR2, 25) — the authority type classification applied to the reported balance.
• PERIOD (VARCHAR2, 15) — the accounting period name against which the balance is reported.
• ACTUAL_FLAG (VARCHAR2) — indicates whether the balance is actual, budget, or encumbrance, consistent with the GL_BALANCES actual flag.
• ACCOUNT_NUMBER (VARCHAR2, 25) — the account number, typically the concatenated accounting flexfield for the combination.
• BALANCE (NUMBER) — the period balance amount for the account and authority type.
• TEMPLATE_ID (NUMBER, 15) — identifier of the reporting template associated with the row.
• PERIOD_NUM (NUMBER, 15) — the numeric period number within the fiscal year.
• PERIOD_YEAR (NUMBER, 15) — the fiscal year of the reported period.

Common Use Cases and Queries

The principal use case is the JENOGEIS report itself, where the view serves as the runtime-generated data source. For custom reporting, the view may be queried directly once it has been instantiated. A representative query is:

• SELECT AUTHORITY_TYPE, PERIOD, ACTUAL_FLAG, ACCOUNT_NUMBER, BALANCE, TEMPLATE_ID, PERIOD_NUM, PERIOD_YEAR FROM APPS.JE_NO_GEI_SREPORT_V;
• Filtering by period and year, for example WHERE PERIOD_YEAR = 2024 AND PERIOD_NUM = 1, to isolate a specific accounting period.
• Joining ACCOUNT_NUMBER to GL_CODE_COMBINATIONS for descriptive flexfield detail or segment-level analysis.

Consumers should note that because the view is recreated at runtime by P_GEI_VIEW, its contents reflect the profile values in effect when JENOGEIS last executed. Direct queries outside the report cycle may therefore return results based on the most recent instantiation rather than a live, continuously maintained definition.