Results for “gl_rollup_group_scores”

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

Overview

The GL_ROLLUP_GROUP_SCORES table is a General Ledger (GL) schema object in Oracle E-Business Suite 12.1.1 and 12.2.2 that stores rollup group usages. It captures statistical and scoring metadata about how account rollup groups are used within an application, providing the performance and selectivity metrics that help the Oracle EBS engine determine how efficiently a particular flexfield value set behaves when aggregated through a rollup group. Given the user search term fnd_flex_value_sets, this table is directly relevant because it is tightly coupled to the Key Flexfield value set infrastructure — every score row is anchored to a specific value set and application column combination.

From a heuristic Data Vault modeling perspective, the documented FK structure (this table references FND_FLEX_VALUE_SETS on FLEX_VALUE_SET_ID) classifies GL_ROLLUP_GROUP_SCORES as a link object. It connects rollup groups, flexfield value sets, and application columns, effectively acting as an associative or junction entity between these dimensions. The composite nature of its primary key reinforces this link interpretation.

Key Information Stored

The table contains six documented columns. The physical schema shows a composite primary key, GL_ROLLUP_GROUP_SCORE_PK, composed of APPLICATION_COLUMN_NAME and FLEX_VALUE_SET_ID. This surrogate/business key pairing distinguishes the row from the unique index GL_ROLLUP_GROUP_SCORES_U1, a documented business-key candidate (APPLICATION_COLUMN_NAME, FLEX_VALUE_SET_ID, ROLLUP_GROUP_ID).

• APPLICATION_COLUMN_NAME — Identifies the specific application column (flexfield segment) to which the rollup scoring applies; part of both the primary key and the unique index.
• FLEX_VALUE_SET_ID — Foreign key to FND_FLEX_VALUE_SETS; the value set whose members are scored. Also part of the primary key and unique index.
• ROLLUP_GROUP_ID — Identifies the rollup group being scored; the third element of the unique business-key index.
• NUMBER_OF_PARENT_VALUES — The count of parent (summary) values participating in the rollup group.
• AVG_SCORE_PER_CHILD_RANGE — The average score assigned per child range, a metric describing distribution of child values under parents.
• SELECTIVITY_SCORE — A numeric score reflecting how selective the rollup group is, useful for query optimization and aggregation planning.

Common Use Cases and Queries

Administrators and performance tuners query this table to understand rollup efficiency. Typical reporting includes identifying value sets with poor selectivity, examining parent-to-child ratio distributions, and validating rollup group configuration after flexfield changes.

A representative join to the value set definition:

SELECT s.APPLICATION_COLUMN_NAME, s.SELECTIVITY_SCORE, v.FLEX_VALUE_SET_NAME
FROM GL.GL_ROLLUP_GROUP_SCORES s, FND_FLEX_VALUE_SETS v
WHERE s.FLEX_VALUE_SET_ID = v.FLEX_VALUE_SET_ID
AND s.SELECTIVITY_SCORE < :threshold;

This helps flag rollup groups that may degrade GL inquiry and FSG (Financial Statement Generator) performance due to low selectivity. The scoring columns also support capacity planning and diagnostics when account hierarchies are rebuilt.

Related Objects

• FND_FLEX_VALUE_SETS — Referenced via FLEX_VALUE_SET_ID (documented FK, appearing twice in metadata); the parent value set definition.
• FND_FLEX_VALUES — Stores individual values within the value set, used alongside scoring to evaluate rollup composition.
• FND_FLEX_VALUE_HIERARCHIES — Defines parent/child rollup structures underlying the scoring.
• GL_ROLLUP_GROUPS — The rollup group definition joined via ROLLUP_GROUP_ID.
• FND_ID_FLEX_STRUCTURES — The accounting flexfield structure that supplies APPLICATION_COLUMN_NAME context.

Note: The metadata provided is excerpted from ETRM 12.2.2 and is valid for both 12.1.1 and 12.2.2 unless Oracle updates the schema. Oracle Proprietary, Confidential Information.