Results for “application_name”

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

Overview

The FND_FLEX_SHORTHAND_ALIAS_V view is an Oracle Application Object Library (FND) dictionary view exposed in the APPS schema. Its purpose is to surface the set of key flexfield structures that have key flexfield shorthand entry enabled, joined to their owning application and flexfield definition. Shorthand entry allows an end user to type an abbreviated alias in a flexfield segment instead of selecting or entering the full combination; the alias is validated and expanded by the application using the structure's shorthand prompt and length settings.

This view is therefore a metadata reporting object rather than a transactional one. It exposes the identity of each shorthand-enabled structure through the composite key formed from the application identifier, the key flexfield code, and the structure number. That composite value is materialized as a single concatenated column, which makes the view convenient for lookups, cross-references, and diagnostic queries that must resolve which structures permit shorthand entry. It is referenced in the Oracle E-Business Suite Technical Reference Manual (ETRM) for both release 12.1.1 and 12.2.2.

Underlying Base Objects

The documented metadata identifies the view as defined over three objects owned or referenced by APPS: FND_APPLICATION_VL, FND_ID_FLEXS, and FND_ID_FLEX_STRUCTURES_VL. FND_APPLICATION_VL is the multilingual (translated) application view supplying the application identifier, application name, and application short name. FND_ID_FLEXS is the key flexfield definition object supplying the flexfield code, flexfield name, and description. FND_ID_FLEX_STRUCTURES_VL is the multilingual structure view supplying the structure number, structure name, description, and the shorthand prompt, shorthand length, and shorthand-enabled flag.

Joins are applied on matching APPLICATION_ID across all three objects, and additionally on ID_FLEX_CODE between FND_ID_FLEXS and FND_ID_FLEX_STRUCTURES_VL. A filter restricts the result set to structures where SHORTHAND_ENABLED_FLAG equals 'Y'. The view text in the documentation references FND_APPLICATION_UNKNOWN_VIEW as part of its descriptive lineage; FND_APPLICATION_VL is the documented underlying object.

Key Columns

• APPLICATION_ID — Identifier of the application owning the flexfield.
• APPLICATION_NAME — Translated application name.
• APPLICATION_SHORT_NAME — Application short name used in concurrent programs and profile options.
• ID_FLEX_CODE — Key flexfield code, for example GL# for Accounting Flexfield.
• ID_FLEX_NAME — Descriptive name of the key flexfield.
• FLEX_DESCRIPTION — Description of the key flexfield definition.
• ID_FLEX_NUM — Structure number uniquely identifying the flexfield structure within its flexfield.
• ID_FLEX_STRUCTURE_NAME — Translated name of the structure.
• STRUCT_DESCRIPTION — Description of the structure.
• SHORTHAND_PROMPT — Prompt presented to the user for shorthand alias entry.
• SHORTHAND_LENGTH — Maximum permitted length of the shorthand alias.
• ID_CODE_NUM — The concatenated surrogate key in the form APPLICATION_ID-ID_FLEX_CODE-ID_FLEX_NUM.

Common Use Cases and Queries

Typical uses include auditing which structures allow shorthand aliases, verifying prompt and length configuration before enabling shorthand entry, and joining the composite key to other FND metadata views. A representative query lists all shorthand-enabled structures with their owning application:

SELECT application_short_name, id_flex_code, id_flex_name, id_flex_num, id_flex_structure_name, shorthand_prompt, shorthand_length FROM apps.fnd_flex_shorthand_alias_v WHERE id_flex_code = 'GL#' ORDER BY application_short_name, id_flex_num;

The composite key can be used for targeted lookups:

SELECT id_code_num, id_flex_structure_name FROM apps.fnd_flex_shorthand_alias_v WHERE id_code_num = '101-GL#-50319';

Because the view is restricted to SHORTHAND_ENABLED_FLAG = 'Y', a structure absent from the result set either has shorthand disabled or has no shorthand prompt and length defined. Queries against this view are read-only and require no special privileges beyond SELECT on the APPS view.