Search Results ff_contexts_s

Overview

FF_LOAD_CONTEXTS_PKG is an Oracle EBS Application Object Library (APPS schema) PL/SQL package body that supports the loading and maintenance of Fast Formula context definitions. In Oracle EBS 12.1.1 and 12.2.2, Fast Formula contexts define the runtime variables and database items made visible to a formula when it executes, most commonly the context associated with a formula type or a specific formula usage. The package bridges the gap between the underlying context metadata stored in the FF_CONTEXTS table and the loader mechanism used to seed or migrate that metadata into a target environment.

From a business perspective, the package ensures that Fast Formula contexts are validated and persisted consistently. It is classified under the API classification OTHER, meaning it is not a public, fully documented business API but is rather an internal loader utility used primarily by Oracle's seed data and upgrade processes. Because it is not referenced by any other database object, it is effectively a top-level utility invoked directly during data loading or setup operations.

Key Procedures and Functions

• VALIDATE_NAME — Performs validation of a context name before it is inserted or loaded into the FF_CONTEXTS table. This procedure enforces naming rules and prevents duplicate or malformed context identifiers from being committed to the context metadata repository.
• LOAD_ROW — Loads a single row of context data into the Fast Formula context tables. It handles the insert or update of the context record in FF_CONTEXTS and its translated/seed counterpart FF_CONTEXTS_S, applying the name validation performed by VALIDATE_NAME. This is the core entry point for seeding context definitions.

The metadata documents two procedures for this package. No parameter lists are documented, and none should be assumed; consumers should inspect the package specification or dependency information for exact signatures.

Tables Accessed

• FF_CONTEXTS — The base (non-translated) table of Fast Formula context definitions. LOAD_ROW writes validated context rows here, making them available for formula compilation and execution.
• FF_CONTEXTS_S — The translated/seed table (the "_S" suffix indicates a seed data table used during installation and upgrade). LOAD_ROW populates this table so translations and seed records remain synchronized with FF_CONTEXTS. This is also the object implied by the search term "ff_contexts_s".
• PLITBLM — A PL/SQL internal table type provided by the STANDARD package, used as an in-memory collection for name validation and row buffering during the load process.
• HR_UTILITY — A shared Human Resources utility package referenced for common validation and lookup logic.

Usage Notes

FF_LOAD_CONTEXTS_PKG is typically invoked by Oracle's seed data loader and upgrade drivers rather than by end users. During installation or patching, Oracle's data loading framework calls LOAD_ROW to seed Fast Formula context definitions, while VALIDATE_NAME guards against invalid inserts. Because it is not referenced by any other database object, it does not participate in a documented public API chain.

In 12.1.1 and 12.2.2 environments, the package is relevant when administrators or technical consultants troubleshoot Fast Formula context setup, migrate context metadata between instances, or investigate missing or duplicate context rows. Custom code should avoid calling LOAD_ROW directly unless deliberately seeding contexts, since bypassing the standard loader can produce inconsistent FF_CONTEXTS and FF_CONTEXTS_S records. Standard practice is to use the supported Fast Formula setup forms and concurrent programs, which rely on this package internally.