Results for “hr_summary_key_values_band_v”

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

Overview

The HR_SUMMARY_KEY_VALUES_BAND_V view is a read-only database object owned by the APPS schema within the PER (Human Resources) product module of Oracle E-Business Suite. It is documented as VALID in ETRM 12.2.2 and remains structurally consistent between releases 12.1.1 and 12.2.2. As stated in the ETRM description, the view provides data from the HR_SUMMARY table family for the Generic Summary Process forms. Its specific purpose is to expose the set of band-level key values that populate the value lists presented on those forms, resolving the relationship between a summary key definition and the user-defined table rows that supply the selectable bands.

Functionally, the view acts as a bridge between the generic summary framework and the flexible, user-defined tables that store range or name definitions. Rather than presenting raw summary data, it filters key types whose key function invokes the band-values utility and joins those definitions to the corresponding user table rows. This makes it an integration surface for form logic rather than a conventional reporting view, although it may be queried directly for administrative validation.

Underlying Base Objects

The documented referenced base objects are HR_API (PACKAGE), HR_GENERAL (PACKAGE), HR_SUMMARY_KEY_TYPE (VIEW), HR_SUMMARY_KEY_VALUE (VIEW), PAY_USER_ROWS_X (VIEW) and PAY_USER_TABLES (SYNONYM). The view definition confirms these dependencies: it joins HR_SUMMARY_KEY_VALUE (aliased KV) to HR_SUMMARY_KEY_TYPE (KT) on KEY_TYPE_ID, and joins to PAY_USER_TABLES (UT) and PAY_USER_ROWS_X (UTR) on the user table identifiers.

• HR_SUMMARY_KEY_VALUE (KV) — supplies the key value records, including NAME, ITEM_VALUE_ID and BUSINESS_GROUP_ID.
• HR_SUMMARY_KEY_TYPE (KT) — supplies the key type NAME and the KEY_FUNCTION string that encodes both the utility call and the target user table name.
• PAY_USER_TABLES (UT) — identifies the registered user table via USER_TABLE_NAME and USER_TABLE_ID, scoped by BUSINESS_GROUP_ID.
• PAY_USER_ROWS_X (UTR) — supplies the DISPLAY_SEQUENCE and the ROW_LOW_RANGE_OR_NAME matched against the key value NAME.
• HR_GENERAL / HR_API (PACKAGES) — HR_GENERAL.GET_BUSINESS_GROUP_ID is referenced within the WHERE clause to enforce business group security; HR_SUMMARY_UTIL.GET_BAND_VALUES is referenced by the KEY_FUNCTION substring filter.

Key Columns

• NAME — the key value name from HR_SUMMARY_KEY_VALUE. This is matched to the user table row's ROW_LOW_RANGE_OR_NAME and drives the value presented in the band list.
• DISPLAY_SEQUENCE — the ordering sequence from PAY_USER_ROWS_X that controls how band values are presented in the form list of values.
• KEY_TYPE — the descriptive name of the key type from HR_SUMMARY_KEY_TYPE, identifying the summary key grouping to which the band belongs.
• ITEM_VALUE_ID — the surrogate identifier for the key value record, used internally to reference the specific value entry.

Common Use Cases and Queries

Typical usage includes validating that band values are correctly linked to their summary key types, auditing user table registrations against summary keys, and diagnosing missing or misordered values on Generic Summary Process forms. A representative query retrieves the bands for a given key type:

• SELECT name, key_type, display_sequence, item_value_id FROM apps.hr_summary_key_values_band_v ORDER BY key_type, display_sequence;
• SELECT name, display_sequence FROM apps.hr_summary_key_values_band_v WHERE key_type = :p_key_type;
• SELECT key_type, COUNT(*) band_count FROM apps.hr_summary_key_values_band_v GROUP BY key_type;

Because the view applies NVL logic against HR_GENERAL.GET_BUSINESS_GROUP_ID, results are implicitly restricted to the session business group, and queries should be executed from a context where the correct business group is set.