Search Results ff_formula_types_s

Overview

The APPS.FF_LOAD_FTYPES_PKG package body is a database utility in the Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 releases. It belongs to the Oracle FastFormula (FF) schema area, which governs formula types, contexts, and their usage rules. The package's principal role is to load and seed configuration metadata for FastFormula types and the contexts in which those types are permitted. Its name, LOAD_FTYPES (load formula types), reflects a data-seeding or setup-migration utility rather than a runtime calculation engine.

Because formula types and context usages are delivered as Oracle seed data rather than user-maintained records, this package provides a controlled insertion path. This helps preserve the integrity of the FastFormula metadata that higher-level components depend on. The object holds a VALID status in the APPS schema, confirming it is a supported, compiled database object within the standard EBS installation.

Key Procedures and Functions

The documented package metadata lists two procedures:

• LOAD_ROW — Loads an individual formula type definition row. It inserts or reconciles a record into the FF_FORMULA_TYPES family of tables, using the seed metadata passed to it. This is the primary entry point for populating the set of formula types recognized by the application.
• LOAD_ROW_CONTEXT_USAGES — Loads context usage rows that associate a formula type with the specific contexts in which it can be applied. This procedure manages the relationship records that determine where a given formula type is valid.

Both procedures are written as loader routines, meaning they are designed to be called repetitively in a controlled sequence rather than invoked directly. Parameter lists are not documented in the available metadata and are therefore not stated here.

Tables Accessed

The package body references the following tables through APPS synonyms:

• FF_FORMULA_TYPES — the base table holding the definition of each formula type.
• FF_FORMULA_TYPES_S — the translated (TL) companion table for formula type names and descriptions. This is the object the user searched for, and it is populated as a consequence of the loader operations.
• FF_CONTEXTS — the table defining the available FastFormula contexts.
• FF_FTYPE_CONTEXT_USAGES — the intersection table linking formula types to their permitted contexts, maintained by LOAD_ROW_CONTEXT_USAGES.

Because the loader writes across both the base and translation tables, seeded formula type data becomes immediately visible in the run language of the EBS environment.

Usage Notes

This package is typically invoked during setup and patching activities, not during day-to-day transactional processing. It is commonly called by Oracle's seed data installation scripts when formula types are introduced or refreshed through an upgrade or a patch. Administrators and custom developers rarely call it directly; however, it may appear in migration or data-fix scripts that need to reestablish formula type definitions consistently across environments.

The package is not referenced by any other database object, so its scope is self-contained. Practitioners investigating FF_FORMULA_TYPES_S should note that rows in that table generally originate from this loader package and follow the delivered formula type metadata rather than ad-hoc application logic.