Search Results ff_archive_items_v




Overview
Explore in AI Chat

Overview

FF_ARCHIVE_ITEMS_V is an Oracle E-Business Suite (EBS) view owned by the APPS schema and delivered within the FastFormula (FF) product family. It exposes archived FastFormula item data in a denormalized, query-friendly form by joining the archive items table to the pay report format items definition, the database items catalog, and the active FND session. The view carries a status of VALID in both the 12.1.1 and 12.2.2 releases and is referenced primarily for reporting, diagnostics, and integration of FastFormula archive content.

The view's distinguishing characteristic is that it presents a curated set of attributes — including the UPDATABLE_FLAG attribute sourced from PAY_REPORT_FORMAT_ITEMS_F — alongside the archived value held per user entity and context. This structure lets consumers answer questions about which archived formula items are user-maintainable and how they should be displayed, without needing to know the archive mechanics of the underlying tables.

Underlying Base Objects

The ETRM metadata documents the view as defined over four APPS synonyms: FF_ARCHIVE_ITEMS, FF_DATABASE_ITEMS, FND_SESSIONS, and PAY_REPORT_FORMAT_ITEMS_F. The view text establishes the following join relationships:

Because FND_SESSIONS and FF_DATABASE_ITEMS are inner joins, the view is session-scoped and only returns archive items whose USER_ENTITY_ID is present in the database items catalog. PAY_REPORT_FORMAT_ITEMS_F is outer-joined, so UPDATABLE_FLAG and DISPLAY_SEQUENCE may be NULL when no matching effective report format item exists.

Key Columns

  • ARCHIVE_ITEM_ID — the primary identifier of the archive item record.
  • USER_ENTITY_ID — the FastFormula user entity to which the archived item belongs; the principal join key.
  • CONTEXT1 and VALUE — the context qualifier and the archived value itself.
  • ARCHIVE_TYPE — the category under which the item was archived.
  • UPDATABLE_FLAG — indicates whether the corresponding report format item may be updated. This is the attribute most frequently searched for in this view.
  • DISPLAY_SEQUENCE — the ordering attribute used when rendering report format items.
  • USER_NAME and DATA_TYPE — the database item name and its data type, retrieved via FF_DATABASE_ITEMS.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, OBJECT_VERSION_NUMBER — standard WHO and concurrency-control columns.
  • ROW_ID — the ROWID of FF_ARCHIVE_ITEMS, useful for addressing the underlying row.

Common Use Cases and Queries

Typical usage centers on inspecting archived formula items for the current session, verifying which items are updatable, and joining archived values back to their database item definitions. Because the view is session-scoped through FND_SESSIONS, queries are meaningful when executed within an active EBS session.

A straightforward listing of the session's archived items:

  • SELECT archive_item_id, user_entity_id, user_name, data_type, archive_type, value, updatable_flag FROM apps.ff_archive_items_v ORDER BY display_sequence;

Isolating items that are flagged as updatable:

  • SELECT user_entity_id, user_name, value, display_sequence FROM apps.ff_archive_items_v WHERE updatable_flag = 'Y';

Distinguishing archived items lacking an effective report format definition:

  • SELECT a.user_entity_id, a.user_name, a.value FROM apps.ff_archive_items_v a WHERE a.updatable_flag IS NULL;

In all cases, results reflect only the caller's FND session and the effective-dated report format items valid at the session's effective date, so no additional session filtering is ordinarily required.