Oracle eBusiness Suite Technical Reference

Release 11i - Copyright (c) 2001 - 2005 Oracle

This Technical Reference Manual (TRM) in any form, software or printed matter, contains proprietary information of Oracle ; it is provided under an Oracle agreement containing restrictions on use and disclosure and is also protected by copyright, patent, and other intellectual property law. Restrictions applicable to this TRM include, but are not limited to: (a) exercising either the same degree of care to safeguard the confidentiality of this TRM as you exercise to safeguard the confidentiality of your own most important Confidential Information or a reasonable degree of care, whichever is greater; (b) maintaining agreements with your employees and agents that protect the Confidential Information of third parties such as Oracle and instructing such employees and agents of these requirements for this TRM; (c) restricting disclosure of this TRM to those of your employees who have a 'need to know' consistent with the purposes for which this TRM was disclosed to you; (d) maintaining this TRM at all times on your premises; (e) not removing or destroying any proprietary or confidential legends or markings placed upon this TRM in whatever form, software or printed matter; and (f) not reproducing or transmitting this TRM in any form or by any means, electronic or mechanical, for any purpose, without the express written permission of Oracle. You should not use this TRM in any form, software or printed matter, to create software that performs the same or similar functions as any Oracle products.

The information in this TRM is subject to change without notice. If you find any problems in the TRM in any form, software or printed matter, please report them to us in writing. Oracle does not warrant that this TRM is error free. This TRM is provided to customer 'as is' with no warranty of any kind. This TRM does not constitute Documentation as that term is defined in Oracle's agreements. Reverse engineering of the Programs (software and documentation) associated with this TRM are prohibited. The Programs associated with this TRM are not intended for use in any nuclear, aviation, mass transit, medical, or other inherently dangerous applications. It shall be licensee's responsibility to take all appropriate fail safe, backup, redundancy and other measures to ensure the safe use of such applications if the Programs are used for such purposes, and Oracle disclaims liability for any damages caused by such use of the Programs. Program Documentation is licensed for use solely to support the deployment of the Programs and not for any other any other purpose. Restricted Rights Legend

This TRM and the Programs associated with this TRM delivered subject to the DOD FAR Supplement are 'commercial computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the licensing restrictions set forth in the applicable Oracle license agreement. Otherwise, this TRM and the Programs associated with this TRM delivered subject to the Federal Acquisition Regulations are 'restricted computer software' and use, duplication and disclosure of the TRM and the Programs associated with this TRM shall be subject to the restrictions in FAR 52.227-14, Rights in Data General, including Alternate III (June 1987). Oracle, 500 Oracle Parkway, Redwood City, CA 94065.

Oracle is a registered trademark. AIM Advantage™, Big Business. Small Business. All Business.™, CDM Advantage™, .comference™, ConText®, Des40®, Easy*Query™, Easy*SQL®, Education Objects™, EMM Advantage™, Enabling the Information Age®, ExpertDetectSM, Express®, FastForwardSM, GEMMS®, Gist™, Hyper*SQL™, instantOracle™, "Internet Business Intelligence - Insight for Everyone"™, iSQL*Plus™, JInitiator™, NLS*Workbench®, Object Marketplace™, ODP Pulse™, ODP Techwire™, OLA™, On Oracle™, Oracle®, Oracle Book®, Oracle Bookbatch®, Oracle BookBuilder®, OracleBRONZE®, Oracle Business OnLine®, OracleDevConnectSM, Oracle® Discoverer™, Oracle® Expert™, Oracle Financials®, OracleGOLDSM, OracleIncidentSM, OracleJSP™, OracleLifeCycleSM, Oracle Media Objects®, OracleMERCURYSM, OracleMetaLinkSM, OraclemetalsSM, OracleMobile™, Oracle Names®, Oracle NetSolutions®, Oracle® One™, Oracle Open Gateways®, Oracle OpenWorld®, OraclePLATINUMSM, Oracle Power Objects®, Oracle Press®, Oracle Procedural Gateway®, Oracle Quality®, Oracle Secure Network Services®, OracleSILVERSM, Oracle® SQL/Services™, Oracle® SQL*TutorSM, OracleSTERLINGSM, Oracle Store®, Oracle Transparent Gateway®, OracleWare®, Oracle8i™, Oracle9i™, PC Express®, Personal Express®, PJM Advantage™, PL/SQL™, Pro*Ada®, Pro*C™, Pro*C/C++™, Pro*COBOL®, Pro*FORTRAN®, Pro*Pascal®, Pro*PL/1®, Pro*REXX®, Profit™, ProREXX™, Report Card™, Secure Access 2.0™, Secure Network Services®, Security Without Compromise™, SellingPoint®, SQL*Plus®, Tutor™ are trademarks or registered trademarks of Oracle. Other names may be trademarks of their respective owners. The absence of a product or service name, slogan, or logo from this list does not constitute a waiver of Oracle's trademark or other intellectual property rights concerning that name, slogan, or logo.

