Search Results ota_price_lists




Overview
Explore in AI Chat

Overview

The OTA_PRICE_LISTS table is a core data object within the Oracle E-Business Suite Learning Management (OTA) module. It serves as the master repository for defining price lists, which are foundational for the financial configuration of training activities. A price list functions as a container that holds specific pricing rules and entries, enabling the system to determine the cost of enrolling in courses, events, or other learning offerings. Its primary role is to establish a standardized and reusable pricing framework that can be associated with multiple activities and customer agreements, ensuring consistent and automated price calculations across the learning management system.

Key Information Stored

The table stores the fundamental attributes that define a price list entity. The primary identifier is the PRICE_LIST_ID column, which is the system-generated primary key. The NAME column holds the unique, user-defined name for the price list within a specific business group. The BUSINESS_GROUP_ID column is critical for multi-organization security (MOAC), linking the price list to a specific operating unit or business entity and ensuring data isolation. While the provided metadata does not list all columns, typical implementations would also include descriptive columns, effective dates (START_DATE_ACTIVE, END_DATE_ACTIVE), creation and last update audit columns (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE), and potentially a currency code.

Common Use Cases and Queries

This table is central to pricing operations. Common use cases include setting up pricing for a new catalog of courses, creating specialized price lists for different customer segments (e.g., partners, internal employees), and linking price lists to specific booking deals or discounts. Administrators frequently query this table to generate lists of active price lists or to troubleshoot pricing issues. A typical query to retrieve all price lists for a business group would be:

  • SELECT price_list_id, name, business_group_id FROM ota_price_lists WHERE business_group_id = &business_group ORDER BY name;

Another common pattern involves joining with the OTA_PRICE_LIST_ENTRIES table to review all prices defined within a specific list:

  • SELECT pl.name, ple.* FROM ota_price_lists pl, ota_price_list_entries ple WHERE pl.price_list_id = ple.price_list_id AND pl.price_list_id = &price_list_id;

Related Objects

The OTA_PRICE_LISTS table has defined foreign key relationships with several other critical OTA tables, as documented in the ETRM metadata. These relationships are fundamental to the module's data integrity.

  • OTA_BOOKING_DEALS: A booking deal (discount agreement) references a specific price list via the OTA_BOOKING_DEALS.PRICE_LIST_ID column. This links discount rules to the underlying pricing structure.
  • OTA_PRICE_LIST_ENTRIES: This is the primary child table. It holds the individual price lines (e.g., per person, per event) for a price list, linked by OTA_PRICE_LIST_ENTRIES.PRICE_LIST_ID. The price list itself is a header, while the entries contain the detailed pricing rules.

These relationships illustrate that OTA_PRICE_LISTS acts as a parent table, with its identifier being propagated to dependent objects that require a pricing context.