Search Results compiled_text

Overview

The FF_COMPILED_INFO view is a date-effective reporting object within the FastFormula (FF) product module of Oracle E-Business Suite. It is owned by the APPS schema and holds a status of VALID in both ETRM 12.1.1 and 12.2.2 environments. Its principal role is to expose compiled FastFormula metadata that is valid for the effective date of the current user session, making it suitable for runtime and diagnostic reporting where a single point-in-time snapshot of compiled formula attributes is required.

Because FastFormula definitions are date-effectivity enabled, a formula can have multiple compiled representations across different periods. The view resolves this by comparing the formula's effective date range against the effective date stored for the calling session in FND_SESSIONS. Consequently, every query returns only the compiled records whose effective window brackets the session's effective date. This behavior is consistent with the standard Oracle EBS date-effective pattern and ensures that runtime formula resolution aligns with the session's reporting context. For the user searching on select_statement_count, this view is the documented access point for that metric.

Underlying Base Objects

The view is defined over two documented referenced objects, both exposed as synonyms:

• FF_COMPILED_INFO_F — the base Foundation table holding the date-effective compiled formula records. The view selects all of its exposed columns and applies the date-effective filter against it.
• FND_SESSIONS — the standard Oracle Application Object Library session table, used twice in the view definition to obtain the session's effective date for both the lower and upper bounds of the effectivity range.

The view text joins the base table to the session context through scalar subqueries: EFFECTIVE_START_DATE <= (SELECT SS.EFFECTIVE_DATE FROM FND_SESSIONS SS WHERE SS.SESSION_ID = USERENV('SESSIONID')) and the symmetric condition on EFFECTIVE_END_DATE. This structure is the canonical date-effective construct and explains why the view requires an initialized EBS session to return rows.

Key Columns

• FORMULA_ID — the unique identifier of the FastFormula whose compiled information is being described.
• EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — the effectivity window of the compiled record.
• FDIU_ENTRY_COUNT — count of FastFormula Database Item Usage entries associated with the compiled formula.
• SELECT_STATEMENT_COUNT — the number of SELECT statements in the compiled formula, a key metric for assessing formula complexity and performance impact.
• TEXT_LENGTH — the character length of the formula text.
• COMPILED_TEXT — the compiled representation of the formula.

Common Use Cases and Queries

The view is typically queried for formula complexity analysis, compile-troubleshooting, and impact assessment before patching or tuning. A representative query returns the compiled metrics for the current session's effective date:

• SELECT FORMULA_ID, SELECT_STATEMENT_COUNT, FDIU_ENTRY_COUNT, TEXT_LENGTH FROM APPS.FF_COMPILED_INFO;
• SELECT FORMULA_ID, COMPILED_TEXT FROM APPS.FF_COMPILED_INFO WHERE SELECT_STATEMENT_COUNT > 10;
• SELECT FORMULA_ID, FDIU_ENTRY_COUNT FROM APPS.FF_COMPILED_INFO WHERE FDIU_ENTRY_COUNT > 20 ORDER BY FORMULA_ID;

Analysts use these results to flag formulas whose SELECT statement count or database item usage may degrade runtime performance, and to verify compile output after a formula is recompiled. Because the view filters on the session effective date, results should always be interpreted in the context of the session's effective date rather than as an unfiltered historical record.