eTRM - FF Tables and Views

TABLE - HR.FF_ARCHIVE_ITEMS

TABLE - HR.FF_ARCHIVE_ITEM_CONTEXTS

TABLE - HR.FF_COMPILED_INFO_F

TABLE - HR.FF_CONTEXTS

TABLE - HR.FF_DATABASE_ITEMS

TABLE - HR.FF_DATABASE_ITEMS_TL

TABLE - HR.FF_FDI_USAGES_F

TABLE - HR.FF_FORMULAS_F

TABLE - HR.FF_FORMULA_TYPES

TABLE - HR.FF_FORMULA_TYPE_COMPONENTS

TABLE - HR.FF_FTYPE_CONTEXT_USAGES

TABLE - HR.FF_FUNCTIONS

TABLE - HR.FF_FUNCTION_CONTEXT_USAGES

TABLE - HR.FF_FUNCTION_PARAMETERS

TABLE - HR.FF_GLOBALS_F

TABLE - HR.FF_HARNESS

TABLE - HR.FF_LOOKUPS

TABLE - HR.FF_QP_REPORTS

TABLE - HR.FF_ROUTES

TABLE - HR.FF_ROUTE_CONTEXT_USAGES

TABLE - HR.FF_ROUTE_PARAMETERS

TABLE - HR.FF_ROUTE_PARAMETER_VALUES

TABLE - HR.FF_USER_ENTITIES

VIEW - APPS.FFBV_CONTEXT

VIEW - APPS.FFBV_FORMULA

VIEW - APPS.FFBV_FORMULA_TYPE

VIEW - APPS.FF_ARCHIVE_ITEMS_V

VIEW - APPS.FF_ARCHIVE_ITEM_CONTEXTS_V

VIEW - APPS.FF_COMPILED_INFO

VIEW - APPS.FF_COMPILED_INFO_X

VIEW - APPS.FF_DATABASE_ITEMS_V

VIEW - APPS.FF_DATABASE_ITEMS_VL

VIEW - APPS.FF_DATABASE_ITEMS_VL1

VIEW - APPS.FF_DATABASE_ITEMS_VL2

VIEW - APPS.FF_FDI_USAGES

VIEW - APPS.FF_FDI_USAGES_X

VIEW - APPS.FF_FORMULAS

VIEW - APPS.FF_FORMULAS_F_V

VIEW - APPS.FF_FORMULAS_LOV

VIEW - APPS.FF_FORMULAS_X

VIEW - APPS.FF_FUNCTIONS_V

VIEW - APPS.FF_FUNCTION_CONTEXT_USAGES_V

VIEW - APPS.FF_FUNCTION_PARAMETERS_V

VIEW - APPS.FF_GLOBALS

VIEW - APPS.FF_GLOBALS_F_V

VIEW - APPS.FF_GLOBALS_X

Table: FF_ARCHIVE_ITEMS

Primary Key: FF_ARCHIVE_ITEMS_PK

1. ARCHIVE_ITEM_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

FF_ARCHIVE_ITEMS records a snapshot of what particular database
items evaluate to on a run of a Fastformula based magnetic tape
report.

Primary Key: FF_ARCHIVE_ITEMS_PK

1. ARCHIVE_ITEM_ID

Indexes

Columns

[top of page]

HR.FF_ARCHIVE_ITEMS does not reference any database object

HR.FF_ARCHIVE_ITEMS is referenced by following:

APPS

SYNONYM - FF_ARCHIVE_ITEMS

TRIGGER - FF_ARCHIVE_ITEMS_BRU

TRIGGER - FF_ARCHIVE_ITEMS_WHO

PUBLIC

SYNONYM - FF_ARCHIVE_ITEMS

[top of page]

Table: FF_ARCHIVE_ITEM_CONTEXTS

Primary Key: FF_ARCHIVE_ITEM_CONTEXT_PK

1. ARCHIVE_ITEM_ID
2. CONTEXT_ID

Foreign Keys from this table:

Comments

FF_ARCHIVE_ITEM_CONTEXTS records any additional context required to
retrieve an archive item e.g. a tax unit.

Primary Key: FF_ARCHIVE_ITEM_CONTEXT_PK

1. ARCHIVE_ITEM_ID
2. CONTEXT_ID

Indexes

Columns

[top of page]

HR.FF_ARCHIVE_ITEM_CONTEXTS does not reference any database object

HR.FF_ARCHIVE_ITEM_CONTEXTS is referenced by following:

APPS

SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS

PUBLIC

SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS

[top of page]

Table: FF_COMPILED_INFO_F

Primary Key: FF_COMPILED_INFO_F_PK

1. FORMULA_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Comments

FF_COMPILED_INFO_F is a DateTracked table that holds the executable
code run by the FastFormula execution engine. This is a PL/SQL
program that is generated by the FastFormula compiler.

Primary Key: FF_COMPILED_INFO_F_PK

1. FORMULA_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Indexes

Columns

[top of page]

