Search Results flex_structure_description




Overview
Explore in AI Chat

Overview

APPS.FND_FLEX_CROSS_VALIDATION_V is a dictionary view in the Oracle E-Business Suite Applications (APPS) schema that exposes descriptive metadata about key flexfield structures. It is classified as an internal Oracle object, meaning it is not part of the supported public API surface; Oracle's documented position is that applications data should be accessed through this object only from standard Oracle Applications programs. In EBS 12.1.1 and 12.2.2 the object is documented as VALID with the FND design data designation FND.FND_FLEX_CROSS_VALIDATION_V.

The view is structured as a denormalized reporting projection across the key flexfield definition tables. Rather than requiring a caller to join the application registry, the key flexfield registry, and the flexfield structure definition views manually, FND_FLEX_CROSS_VALIDATION_V presents a single row per key flexfield structure, carrying the flexfield code, the owning application, and the structure number, name, and description. Because it resolves both the flexfield level and the structure level, it is useful when the reported attribute is flex_structure_name and the user must also identify which application and which key flexfield that structure belongs to. It carries no validation rule data despite the "CROSS_VALIDATION" naming; the documented column set is entirely descriptive metadata.

Underlying Base Objects

The view is defined over three documented dependencies:

The "_VL" suffix on two of the dependencies indicates translation-enabled views that return the appropriate language row for the session. FND_FLEX_CROSS_VALIDATION_V is not referenced by any other database object, so it sits at the top of its dependency chain and is intended for direct query rather than further view layering.

Key Columns

  • FLEX_CODE / FLEX_NAME / FLEX_DESCRIPTION — the key flexfield identifier and its display attributes (for example GL# for the Accounting Flexfield).
  • APPLICATION_ID — numeric application identifier of the owning application; the reliable join key to FND_APPLICATION_VL.
  • APPLICATION_NAME / APPLICATION_SHORT_NAME — translated application name and the short name used on concurrent programs and forms.
  • FLEX_STRUCTURE_NUM — the structure's internal ID; on the Accounting Flexfield this is the Chart of Accounts ID referenced throughout GL and subledger data.
  • FLEX_STRUCTURE_NAME — the structure (chart of accounts) name, the column most commonly sought when resolving a configuration listing.
  • FLEX_STRUCTURE_DESCRIPTION — the free-form description entered at structure definition time.

Common Use Cases and Queries

Typical uses include documenting which flexfield structures exist for an application, mapping a stored FLEX_STRUCTURE_NUM back to a readable name, and building cross-application inventories of flexfield configurations for upgrade or audit review.

List all structures for one key flexfield and application:

  • SELECT flex_structure_num, flex_structure_name, flex_structure_description FROM apps.fnd_flex_cross_validation_v WHERE application_short_name = 'GL' AND flex_code = 'GL#' ORDER BY flex_structure_name;

Search by structure name when the numeric ID is unknown:

  • SELECT application_short_name, flex_code, flex_structure_num, flex_structure_name FROM apps.fnd_flex_cross_validation_v WHERE UPPER(flex_structure_name) LIKE UPPER('%OPERATIONS%');

Resolve a chart of accounts ID to a name for reporting:

  • SELECT s.name, v.flex_structure_name FROM gl_sets_of_books s, apps.fnd_flex_cross_validation_v v WHERE v.flex_code = 'GL#' AND v.flex_structure_num = s.chart_of_accounts_id;

Because the object is flagged for Oracle internal use, production code should prefer supported flexfield APIs and the documented FND_ID_FLEX_STRUCTURES_VL view; queries against this view are best confined to diagnostic, reference, and reporting scripts.