Results for “ffbv_context”

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

Overview

FFBV_CONTEXT is a read-only view residing in the APPS schema within Oracle E-Business Suite, belonging to the FastFormula (FF) product family. It exposes context definitions used by the FastFormula engine, which underpins configurable business logic across Oracle HRMS, Payroll, Benefits, and related modules. FastFormula contexts describe the business objects and levels (for example, Assignment, Employee, or Payroll) against which formulas are evaluated, and they carry the data type information that governs how context values are interpreted at runtime.

The view serves as a reporting and integration layer over the FF_CONTEXTS base table. Rather than exposing raw surrogate identifiers and undecoded lookup codes, FFBV_CONTEXT resolves the DATA_TYPE column into a human-readable description through a call to the HR_BIS package, while simultaneously retaining the original code in a separate column. This dual presentation makes the view suitable for both end-user reporting and programmatic consumption, supporting the "data_type_code" search pattern in which developers and analysts need the underlying lookup value rather than its display form.

Underlying Base Objects

The view is defined over two documented dependencies: the FF_CONTEXTS synonym (pointing to the underlying FastFormula contexts table) and the HR_BIS package.

• FF_CONTEXTS (SYNONYM): The primary source of data. It supplies CONTEXT_NAME, CONTEXT_LEVEL, DATA_TYPE, and CONTEXT_ID. The view is created WITH READ ONLY, ensuring no DML can be performed through it.
• HR_BIS (PACKAGE): Used only for the derived DATA_TYPE column. The call HR_BIS.BIS_DECODE_LOOKUP('DATA_TYPE', FFC.DATA_TYPE) translates the stored code into a descriptive lookup meaning, a standard Business Intelligence decoding utility in Oracle HRMS.

Because the definition joins no additional tables, the view is effectively a decoded projection of FF_CONTEXTS, with row cardinality identical to that of the base table.

Key Columns

• CONTEXT_NAME: The identifying name of the FastFormula context (for example, a business object or entity against which formula logic is evaluated).
• CONTEXT_LEVEL: The organizational or application level at which the context applies, distinguishing, for instance, assignment-level from payroll-level contexts.
• DATA_TYPE: The decoded, descriptive form of the data type, returned by HR_BIS.BIS_DECODE_LOOKUP from the DATA_TYPE lookup type.
• DATA_TYPE_CODE: The raw stored value from FF_CONTEXTS.DATA_TYPE, preserved so that consumers can reference the original code directly. This column is the one most frequently targeted by searches involving "data_type_code."
• CONTEXT_ID: The unique surrogate identifier for the context row, useful for joins to related FastFormula objects.

Common Use Cases and Queries

Typical scenarios include auditing which contexts exist, verifying the data type assigned to each context, and joining context identifiers to formula or context-usage tables. The following query lists all contexts with their decoded and raw data type values:

SELECT context_id,
       context_name,
       context_level,
       data_type,
       data_type_code
FROM   apps.ffbv_context
ORDER  BY context_name;

To isolate contexts of a particular type, filter on the raw code:

SELECT context_name, context_level
FROM   apps.ffbv_context
WHERE  data_type_code = :p_data_type_code;

For reporting that requires only the descriptive value, the DATA_TYPE column can be used independently, while integrations comparing stored codes should reference DATA_TYPE_CODE to avoid dependency on lookup translations. Because the view is read-only and derived directly from FF_CONTEXTS, it is safe for query-only access and requires no special maintenance.