Search Results fnd_standard

Overview

APPS.FND_DATA_GROUPS_STANDARD_VIEW is a reporting view in the Oracle E-Business Suite Applications (APPS) schema that exposes the set of Oracle-defined, or "Standard", data groups registered in the FND_DATA_GROUPS table. It is a lightweight, purpose-built presentation layer intended to return data group identifiers, names, descriptions, and default status for records that qualify as standard groups under Oracle's internal lookup conventions. The view derives its "standard" classification by joining FND_DATA_GROUPS to the FND_LOOKUPS view, filtering on LOOKUP_TYPE = 'FND_STANDARD' and LOOKUP_CODE = 'STANDARD'.

Its principal design behavior is a DECODE expression applied to DATA_GROUP_NAME: when DATA_GROUP_ID equals 0, the view substitutes the lookup meaning from FND_STANDARD (the system's designated standard/default group label) in place of the stored data group name. This ensures that the seed data group, typically the "Standard" group, is consistently presented using Oracle-supplied terminology rather than a raw or potentially missing name value. In Oracle EBS 12.1.1 and 12.2.2 the object remains an APPS-owned view and continues to function as a read-only convenience access point for standard data groups used in concurrent processing, request group assignment, and responsibility configuration contexts.

Underlying Base Objects

The ETRM metadata documents three referenced base objects:

• FND_DATA_GROUPS (SYNONYM) — The primary source of data group rows, supplying DATA_GROUP_ID, DEFAULT_GROUP_FLAG, DESCRIPTION, and DATA_GROUP_NAME. In 12.1.1 and 12.2.2 this resolves to the core FND_DATA_GROUPS table that stores all registered data groups, including user-defined ones.
• FND_LOOKUPS (VIEW) — Provides the lookup meaning and enables the filter that restricts output to the STANDARD lookup code within the FND_STANDARD lookup type. Because FND_LOOKUPS is itself a view (over FND_LOOKUP_VALUES), it delivers only currently effective, viewable lookup values.
• FND_GLOBAL (PACKAGE) — Listed as a referenced object, reflecting the standard dependency pattern where user context (USER_ID, RESP_ID, ORG_ID) influences security or language resolution for lookups. Its presence indicates the view may be evaluated within a runtime session context sensitive to FND_GLOBAL initialization.

Because the standard classification is driven by the FND_STANDARD lookup rather than a column on FND_DATA_GROUPS, the view effectively filters the broader population of data groups down to the standard subset. User-defined data groups that do not correspond to the STANDARD lookup code are excluded.

Key Columns

• DATA_GROUP_ID — Numeric primary identifier of the data group. Value 0 denotes the special standard/default group handled by the DECODE.
• DEFAULT_GROUP_FLAG — Indicates whether the data group is the default grouping applied when no explicit group is specified.
• DESCRIPTION — Free-text description from FND_DATA_GROUPS.
• DATA_GROUP_NAME — The displayed name. For DATA_GROUP_ID = 0 this is replaced by the FND_STANDARD lookup meaning; otherwise the stored DATA_GROUP_NAME is returned.

Common Use Cases and Queries

Typical uses include validating which data groups qualify as standard, resolving the display name of the standard group for reporting, and confirming the default group configuration during user or responsibility provisioning analysis.

• List all standard data groups with their effective display names.
• Identify the default standard data group.
• Correlate data group IDs used by assignment records against readable names.

Sample query:

• SELECT data_group_id, data_group_name, default_group_flag, description FROM apps.fnd_data_groups_standard_view ORDER BY data_group_id;
• SELECT data_group_id, data_group_name FROM apps.fnd_data_groups_standard_view WHERE default_group_flag = 'Y';

Because the view is read-only and confined to standard groups, it should be used for reporting and validation only; data group maintenance is performed through FND_DATA_GROUPS and the standard lookup configuration directly.