Search Results icx_web_store_options




Overview
Explore in AI Chat

Overview

The SO_PRICE_LISTS_B table is a core master data object within the Oracle E-Business Suite (EBS) Order Entry (OE) module, specifically for version 12.1.1 and 12.2.2. It serves as the primary repository for defining price lists, which are fundamental to the pricing engine. A price list is a named set of prices for items, applicable to customers, transactions, or agreements within the order-to-cash cycle. This table stores the header-level attributes of a price list, such as its name, currency, and validity dates. Its central role is to provide a pricing reference that can be associated with customers, sales orders, agreements, and web store configurations, ensuring consistent price application across the application.

Key Information Stored

The table's primary key is the PRICE_LIST_ID, a unique system-generated identifier. While the full column list is not detailed in the provided excerpt, standard implementation includes critical columns such as NAME (the price list identifier), CURRENCY_CODE, START_DATE_ACTIVE, END_DATE_ACTIVE, and DESCRIPTION. The metadata explicitly highlights two significant foreign key columns: TERMS_ID, which links to payment terms in RA_TERMS_B, and SECONDARY_PRICE_LIST_ID, which enables a self-referential link to another price list within the same table, often used for complex pricing hierarchies or rollup scenarios.

Common Use Cases and Queries

This table is central to pricing configuration, reporting, and data validation. Common operational scenarios include identifying active price lists for a given date, auditing price list assignments, and troubleshooting order pricing. A typical query retrieves price list details for a specific sales order header by joining on SO_HEADERS_ALL.PRICE_LIST_ID. For reporting, analysts often aggregate data to see which price lists are most frequently used or to list all price lists active within a period. Sample SQL to find basic price list information would be: SELECT price_list_id, name, currency_code FROM oe.so_price_lists_b WHERE SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);. Another critical use case involves validating the integrity of the self-referential secondary price list link to prevent circular references.

Related Objects

As evidenced by the extensive foreign key relationships, SO_PRICE_LISTS_B is a highly referenced master table. Its primary key (PRICE_LIST_ID) is referenced by numerous transactional and setup tables across the Order Management, Receivables, and iStore modules. Key documented relationships include: