Results for “ff_route_parameter_values”

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

Overview

HR.FF_ROUTE_PARAMETER_VALUES is a FastFormula (FF) configuration table in Oracle EBS 12.1.1 and 12.2.2. It stores the concrete values that a database item supplies for the route parameters defined on a formula route. Whereas FF_ROUTE_PARAMETERS declares which parameters a route expects, FF_ROUTE_PARAMETER_VALUES records which database item provides each value, binding formula logic to application data at runtime. The table resides in the HR schema and carries a VALID status in the ETRM registry.

From the documented foreign-key topology, the heuristic Data Vault classification for this object is link: it resolves a many-to-many association between route parameters and user entities without holding descriptive history of its own. This is a modeling suggestion derived from the key structure rather than a declared classification.

Key Information Stored

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

• ROUTE_PARAMETER_ID — identifies the route parameter for which a value is being supplied; part of the composite primary key and a foreign key to FF_ROUTE_PARAMETERS.
• USER_ENTITY_ID — identifies the database item (user entity) that provides the value; the second half of the composite primary key and a foreign key to FF_USER_ENTITIES.
• VALUE — the actual value, expression, or reference returned by the database item for the route parameter.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS audit trail capturing when, by whom, and through which login session the row was last modified.
• CREATED_BY, CREATION_DATE — the standard creation audit columns recording the originating user and timestamp.

The surrogate/compound primary key FF_ROUTE_PARAMETER_VALUES_PK is defined on (ROUTE_PARAMETER_ID, USER_ENTITY_ID). No separate unique index independent of this PK is documented, so the PK columns themselves serve as the business-key candidate: a route parameter may be supplied by a given user entity only once. There is no single-column surrogate identifier.

Common Use Cases and Queries

This table is primarily consulted when diagnosing FastFormula behavior — for example, determining why a payroll or benefits formula receives an unexpected input, or tracing which database item feeds a given route parameter.

SELECT rpv.ROUTE_PARAMETER_ID,
       rpv.USER_ENTITY_ID,
       rpv.VALUE
FROM   HR.FF_ROUTE_PARAMETER_VALUES rpv
WHERE  rpv.ROUTE_PARAMETER_ID = :p_route_parameter_id;

Joining to the parent definitions lets developers list all parameter-to-source bindings for a route:

SELECT rp.PARAMETER_NAME,
       fue.USER_ENTITY_NAME,
       rpv.VALUE
FROM   HR.FF_ROUTE_PARAMETER_VALUES rpv,
       HR.FF_ROUTE_PARAMETERS      rp,
       HR.FF_USER_ENTITIES         fue
WHERE  rpv.ROUTE_PARAMETER_ID = rp.ROUTE_PARAMETER_ID(+)
AND    rpv.USER_ENTITY_ID     = fue.USER_ENTITY_ID(+);

Reporting use cases include auditing which database items are actively bound across all routes, identifying stale or unreferenced bindings, and validating formula migration between environments. Because the table is configuration data, extracts are typically performed through the documented tables rather than direct DML, and any changes should follow Oracle's supported FastFormula setup paths to preserve referential integrity.

Related Objects

• FF_ROUTE_PARAMETERS — parent definition of each route parameter; joined via FF_ROUTE_PARAMETER_VALUES.ROUTE_PARAMETER_ID = FF_ROUTE_PARAMETERS.ROUTE_PARAMETER_ID.
• FF_USER_ENTITIES — catalog of database items; joined via FF_ROUTE_PARAMETER_VALUES.USER_ENTITY_ID = FF_USER_ENTITIES.USER_ENTITY_ID.
• FF_ROUTES — the route to which parameters belong, reached through FF_ROUTE_PARAMETERS.
• FF_FORMULAS — the formula associated with each route, used to contextualize parameter bindings.
• FF_DATABASE_ITEMS — related definitional data for database item resolution used alongside user entities.

These objects, together with the two declared foreign keys, form the core reference set for interpreting and maintaining FastFormula route parameter values.