Search Results as_price_list_groups




Overview
Explore in AI Chat

Overview

The AS_PRICE_LIST_GROUPS table is a core data object within the Oracle E-Business Suite (EBS) Sales Foundation module (AS). It serves as a master table for defining logical groupings of price lists. In the context of Oracle Advanced Pricing, price lists are fundamental for defining selling prices, discounts, and promotions for products and services. This table provides a mechanism to categorize and manage related price lists collectively, enabling more efficient administration, assignment, and reporting. Its role is to act as a parent entity, establishing a one-to-many relationship with individual price list records stored in the AS_PRICE_LISTS table.

Key Information Stored

While the provided ETRM metadata does not list specific columns beyond the primary key, the structure and naming conventions indicate the table's core purpose. The primary column is GROUP_ID, a unique system-generated identifier (likely a sequence number) for each price list group. Based on standard EBS design patterns, other typical columns would include a NAME or GROUP_NAME for the descriptive identifier of the group, and columns for tracking metadata such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY. The table may also contain a DESCRIPTION field and columns controlling the group's active status and effective date ranges.

Common Use Cases and Queries

A primary use case is the bulk assignment or filtering of price lists. For instance, a business might create a price list group for a specific sales channel, geographic region, or customer tier, then associate all relevant price lists to that group. Common reporting and validation queries include listing all groups and their associated price lists, or identifying price lists not assigned to any group. A typical join query would be:

  • SELECT pg.GROUP_NAME, pl.NAME FROM OSM.AS_PRICE_LIST_GROUPS pg, OSM.AS_PRICE_LISTS pl WHERE pg.GROUP_ID = pl.GROUP_ID;

Administrative tasks often involve querying this table to understand the organizational hierarchy of pricing before running data fixes or mass updates. It is also critical for troubleshooting when price list assignments or inheritances are not functioning as expected.

Related Objects

The table has a direct, documented foreign key relationship with the AS_PRICE_LISTS table, which is its primary child entity. The relationship is defined as follows:

  • Foreign Key Reference: The column AS_PRICE_LISTS.GROUP_ID references AS_PRICE_LIST_GROUPS.GROUP_ID.
  • Purpose: This relationship enforces that a price list (in AS_PRICE_LISTS) can be associated with at most one price list group. The GROUP_ID in AS_PRICE_LISTS is the link to its parent grouping.

Given its central role in pricing, this table is also indirectly related to numerous other objects in the Advanced Pricing and Order Management modules, such as qualification and modifier setup tables, though these relationships are not defined as direct foreign keys in the provided metadata.