Search Results rounding_factor




Overview
Explore in AI Chat

Overview

SO_PRICE_LISTS_ACTIVE_V is an APPS-owned database view within the Oracle E-Business Suite Order Entry (OE) product family. It exposes a filtered, presentation-ready projection of the SO_PRICE_LISTS base entity, returning only those price lists that are active as of the current system date. Because the view performs the date-range evaluation internally, it is a convenient source for reporting, integration, and validation logic that must distinguish currently usable price lists from expired or future-dated ones.

The view carries a VALID status in the EBS data dictionary for both 12.1.1 and 12.2.2, and is documented under ETRM with the OE - Order Entry module. Its primary value lies in abstracting the SYSDATE-based activation window so that consumers do not need to re-implement the NVL date-range predicate. The rounding_factor column surfaced by this view is the attribute most frequently queried by users searching for rounding behavior associated with active price lists.

Underlying Base Objects

The documented metadata identifies two referenced base objects: the SO_PRICE_LISTS synonym and the QP_PRICE_LIST_PVT package.

  • SO_PRICE_LISTS — the synonym over the physical price list table. The view's SELECT statement reads directly from this synonym, projecting NAME, DESCRIPTION, PRICE_LIST_ID, ROUNDING_FACTOR, CURRENCY_CODE, START_DATE_ACTIVE, and END_DATE_ACTIVE.
  • QP_PRICE_LIST_PVT — the Advanced Pricing (QP) private API package that governs price list creation and maintenance logic. It is referenced as a related object, reflecting that price list attributes (including rounding) are managed through the QP pricing engine while being surfaced for order entry purposes.

The view applies the predicate SYSDATE BETWEEN NVL(START_DATE_ACTIVE, SYSDATE) AND NVL(END_DATE_ACTIVE, SYSDATE), which means a NULL start date is treated as open-ended and a NULL end date is treated as having no expiry. Price lists with a fully populated window are returned only when SYSDATE falls within the range.

Key Columns

  • PRICE_LIST — the price list name (aliased from SO_PRICE_LISTS.NAME); the human-readable identifier.
  • DESCRIPTION — free-text description of the price list.
  • PRICE_LIST_ID — the internal unique identifier, usable as a foreign key to pricing and order line tables.
  • ROUNDING_FACTOR — the rounding factor applied to prices derived from the list. This column is the focus for consumers confirming how monetary values are rounded on active lists.
  • CURRENCY_CODE — the currency in which the price list is denominated.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — the activation window boundaries evaluated by the view's WHERE clause.

Common Use Cases and Queries

Typical use cases include reporting all currently active price lists, extracting rounding factors for auditing, validating currency assignments, and driving integration feeds that must exclude expired lists.

  • List active price lists with their rounding factor:
    SELECT price_list, currency_code, rounding_factor FROM so_price_lists_active_v;
  • Filter by currency:
    SELECT price_list_id, price_list, rounding_factor FROM so_price_lists_active_v WHERE currency_code = 'USD';
  • Identify active lists with a non-default rounding factor:
    SELECT price_list, rounding_factor FROM so_price_lists_active_v WHERE NVL(rounding_factor, 0) <> 0;

Because the view already enforces the SYSDATE activation predicate, no additional date filtering is required for "currently active" semantics.