Search Results user_updateable_flag

Overview

FV_LOOKUP_TYPES is an Oracle E-Business Suite view owned by the APPS schema within the FV (Federal Financials) product. It presents the subset of Oracle EBS lookup types that are seeded specifically for Federal Financials functionality, providing a focused, security-filtered window into the broader FND_LOOKUP_TYPES_VL definition. Rather than exposing every lookup type registered under the FND application, this view narrows its scope to those records whose VIEW_APPLICATION_ID equals 8901, the application identifier associated with the Federal Financials product. In Oracle EBS 12.1.1 and 12.2.2, this distinction is important because reporting and integration efforts targeting federal compliance frequently need to isolate Federal-specific reference data from the thousands of lookup types used across the wider applications suite.

The view plays a typical reporting and integration role: it is a read-only projection intended for queries, extracts, and downstream interfaces rather than for data maintenance. Lookup type maintenance is performed through the underlying FND lookup forms and APIs; FV_LOOKUP_TYPES simply offers a controlled, product-scoped read path.

Underlying Base Objects

The view is defined over two documented objects. The primary source is FND_LOOKUP_TYPES_VL, the translatable view in the FND (Application Object Library) schema that stores lookup type definitions together with their language-specific description columns. The second referenced object is FND_GLOBAL, an APPS package used to supply the security predicate. Because it draws from FND_LOOKUP_TYPES_VL, FV_LOOKUP_TYPES inherits the standard lookup type attributes — lookup type name, description, customization level, and audit columns — while the translatable view ensures that the DESCRIPTION reflects the session’s language environment.

The WHERE clause applies two filters. The first restricts rows to VIEW_APPLICATION_ID = 8901, confining the result set to Federal Financials seeded lookup types. The second invokes FND_GLOBAL.LOOKUP_SECURITY_GROUP(LOOKUP_TYPE, VIEW_APPLICATION_ID), which applies Oracle’s lookup security model so that only lookup types visible to the current security group are returned. This means the view’s output can vary by user responsibility and security configuration, a behavior that is consistent across 12.1.1 and 12.2.2.

Key Columns

• LOOKUP_TYPE — The internal name of the lookup type, serving as the primary identifier used throughout EBS forms, concurrent programs, and interfaces.
• DESCRIPTION — The translated, user-facing description of the lookup type, drawn from the translatable base view.
• USER_UPDATEABLE_FLAG — Derived by a DECODE on the customization level: a value of ‘E’ (extensible or user-maintainable) yields ‘Y’, while any other value yields ‘N’. This column indicates whether users may add their own lookup values to the type.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE — Standard EBS audit columns recording who created and last modified the lookup type and when.

Common Use Cases and Queries

Typical use cases include validating the presence of Federal seeded lookup types after an upgrade or patch, generating configuration documentation for audit purposes, and driving integration extracts that must enumerate Federal reference data without retrieving the entire FND lookup type repository. Because security filtering is built in, the view is also useful where a report must respect lookup security automatically.

A simple listing of Federal lookup types:

• SELECT lookup_type, description, user_updateable_flag FROM fv_lookup_types ORDER BY lookup_type;

Identifying user-extensible Federal lookup types only:

• SELECT lookup_type, description FROM fv_lookup_types WHERE user_updateable_flag = 'Y' ORDER BY 1;

Tracking recent changes to Federal lookup type definitions:

• SELECT lookup_type, last_updated_by, last_update_date FROM fv_lookup_types WHERE last_update_date >= TRUNC(SYSDATE) - 30 ORDER BY last_update_date DESC;

Users searching for fnd_lookup_types_vl should recognize that FV_LOOKUP_TYPES is a specialized derivative of that view; queries requiring lookup types outside Federal Financials must target FND_LOOKUP_TYPES_VL directly.