Search Results so_item_groups




Overview
Explore in AI Chat

Overview

The SO_ITEM_GROUPS table is a core master data table within the Oracle E-Business Suite Order Entry (OE) module. It serves as the repository for defining price list item groups. These groups are logical collections of items used to simplify and manage pricing, picking, and order fulfillment processes. The table's primary role is to act as a header entity, allowing administrators to create and maintain reusable sets of items that can be consistently referenced across various order management operations, thereby enforcing standardized business rules and improving operational efficiency.

Key Information Stored

The table's structure is centered on the unique identification and naming of each item group. The primary key is the GROUP_ID column, a system-generated unique identifier for each group record. A critical alternate key is enforced on the NAME column, ensuring that each item group has a distinct, user-defined identifier. While the provided metadata does not list all columns, typical implementations of such a table would also include standard Oracle EBS audit columns (e.g., CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY) and potentially columns for descriptive information, enabling status, or application context.

Common Use Cases and Queries

This table is integral to configuring and executing several key business functions. A primary use case is in pricing setups, where a price list can be associated with an item group instead of individual items, streamlining mass price updates. In warehouse operations, picking batches and picking rules can be defined for specific item groups to optimize the fulfillment workflow. Common queries involve listing all defined groups, finding groups associated with specific items via the SO_ITEM_GROUP_LINES table, or identifying which operational rules (picking, pricing) use a particular group. A sample query to retrieve all groups and a count of their associated items would be:

  • SELECT sig.NAME, COUNT(sigl.INVENTORY_ITEM_ID) AS ITEM_COUNT FROM OE.SO_ITEM_GROUPS sig LEFT JOIN OE.SO_ITEM_GROUP_LINES sigl ON sig.GROUP_ID = sigl.GROUP_ID GROUP BY sig.NAME;

Related Objects

The SO_ITEM_GROUPS table has defined relationships with several other key tables in the Order Management and Shipping execution modules, as documented by its foreign key constraints. The GROUP_ID column is referenced as a foreign key in the following tables:

  • SO_ITEM_GROUP_LINES: Links groups to specific inventory items (via GROUP_ID). This is the child table that defines the membership of the group.
  • SO_PICKING_BATCHES_ALL: Associates picking batches with a specific item group (via GROUP_ID) for consolidated fulfillment.
  • SO_PICKING_RULES: Allows picking rules to be defined based on item groups (via GROUP_ID) to control warehouse task creation.
  • SO_PRICE_COPY_PARAMETERS: References item groups (via GROUP_ID) in the context of copying or mass-updating pricing information.