FF — FastFormula
23 documented tables · 23 views — Oracle EBS ETRM 12.2.2
Most-referenced tables
| Table | Description | Data Vault class* |
|---|---|---|
FF_ROUTES |
FROM and WHERE clauses of a SQL statement for a specific database item. | hub |
FF_FORMULA_TYPES |
Used to define groups of formulas to associate with formula contexts. | hub-leaning |
FF_USER_ENTITIES |
Table and selection criteria combination used to define database items. | hub-leaning |
FF_CONTEXTS |
Identifies the context for specific formulas, for example EMPLOYEE_ID. | hub |
FF_QP_REPORTS |
QuickPaint report definitions. | satellite-leaning |
FF_FUNCTIONS |
FastFormula Function definitions. | hub-leaning |
FF_ARCHIVE_ITEMS |
Archive recording results of evaluating database items. | satellite-leaning |
FF_ROUTE_PARAMETERS |
Parameters that can be passed to a ROUTE to restrict the number of rows returned by the ROUTE. | satellite-leaning |
FF_HARNESS |
Not currently used. | standalone |
FF_FDI_USAGES_F |
Compiler generated description of data items used in a formula. | satellite-leaning |
FF_ROUTE_CONTEXT_USAGES |
A single usage of a context as a bind variable in the ROUTE sql statement. | link |
FF_ARCHIVE_ITEM_CONTEXTS |
Context values for retrieving FF_ARCHIVE_ITEMS. | satellite-leaning |
FF_DATABASE_ITEMS |
Basic items of data in the application database. | satellite-leaning |
FF_DATABASE_ITEMS_TL |
Translated database item definitions. | satellite-leaning |
FF_FTYPE_CONTEXT_USAGES |
Contexts for a specific formula type. | link |
*Heuristic classification mined from FK structure — a modeling suggestion, not Oracle's.
Key public APIs
| Package | Class | Procedures | Used by |
|---|---|---|---|
FF_ARCHIVE_API |
API | 2 | 19 packages |
FF_FUNCTION_CONTEXT_USG_API |
API | 3 | 1 packages |
FF_FUNCTION_PARAMETERS_API |
API | 3 | 1 packages |
FF_FUNCTIONS_API |
API | 3 | 0 packages |
FF_GLOBALS_API |
API | 3 | 0 packages |