Search Results ff_function_parameters




Overview
Explore in AI Chat

Overview

The FF_FUNCTION_PARAMETERS table is a core data dictionary object within the Oracle E-Business Suite FastFormula (FF) module. It serves as the repository for defining the parameters, or arguments, that can be passed to a specific user-defined FastFormula function. FastFormula is a declarative language engine used extensively across HR, Payroll, and other EBS modules to define complex business rules for calculations, validations, and data transformations. This table, owned by the HR schema, is essential for the system's understanding of how to invoke these custom functions, defining the parameter name, data type, and order for each function stored in the related FF_FUNCTIONS table.

Key Information Stored

The table's structure is designed to define the signature of a FastFormula function. Key columns include FUNCTION_ID, which links the parameter to its parent function definition in FF_FUNCTIONS. The SEQUENCE_NUMBER column dictates the order in which parameters must be supplied when calling the function. The NAME column stores the unique identifier for the parameter within the scope of its function. While the provided metadata does not list all columns, typical implementations also include columns for the parameter's DATA_TYPE (e.g., text, number, date) and potentially a DEFAULT_VALUE. The table's integrity is enforced by two primary keys: one on (FUNCTION_ID, SEQUENCE_NUMBER) to guarantee parameter order and another unique key on (FUNCTION_ID, NAME) to ensure parameter names are unique per function.

Common Use Cases and Queries

This table is primarily accessed for metadata queries to understand, document, or troubleshoot custom FastFormula functions. A common use case is generating a data dictionary report of all user-defined functions and their parameters. For instance, developers or functional consultants may run a query to list parameters for a specific function to verify its calling convention before embedding it in a formula. Another critical scenario is during impact analysis before modifying or deleting a function, where queries against this table help identify dependencies. A sample query to retrieve function signatures would join FF_FUNCTIONS with FF_FUNCTION_PARAMETERS on FUNCTION_ID, ordering the results by FUNCTION_NAME and SEQUENCE_NUMBER to display a clean parameter list.

Related Objects

The FF_FUNCTION_PARAMETERS table has a direct and singular parent-child relationship with the FF_FUNCTIONS table, which stores the core definition of the FastFormula function itself. The documented foreign key relationship is:

  • FF_FUNCTIONS: The FF_FUNCTION_PARAMETERS.FUNCTION_ID column references the FF_FUNCTIONS table. This relationship ensures that every parameter definition is associated with a valid, existing function. Any query to get meaningful parameter data will typically involve an INNER JOIN on this key, such as SELECT f.NAME AS FUNCTION_NAME, p.* FROM ff_functions f, ff_function_parameters p WHERE f.function_id = p.function_id;.