HR.FF_COMPILED_INFO_F does not reference any database object

HR.FF_COMPILED_INFO_F is referenced by following:

APPS

SYNONYM - FF_COMPILED_INFO_F

PUBLIC

SYNONYM - FF_COMPILED_INFO_F

[top of page]

Table: FF_CONTEXTS

Primary Key: FF_CONTEXTS_PK

1. CONTEXT_ID

Primary Key: FF_CONTEXTS_UK2

1. CONTEXT_NAME

Foreign Keys to this table:

Comments

FF_CONTEXTS holds details of the contexts that can be passed into a
formula to describe the objects the formula can act on. Each
context is a unique identifier within an application such as
employee or assignment number.

Primary Key: FF_CONTEXTS_PK

1. CONTEXT_ID

Unique Key: FF_CONTEXTS_UK2

1. CONTEXT_NAME

Indexes

Columns

[top of page]

HR.FF_CONTEXTS does not reference any database object

HR.FF_CONTEXTS is referenced by following:

APPS

SYNONYM - FF_CONTEXTS

TRIGGER - FF_CONTEXTS_BRD

TRIGGER - FF_CONTEXTS_BRI

TRIGGER - FF_CONTEXTS_BRU

PUBLIC

SYNONYM - FF_CONTEXTS

[top of page]

Table: FF_DATABASE_ITEMS

Primary Key: FF_DATABASE_ITEMS_PK

1. USER_NAME
2. USER_ENTITY_ID

Foreign Keys from this table:

Comments

FF_DATABASE_ITEMS holds the definitions of database items that can
be used in formulas. Database items are short names that a user can
use to identify a specific item of data in the database without
knowing specific table or column details. The formula must provide a
sufficient context to enable the select item clause to find the
specific data item. For example, formulas of a type that provide the
context EMPLOYEE_ID might access database items such as EMPLOYEE_NAME
or MANAGER_NAME.

Primary Key: FF_DATABASE_ITEMS_PK

1. USER_NAME
2. USER_ENTITY_ID

Indexes

Columns

[top of page]

HR.FF_DATABASE_ITEMS does not reference any database object

HR.FF_DATABASE_ITEMS is referenced by following:

APPS

SYNONYM - FF_DATABASE_ITEMS

TRIGGER - FF_DATABASE_ITEMS_ARI

TRIGGER - FF_DATABASE_ITEMS_BRD

TRIGGER - FF_DATABASE_ITEMS_BRI

TRIGGER - FF_DATABASE_ITEMS_BRU

TRIGGER - FF_DATABASE_ITEMS_WHO

PUBLIC

SYNONYM - FF_DATABASE_ITEMS

[top of page]

Table: FF_DATABASE_ITEMS_TL

Primary Key: FF_DATABASE_ITEMS_TL_PK

1. USER_NAME
2. USER_ENTITY_ID
3. LANGUAGE

Foreign Keys from this table:

Comments

FF_DATABASE_ITEMS_TL holds the translated database item definitions.

Indexes

Columns

[top of page]

HR.FF_DATABASE_ITEMS_TL does not reference any database object

HR.FF_DATABASE_ITEMS_TL is referenced by following:

APPS

SYNONYM - FF_DATABASE_ITEMS_TL

TRIGGER - FF_DATABASE_ITEMS_TL041416_WHO

PUBLIC

SYNONYM - FF_DATABASE_ITEMS_TL

[top of page]

Table: FF_FDI_USAGES_F

Primary Key: FF_FDI_USAGES_F_PK

1. FORMULA_ID
2. ITEM_NAME
3. EFFECTIVE_START_DATE
4. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

FF_FDI_USAGES_F is a DateTracked table that holds one entry for
every data item used in a specific formula. It is generated by the
FastFormula compiler from the user defined formula.

Primary Key: FF_FDI_USAGES_F_PK

1. FORMULA_ID
2. ITEM_NAME
3. EFFECTIVE_START_DATE
4. EFFECTIVE_END_DATE

Indexes

Columns

[top of page]

HR.FF_FDI_USAGES_F does not reference any database object

HR.FF_FDI_USAGES_F is referenced by following:

APPS

SYNONYM - FF_FDI_USAGES_F

PUBLIC

SYNONYM - FF_FDI_USAGES_F

[top of page]

Table: FF_FORMULAS_F

Primary Key: FF_FORMULAS_F_PK

1. FORMULA_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Primary Key: FF_FORMULAS_F_UK2

1. FORMULA_NAME
2. FORMULA_TYPE_ID
3. BUSINESS_GROUP_ID
4. LEGISLATION_CODE
5. EFFECTIVE_START_DATE
6. EFFECTIVE_END_DATE

Foreign Keys from this table:

Comments

FF_FORMULAS_F is the DateTracked table that holds formula definitions,
including formula text.

Primary Key: FF_FORMULAS_F_PK

1. FORMULA_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Unique Key: FF_FORMULAS_F_UK2

