Search Results ff_route_parameters




Overview
Explore in AI Chat

Overview

The FF_ROUTE_PARAMETERS table is a core data dictionary object within the Oracle E-Business Suite FastFormula (FF) module. It defines the parameters that can be passed to a FastFormula ROUTE construct. A ROUTE is a specialized FastFormula function that retrieves data from a database table or view. The parameters stored in this table act as filters or restrictions, enabling the ROUTE to return a specific, targeted subset of rows rather than an entire dataset. This mechanism is fundamental for creating efficient, reusable, and context-sensitive formulas in areas like payroll calculations, benefits administration, and HR policies, where data retrieval must be precisely scoped.

Key Information Stored

The table's structure is designed to manage parameter definitions for ROUTEs. Its primary columns, as indicated by the primary and unique keys, are critical for integrity and functionality. The ROUTE_PARAMETER_ID column serves as the unique primary key identifier for each parameter record. The ROUTE_ID column is a foreign key linking the parameter to its parent ROUTE definition in the FF_ROUTES table. The PARAMETER_NAME column stores the actual name of the parameter as used within the FastFormula logic. The SEQUENCE_NO column dictates the order in which parameters are evaluated or must be supplied. Collectively, these columns ensure that each parameter is uniquely defined for a specific ROUTE and can be referenced in the correct sequence.

Common Use Cases and Queries

The primary use case is the design and analysis of complex FastFormulas. Developers and functional consultants query this table to understand the required inputs for a specific ROUTE before embedding it in a formula. A common analytical query joins FF_ROUTE_PARAMETERS to FF_ROUTES to list all parameters for all ROUTEs or for a specific ROUTE of interest. For instance, to audit parameters for a ROUTE named 'GET_EMPLOYEE_DETAILS', one might execute: SELECT frp.parameter_name, frp.sequence_no FROM ff_route_parameters frp, ff_routes fr WHERE frp.route_id = fr.route_id AND fr.route_name = 'GET_EMPLOYEE_DETAILS' ORDER BY frp.sequence_no;. This information is essential for troubleshooting formula execution errors related to missing or incorrect parameter values.

Related Objects

FF_ROUTE_PARAMETERS sits at the center of a key relationship hierarchy within the FastFormula data model. It has documented foreign key relationships with two primary tables:

  • FF_ROUTES: This is the parent table. The FF_ROUTE_PARAMETERS.ROUTE_ID column references FF_ROUTES.ROUTE_ID. This link defines which ROUTE the parameter belongs to.
  • FF_ROUTE_PARAMETER_VALUES: This is a child table. The FF_ROUTE_PARAMETER_VALUES.ROUTE_PARAMETER_ID column references FF_ROUTE_PARAMETERS.ROUTE_PARAMETER_ID. This relationship stores the actual values that can be assigned to these parameters for specific contexts or formula executions.
These relationships enforce data integrity, ensuring parameters cannot exist without a defined ROUTE and that parameter values are stored against valid parameter definitions.

  • Table: FF_ROUTE_PARAMETERS 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_ROUTE_PARAMETERS,  object_name:FF_ROUTE_PARAMETERS,  status:VALID,  product: FF - FastFormula ,  description: Parameters that can be passed to a ROUTE to restrict the number of rows returned by the ROUTE. ,  implementation_dba_data: HR.FF_ROUTE_PARAMETERS , 

  • Table: FF_ROUTE_PARAMETERS 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_ROUTE_PARAMETERS,  object_name:FF_ROUTE_PARAMETERS,  status:VALID,  product: FF - FastFormula ,  description: Parameters that can be passed to a ROUTE to restrict the number of rows returned by the ROUTE. ,  implementation_dba_data: HR.FF_ROUTE_PARAMETERS , 

  • Table: FF_ROUTE_PARAMETER_VALUES 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_ROUTE_PARAMETER_VALUES,  object_name:FF_ROUTE_PARAMETER_VALUES,  status:VALID,  product: FF - FastFormula ,  description: Values provided for route parameters by a database item. ,  implementation_dba_data: HR.FF_ROUTE_PARAMETER_VALUES , 

  • Table: FF_ROUTE_PARAMETER_VALUES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_ROUTE_PARAMETER_VALUES,  object_name:FF_ROUTE_PARAMETER_VALUES,  status:VALID,  product: FF - FastFormula ,  description: Values provided for route parameters by a database item. ,  implementation_dba_data: HR.FF_ROUTE_PARAMETER_VALUES , 

  • Table: FF_ROUTES 12.1.1

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_ROUTES,  object_name:FF_ROUTES,  status:VALID,  product: FF - FastFormula ,  description: FROM and WHERE clauses of a SQL statement for a specific database item. ,  implementation_dba_data: HR.FF_ROUTES , 

  • Table: FF_ROUTES 12.2.2

    owner:HR,  object_type:TABLE,  fnd_design_data:FF.FF_ROUTES,  object_name:FF_ROUTES,  status:VALID,  product: FF - FastFormula ,  description: FROM and WHERE clauses of a SQL statement for a specific database item. ,  implementation_dba_data: HR.FF_ROUTES ,