Results for “ff_function_parameters”

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

Overview

The FF_FUNCTION_PARAMETERS table, owned by the HR schema and delivered as part of the FastFormula (FF) product module, stores the definitions of parameters belonging to a specific FastFormula function. In Oracle EBS 12.1.1 and 12.2.2, FastFormula functions are callable units referenced from within formula text, and FF_FUNCTION_PARAMETERS describes the signature of each such function: what parameters it accepts, in what order, of what data type, and whether each is optional. The table therefore acts as the metadata dictionary that lets the FastFormula compiler and runtime resolve, validate, and bind arguments passed to a function at execution time.

From a Data Vault modeling perspective, the mined foreign-key structure classifies this table as satellite-leaning. Its rows describe the attributes and structure of a parent function rather than representing an independent business entity or an associative link between two entities, which is consistent with a satellite attached to a hub or to another satellite record.

Key Information Stored

The table contains 14 documented columns. The most significant are:

• FUNCTION_ID — Foreign key to FF_FUNCTIONS, identifying the parent FastFormula function to which the parameter belongs.
• SEQUENCE_NUMBER — Positional ordering of the parameter within the function signature.
• NAME — The parameter name used in function definitions and formula calls.
• DATA_TYPE — The datatype of the parameter (for example numeric, text, or date), used for validation and binding.
• CLASS — Classification of the parameter, such as input or output, controlling how values flow between formula and function.
• OPTIONAL — Flag indicating whether the parameter may be omitted when the function is invoked.
• CONTINUING_PARAMETER — Indicates a repeating or continuation parameter that can accept multiple values.
• OBJECT_VERSION_NUMBER — Optimistic locking column used by the Oracle Application Framework and concurrent programs.
• LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE — Standard WHO audit columns documenting row creation and modification.
• ZD_EDITION_NAME — Editioning column supporting EBS 12.2 online patching and edition-based redefinition.

The surrogate primary key is FF_FUNCTION_PARAMETERS_PK, defined on (FUNCTION_ID, SEQUENCE_NUMBER, ZD_EDITION_NAME). A second unique index, FF_FUNCTION_PARAMETERS_UK2 on (FUNCTION_ID, NAME, ZD_EDITION_NAME), serves as a business-key candidate, enforcing that parameter names are unique within a given function per edition. Because it is an editioned table, the primary key includes the edition column.

Common Use Cases and Queries

Developers and administrators query this table to understand the expected signature of a FastFormula function before writing or debugging formula text. A typical lookup retrieves the ordered parameter list for a named function:

• SELECT p.SEQUENCE_NUMBER, p.NAME, p.DATA_TYPE, p.CLASS, p.OPTIONAL FROM ff_function_parameters p, ff_functions f WHERE p.FUNCTION_ID = f.FUNCTION_ID AND f.NAME = :function_name ORDER BY p.SEQUENCE_NUMBER;
• Metadata audits that enumerate all optional or continuation parameters across a function library.
• Impact analysis when a function signature changes, to identify dependent formulas.
• Documentation and reporting of the available FastFormula function catalogue.

Related Objects

• FF_FUNCTIONS — The primary parent table, joined via FF_FUNCTION_PARAMETERS.FUNCTION_ID = FF_FUNCTIONS.FUNCTION_ID.
• FF_FORMULAS — Formula definitions that invoke the functions described by this table.
• FF_FORMULA_FUNCTIONS — Association between formulas and the functions they reference.
• FF_FUNCTION_CONTEXTS — Context and usage metadata for FastFormula functions.
• FF_COMPILER_ERRORS — Compilation diagnostics produced when function arguments violate the parameter definitions held here.