1. FORMULA_NAME
2. FORMULA_TYPE_ID
3. BUSINESS_GROUP_ID
4. LEGISLATION_CODE
5. EFFECTIVE_START_DATE
6. EFFECTIVE_END_DATE

Indexes

Columns

[top of page]

HR.FF_FORMULAS_F does not reference any database object

HR.FF_FORMULAS_F is referenced by following:

APPS

SYNONYM - FF_FORMULAS_F

TRIGGER - FF_FORMULAS_F_BRI

TRIGGER - FF_FORMULAS_F_BRU

TRIGGER - FF_FORMULAS_F_MNT_TL_ARI

TRIGGER - FF_FORMULAS_F_MNT_TL_ARU

TRIGGER - FF_FORMULAS_F_MNT_TL_ASD

TRIGGER - FF_FORMULAS_F_MNT_TL_ASI

TRIGGER - FF_FORMULAS_F_MNT_TL_BRD

TRIGGER - FF_FORMULAS_F_WHO

PUBLIC

SYNONYM - FF_FORMULAS_F

[top of page]

Table: FF_FORMULA_TYPES

Primary Key: FF_FORMULA_TYPES_PK

1. FORMULA_TYPE_ID

Primary Key: FF_FORMULA_TYPES_UK2

1. FORMULA_TYPE_NAME

Foreign Keys to this table:

Comments

FF_FORMULA_TYPES holds the definition of formula types, for
example, Oracle Payroll, Input Value Validation, Assignment Set. The
type defines a group of formulas and is used with FF_CONTEXTS to
identify the database items available to a specific formula.

Primary Key: FF_FORMULA_TYPES_PK

1. FORMULA_TYPE_ID

Unique Key: FF_FORMULA_TYPES_UK2

1. FORMULA_TYPE_NAME

Indexes

Columns

[top of page]

HR.FF_FORMULA_TYPES does not reference any database object

HR.FF_FORMULA_TYPES is referenced by following:

APPS

SYNONYM - FF_FORMULA_TYPES

TRIGGER - FF_FORMULA_TYPES_WHO

PUBLIC

SYNONYM - FF_FORMULA_TYPES

[top of page]

Table: FF_FORMULA_TYPE_COMPONENTS

Primary Key: FF_FORMULA_TYPE_COMPONENTS_PK

1. COMPONENT_ID

Foreign Keys from this table:

Comments

FF_FORMULA_TYPE_COMPONENTS holds details of components, such as inputs and outputs, associated with a formula type.

Indexes

Columns

[top of page]

HR.FF_FORMULA_TYPE_COMPONENTS does not reference any database object

HR.FF_FORMULA_TYPE_COMPONENTS is referenced by following:

APPS

SYNONYM - FF_FORMULA_TYPE_COMPONENTS

TRIGGER - FF_FORMULA_TYPE_COMPONENTS_WHO

PUBLIC

SYNONYM - FF_FORMULA_TYPE_COMPONENTS

[top of page]

Table: FF_FTYPE_CONTEXT_USAGES

Primary Key: FF_FTYPE_CONTEXT_USAGES_PK

1. FORMULA_TYPE_ID
2. CONTEXT_ID

Foreign Keys from this table:

Comments

FF_FTYPE_CONTEXT_USAGES is an intersection table that holds the
list of contexts available to a specific formula type. This list
determines which database items are available to a specific formula.

Primary Key: FF_FTYPE_CONTEXT_USAGES_PK

1. FORMULA_TYPE_ID
2. CONTEXT_ID

Indexes

Columns

[top of page]

HR.FF_FTYPE_CONTEXT_USAGES does not reference any database object

HR.FF_FTYPE_CONTEXT_USAGES is referenced by following:

APPS

SYNONYM - FF_FTYPE_CONTEXT_USAGES

TRIGGER - FF_FTYPE_CONTEXT_USAGES_BRD

TRIGGER - FF_FTYPE_CONTEXT_USAGES_BRU

PUBLIC

SYNONYM - FF_FTYPE_CONTEXT_USAGES

[top of page]

Table: FF_FUNCTIONS

Primary Key: FF_FUNCTIONS_PK

1. FUNCTION_ID

Foreign Keys to this table:

Comments

FF_FUNCTIONS holds the definitions of user defined functions that can
be called from a formula. For user defined functions the DEFINITION
is the name of the function within the PL/SQL package as it is stored
in the database.

Primary Key: FF_FUNCTIONS_PK

1. FUNCTION_ID

Indexes

Columns

[top of page]

HR.FF_FUNCTIONS does not reference any database object

HR.FF_FUNCTIONS is referenced by following:

APPS

SYNONYM - FF_FUNCTIONS

TRIGGER - FF_FUNCTIONS_BRI

TRIGGER - FF_FUNCTIONS_BRU

TRIGGER - FF_FUNCTIONS_OVN

TRIGGER - FF_FUNCTIONS_WHO

PUBLIC

SYNONYM - FF_FUNCTIONS

[top of page]

Table: FF_FUNCTION_CONTEXT_USAGES

