Search Results ff_fdi_usages_f_pk

Overview

The FF_FDI_USAGES_F table is a core technical repository within the Oracle E-Business Suite FastFormula (FF) module. It functions as a compiler-generated metadata table, automatically populated and maintained by the FastFormula engine. Its primary role is to store a detailed description of all data items, also known as Formula Data Items (FDIs), that are referenced within a specific formula. This table is critical for the system's understanding of formula dependencies, data lineage, and the validation of inputs and outputs during formula compilation and execution. It acts as a central catalog linking formulas to the specific business or legislative data elements they consume.

Key Information Stored

The table records the usage context of each data item per formula across effective-dated periods. Its structure, as defined by its primary key, ensures a unique record for each combination of formula, data item name, and effective date range. Key columns include FORMULA_ID, which links to the parent formula definition; ITEM_NAME, which holds the identifier of the referenced data item (e.g., a database item, context value, or global variable); and EFFECTIVE_START_DATE and EFFECTIVE_END_DATE, which define the period for which this usage is valid. The ROUTE_ID column, as indicated by the foreign key relationship, associates the data item usage with a specific processing context or legislative route within the FastFormula architecture.

Common Use Cases and Queries

This table is predominantly used for impact analysis, troubleshooting, and system audits. Technical consultants and developers query it to identify all formulas that depend on a particular data item, which is essential when modifying legislative rules or underlying database items. A common reporting use case involves generating a formula's bill of materials. A sample query to list all data items used by a specific formula would be: SELECT item_name, effective_start_date, effective_end_date FROM ff_fdi_usages_f WHERE formula_id = <formula_id> ORDER BY item_name;. Another critical scenario is cleaning up or analyzing formulas during a migration or upgrade, where understanding cross-formula dependencies on obsolete items is necessary.

Related Objects

The FF_FDI_USAGES_F table has a direct and documented foreign key relationship with the FF_ROUTES table. The join is performed on the ROUTE_ID column (FF_FDI_USAGES_F.ROUTE_ID references FF_ROUTES). This relationship ties the usage of a data item to a specific legislative or processing route. The table's primary key (FF_FDI_USAGES_F_PK) is itself a composite key based on FORMULA_ID, ITEM_NAME, EFFECTIVE_START_DATE, and EFFECTIVE_END_DATE. While not listed in the provided metadata, this table is fundamentally linked to the core formula definition table, FF_FORMULAS_F, via the FORMULA_ID column, and to the data item definition table, FF_DATABASE_ITEMS, via the ITEM_NAME.