Primary Key: FF_FUNCTION_CONTEXT_USAGES_PK

1. FUNCTION_ID
2. SEQUENCE_NUMBER

Primary Key: FF_FUNCTION_CONTEXT_USAGES_UK2

1. FUNCTION_ID
2. CONTEXT_ID

Foreign Keys from this table:

Comments

FF_FUNCTION_CONTEXT_USAGES describes the contexts which are
required by a function. Contexts are passed to the function before
any function parameters.

Primary Key: FF_FUNCTION_CONTEXT_USAGES_PK

1. FUNCTION_ID
2. SEQUENCE_NUMBER

Unique Key: FF_FUNCTION_CONTEXT_USAGES_UK2

1. FUNCTION_ID
2. CONTEXT_ID

Indexes

Columns

[top of page]

HR.FF_FUNCTION_CONTEXT_USAGES does not reference any database object

HR.FF_FUNCTION_CONTEXT_USAGES is referenced by following:

APPS

SYNONYM - FF_FUNCTION_CONTEXT_USAGES

TRIGGER - FF_FUNCTION_CONTEXT_USAGES_OVN

TRIGGER - FF_FUNCTION_CONTEXT_USAGES_WHO

PUBLIC

SYNONYM - FF_FUNCTION_CONTEXT_USAGES

[top of page]

Table: FF_FUNCTION_PARAMETERS

Primary Key: FF_FUNCTION_PARAMETERS_PK

1. FUNCTION_ID
2. SEQUENCE_NUMBER

Primary Key: FF_FUNCTION_PARAMETERS_UK2

1. FUNCTION_ID
2. NAME

Foreign Keys from this table:

Comments

FF_FUNCTION_PARAMETERS holds the definitions for the parameters
of a specific FastFormula function.

Primary Key: FF_FUNCTION_PARAMETERS_PK

1. FUNCTION_ID
2. SEQUENCE_NUMBER

Unique Key: FF_FUNCTION_PARAMETERS_UK2

1. FUNCTION_ID
2. NAME

Indexes

Columns

[top of page]

HR.FF_FUNCTION_PARAMETERS does not reference any database object

HR.FF_FUNCTION_PARAMETERS is referenced by following:

APPS

SYNONYM - FF_FUNCTION_PARAMETERS

TRIGGER - FF_FUNCTION_PARAMETERS_OVN

TRIGGER - FF_FUNCTION_PARAMETERS_WHO

PUBLIC

SYNONYM - FF_FUNCTION_PARAMETERS

[top of page]

Table: FF_GLOBALS_F

Primary Key: FF_GLOBALS_F_PK

1. GLOBAL_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Primary Key: FF_GLOBALS_F_UK2

1. GLOBAL_NAME
2. BUSINESS_GROUP_ID
3. LEGISLATION_CODE
4. EFFECTIVE_START_DATE
5. EFFECTIVE_END_DATE

Comments

FF_GLOBALS_F is a DateTracked table which holds the definitions and
actual values for global values. Global values are enterprise level
data items that are available to all formulas.

Primary Key: FF_GLOBALS_F_PK

1. GLOBAL_ID
2. EFFECTIVE_START_DATE
3. EFFECTIVE_END_DATE

Unique Key: FF_GLOBALS_F_UK2

1. GLOBAL_NAME
2. BUSINESS_GROUP_ID
3. LEGISLATION_CODE
4. EFFECTIVE_START_DATE
5. EFFECTIVE_END_DATE

Indexes

Columns

[top of page]

HR.FF_GLOBALS_F does not reference any database object

HR.FF_GLOBALS_F is referenced by following:

APPS

SYNONYM - FF_GLOBALS_F

TRIGGER - FF_GLOBALS_F_AD

TRIGGER - FF_GLOBALS_F_ASD

TRIGGER - FF_GLOBALS_F_BD

TRIGGER - FF_GLOBALS_F_BRD

TRIGGER - FF_GLOBALS_F_BRI

TRIGGER - FF_GLOBALS_F_BRU

TRIGGER - FF_GLOBALS_F_BSD

TRIGGER - FF_GLOBALS_F_MNT_TL_ARI

TRIGGER - FF_GLOBALS_F_MNT_TL_ARU

TRIGGER - FF_GLOBALS_F_MNT_TL_ASD

TRIGGER - FF_GLOBALS_F_MNT_TL_ASI

TRIGGER - FF_GLOBALS_F_MNT_TL_BRD

TRIGGER - FF_GLOBALS_F_OVN

TRIGGER - FF_GLOBALS_F_WHO

PUBLIC

SYNONYM - FF_GLOBALS_F

[top of page]

Table: FF_HARNESS

Primary Key: FF_HARNESS_PK

1. TEST_ID
2. FORMULA_ID
3. ITEM_NAME
4. USAGE

Comments

***** Warning: Oracle Internal Use Only *****

Oracle Corporation does not support access to Oracle applications data using this object, except from standard Oracle Applications programs.

Primary Key: FF_HARNESS_PK

1. TEST_ID
2. FORMULA_ID
3. ITEM_NAME
4. USAGE

Indexes

Columns

[top of page]

HR.FF_HARNESS does not reference any database object

HR.FF_HARNESS is referenced by following:

APPS

SYNONYM - FF_HARNESS

TRIGGER - FF_HARNESS_WHO

PUBLIC

SYNONYM - FF_HARNESS

[top of page]

Table: FF_LOOKUPS

Primary Key: FF_LOOKUPS_PK

1. LOOKUP_TYPE
2. LOOKUP_CODE

Comments

FF_LOOKUPS holds lookups that are used specifically for FastFormula.

Primary Key: FF_LOOKUPS_PK

1. LOOKUP_TYPE
2. LOOKUP_CODE

Indexes

Columns

[top of page]

HR.FF_LOOKUPS does not reference any database object

HR.FF_LOOKUPS is referenced by following:

APPS

SYNONYM - FF_LOOKUPS

TRIGGER - FF_LOOKUPS_WHO

PUBLIC

SYNONYM - FF_LOOKUPS

[top of page]

Table: FF_QP_REPORTS

Primary Key: FF_QP_REPORTS_PK

1. QP_REPORT_ID

Primary Key: FF_QP_REPORTS_UK2

1. QP_REPORT_NAME
2. FORMULA_TYPE_ID
3. BUSINESS_GROUP_ID
4. LEGISLATION_CODE

Foreign Keys from this table:

Foreign Keys to this table:

Comments

FF_QP_REPORTS contains the text of any user defined QuickPaint
reports.

Primary Key: FF_QP_REPORTS_PK

1. QP_REPORT_ID

Unique Key: FF_QP_REPORTS_UK2

1. QP_REPORT_NAME
2. FORMULA_TYPE_ID
3. BUSINESS_GROUP_ID
4. LEGISLATION_CODE

Indexes

Columns

[top of page]

HR.FF_QP_REPORTS does not reference any database object

HR.FF_QP_REPORTS is referenced by following:

APPS

SYNONYM - FF_QP_REPORTS

TRIGGER - FF_QP_REPORTS_WHO

PUBLIC

SYNONYM - FF_QP_REPORTS

[top of page]

Table: FF_ROUTES

Primary Key: FF_ROUTES_PK

1. ROUTE_ID

Primary Key: FF_ROUTES_UK2

1. ROUTE_NAME

Foreign Keys to this table:

Comments

FF_ROUTES holds the route definitions that are the FROM and WHERE
clauses of a SQL statement that describe how to access a specific data
item. The complete statement combines this with the definition text
on the database item.

Primary Key: FF_ROUTES_PK

1. ROUTE_ID

Unique Key: FF_ROUTES_UK2

1. ROUTE_NAME

Indexes

Columns

[top of page]

HR.FF_ROUTES does not reference any database object

HR.FF_ROUTES is referenced by following:

APPS

SYNONYM - FF_ROUTES

TRIGGER - FF_ROUTES_WHO

PUBLIC

SYNONYM - FF_ROUTES

[top of page]

Table: FF_ROUTE_CONTEXT_USAGES

Primary Key: FF_ROUTE_CONTEXT_USAGES_PK

1. ROUTE_ID
2. CONTEXT_ID

Primary Key: FF_ROUTE_CONTEXT_USAGES_UK2

1. ROUTE_ID
2. SEQUENCE_NO

Foreign Keys from this table:

Comments

FF_ROUTE_CONTEXT_USAGES holds the single usage of a context as a
bind variable in the ROUTE SQL statement.

Primary Key: FF_ROUTE_CONTEXT_USAGES_PK

1. ROUTE_ID
2. CONTEXT_ID

Unique Key: FF_ROUTE_CONTEXT_USAGES_UK2

1. ROUTE_ID
2. SEQUENCE_NO

Indexes

Columns

[top of page]

HR.FF_ROUTE_CONTEXT_USAGES does not reference any database object

HR.FF_ROUTE_CONTEXT_USAGES is referenced by following:

APPS

SYNONYM - FF_ROUTE_CONTEXT_USAGES

TRIGGER - FF_ROUTE_CONTEXT_USAGES_BRD

TRIGGER - FF_ROUTE_CONTEXT_USAGES_BRI

PUBLIC

SYNONYM - FF_ROUTE_CONTEXT_USAGES

[top of page]

Table: FF_ROUTE_PARAMETERS

Primary Key: FF_ROUTE_PARAMETERS_PK

1. ROUTE_PARAMETER_ID

Primary Key: FF_ROUTE_PARAMETERS_UK2

1. ROUTE_ID
2. SEQUENCE_NO

Primary Key: FF_ROUTE_PARAMETERS_UK3

1. PARAMETER_NAME
2. ROUTE_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

FF_ROUTE_PARAMETERS holds the parameters that can be passed to a
route and their sequence number when used by the route. These
restrict the number of rows returned by the route.

Primary Key: FF_ROUTE_PARAMETERS_PK

1. ROUTE_PARAMETER_ID

Unique Key: FF_ROUTE_PARAMETERS_UK2

1. ROUTE_ID
2. SEQUENCE_NO

Unique Key: FF_ROUTE_PARAMETERS_UK3

1. PARAMETER_NAME
2. ROUTE_ID

Indexes

Columns

[top of page]

HR.FF_ROUTE_PARAMETERS does not reference any database object

HR.FF_ROUTE_PARAMETERS is referenced by following:

APPS

SYNONYM - FF_ROUTE_PARAMETERS

TRIGGER - FF_ROUTE_PARAMETERS_BRI

TRIGGER - FF_ROUTE_PARAMETERS_BRUD

PUBLIC

SYNONYM - FF_ROUTE_PARAMETERS

[top of page]

Table: FF_ROUTE_PARAMETER_VALUES

Primary Key: FF_ROUTE_PARAMETER_VALUES_PK

1. ROUTE_PARAMETER_ID
2. USER_ENTITY_ID

Foreign Keys from this table:

Comments

FF_ROUTE_PARAMETER_VALUES holds the values provided for route
parameters by a database item identified by USER_ENTITY_ID.

Primary Key: FF_ROUTE_PARAMETER_VALUES_PK

1. ROUTE_PARAMETER_ID
2. USER_ENTITY_ID

Indexes

Columns

[top of page]

HR.FF_ROUTE_PARAMETER_VALUES does not reference any database object

HR.FF_ROUTE_PARAMETER_VALUES is referenced by following:

APPS

SYNONYM - FF_ROUTE_PARAMETER_VALUES

TRIGGER - FF_ROUTE_PARAMETER_VALUES_WHO

TRIGGER - FF_RPV_BRI

TRIGGER - FF_RPV_BRUD

PUBLIC

SYNONYM - FF_ROUTE_PARAMETER_VALUES

[top of page]

Table: FF_USER_ENTITIES

Primary Key: FF_USER_ENTITIES_PK

1. USER_ENTITY_ID

Foreign Keys from this table:

Foreign Keys to this table:

Comments

FF_USER_ENTITIES holds the specific table and selection criteria
combination that are used in the definition of a database item.

Primary Key: FF_USER_ENTITIES_PK

1. USER_ENTITY_ID

Indexes

Columns

[top of page]

HR.FF_USER_ENTITIES does not reference any database object

HR.FF_USER_ENTITIES is referenced by following:

APPS

SYNONYM - FF_USER_ENTITIES

TRIGGER - FF_USER_ENTITIES_ARD

TRIGGER - FF_USER_ENTITIES_BRD

TRIGGER - FF_USER_ENTITIES_BRI

TRIGGER - FF_USER_ENTITIES_BRU

TRIGGER - FF_USER_ENTITIES_WHO

PUBLIC

SYNONYM - FF_USER_ENTITIES

[top of page]

View: FFBV_CONTEXT

Comments

View Type

A Business Intelligence System view

Columns

[top of page]

APPS

SYNONYM - FF_CONTEXTS

PACKAGE - HR_BIS

PUBLIC

SYNONYM - FFBV_CONTEXT

[top of page]

View: FFBV_FORMULA

Comments

View Type

A Business Intelligence System view

Discoverer view for ff_formulas_f

Columns

[top of page]

APPS

SYNONYM - FF_FORMULAS_F

PACKAGE - HR_BIS

PUBLIC

SYNONYM - FFBV_FORMULA

[top of page]

View: FFBV_FORMULA_TYPE

Comments

View Type

A Business Intelligence System view

Discoverer view for ff_formula_types.

Columns

[top of page]

APPS

SYNONYM - FF_FORMULA_TYPES

PACKAGE - HR_BIS

PUBLIC

SYNONYM - FFBV_FORMULA_TYPE

[top of page]

View: FF_ARCHIVE_ITEMS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_ARCHIVE_ITEMS

SYNONYM - FF_DATABASE_ITEMS

SYNONYM - FND_SESSIONS

SYNONYM - PAY_REPORT_FORMAT_ITEMS_F

PUBLIC

SYNONYM - FF_ARCHIVE_ITEMS_V

[top of page]

View: FF_ARCHIVE_ITEM_CONTEXTS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS

PACKAGE - FF_ARCHIVE_UTILS

SYNONYM - FF_CONTEXTS

PACKAGE - FND_PROFILE

PUBLIC

SYNONYM - FF_ARCHIVE_ITEM_CONTEXTS_V

[top of page]

View: FF_COMPILED_INFO

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_COMPILED_INFO_F

SYNONYM - FND_SESSIONS

APPS

PACKAGE BODY - PAY_US_GARN_UPGRADE

PUBLIC

SYNONYM - FF_COMPILED_INFO

[top of page]

View: FF_COMPILED_INFO_X

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_COMPILED_INFO_F

PUBLIC

SYNONYM - FF_COMPILED_INFO_X

[top of page]

View: FF_DATABASE_ITEMS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_DATABASE_ITEMS

SYNONYM - FF_ROUTES

SYNONYM - FF_USER_ENTITIES

PACKAGE - FND_GLOBAL

PACKAGE - HR_API

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - FF_DATABASE_ITEMS_V

[top of page]

View: FF_DATABASE_ITEMS_VL

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_DATABASE_ITEMS

SYNONYM - FF_DATABASE_ITEMS_TL

PUBLIC

SYNONYM - FF_DATABASE_ITEMS_VL

[top of page]

View: FF_DATABASE_ITEMS_VL1

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_DATABASE_ITEMS

SYNONYM - FF_DATABASE_ITEMS_TL

SYNONYM - FF_ROUTES

SYNONYM - FF_USER_ENTITIES

PACKAGE - FND_GLOBAL

PACKAGE - HR_API

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - FF_DATABASE_ITEMS_VL1

[top of page]

View: FF_DATABASE_ITEMS_VL2

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_DATABASE_ITEMS

SYNONYM - FF_DATABASE_ITEMS_TL

PUBLIC

SYNONYM - FF_DATABASE_ITEMS_VL2

[top of page]

View: FF_FDI_USAGES

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_FDI_USAGES_F

SYNONYM - FND_SESSIONS

APPS

PACKAGE BODY - FFHUTL

PACKAGE BODY - PAY_US_GARN_UPGRADE

PUBLIC

SYNONYM - FF_FDI_USAGES

[top of page]

View: FF_FDI_USAGES_X

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_FDI_USAGES_F

PUBLIC

SYNONYM - FF_FDI_USAGES_X

[top of page]

View: FF_FORMULAS

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_FORMULAS_F

SYNONYM - FND_SESSIONS

APPS

VIEW - BEN_LER_BNFT_RSTRN_D

PACKAGE BODY - HR_BIS_ALERTS

PACKAGE BODY - HR_FR_MMO

PACKAGE BODY - HR_ITP_BUS

VIEW - PER_CAGR_ENTITLEMENTS_V

PACKAGE BODY - PQP_GB_GAP_BEN_FORMULAS

PACKAGE BODY - PQP_UK_VEHICLE_TEMPLATE

PUBLIC

SYNONYM - FF_FORMULAS

[top of page]

View: FF_FORMULAS_F_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_COMPILED_INFO_F

SYNONYM - FF_FORMULAS_F

SYNONYM - FF_FORMULA_TYPES

SYNONYM - FND_SESSIONS

PACKAGE - HR_GENERAL

APPS

PACKAGE BODY - HR_NL_CALC_TARGET_GROUP

VIEW - PQH_BDGT_CMMTMNT_ELMNTS_V

PUBLIC

SYNONYM - FF_FORMULAS_F_V

[top of page]

View: FF_FORMULAS_LOV

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_COMPILED_INFO_F

SYNONYM - FF_FORMULAS_F

SYNONYM - FF_FORMULA_TYPES

SYNONYM - FND_SESSIONS

PUBLIC

SYNONYM - FF_FORMULAS_LOV

[top of page]

View: FF_FORMULAS_X

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_FORMULAS_F

APPS

PACKAGE BODY - HRI_OLTP_DISC_WRKFRC

PUBLIC

SYNONYM - FF_FORMULAS_X

[top of page]

View: FF_FUNCTIONS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_FUNCTIONS

SYNONYM - FF_LOOKUPS

PUBLIC

SYNONYM - FF_FUNCTIONS_V

[top of page]

View: FF_FUNCTION_CONTEXT_USAGES_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_CONTEXTS

SYNONYM - FF_FUNCTION_CONTEXT_USAGES

SYNONYM - FF_LOOKUPS

PUBLIC

SYNONYM - FF_FUNCTION_CONTEXT_USAGES_V

[top of page]

View: FF_FUNCTION_PARAMETERS_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_FUNCTION_PARAMETERS

SYNONYM - FF_LOOKUPS

PUBLIC

SYNONYM - FF_FUNCTION_PARAMETERS_V

[top of page]

View: FF_GLOBALS

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_GLOBALS_F

SYNONYM - FND_SESSIONS

PUBLIC

SYNONYM - FF_GLOBALS

[top of page]

View: FF_GLOBALS_F_V

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_GLOBALS_F

PACKAGE - FND_GLOBAL

SYNONYM - FND_SESSIONS

PACKAGE - HR_API

VIEW - HR_LOOKUPS

PUBLIC

SYNONYM - FF_GLOBALS_F_V

[top of page]

View: FF_GLOBALS_X

Comments

View Type

A supplementary view used to simplify forms coding.

Warning: Oracle does not recommend you query or alter datausing this view. It may change dramatically in subsequent minor or major releases.

Columns

[top of page]

APPS

SYNONYM - FF_GLOBALS_F

PUBLIC

SYNONYM - FF_GLOBALS_X

[top of page]