Search Results line_currency




Overview
Explore in AI Chat

Overview

APPS.OE_BIS is a PL/SQL package body belonging to the Oracle Order Management business intelligence subsystem. The package encapsulates the business logic required to publish order-management key performance indicators, specifically those surfaced through the Oracle Daily Business Intelligence and Order Management analytics dashboards. Its primary responsibility is to compute aggregated shipping, returns, bookings and delivery performance metrics for a given day and, where required, for a given operating unit or warehouse.

The package is classified in ETRM with an API classification of OTHER, indicating that it is not a supported public interface intended for customer extension. The header comment in the source ($Header: OEXBISRB.pls 115.6 2003/04/02) confirms a long-standing component of the E-Business Suite that has been carried forward largely unchanged into the 12.1.1 and 12.2.2 releases. All functions follow a defensive coding pattern: each routine wraps its query in an exception handler that returns zero on any failure, ensuring that analytics rendering is never blocked by a data anomaly.

Key Procedures and Functions

The package body exposes five documented functions:

  • GET_DAILY_VALUE_SHIPPED — Returns the total shipped value for a specified day and warehouse. In the 11i-era source this function originally intended to compute the value in a target reporting currency, and the commented-out block references gl_currency_api.rate_exists and gl_currency_api.get_rate against line_currency. In the delivered code the currency conversion logic is disabled and the function returns a straightforward sum of shipment values drawn from the WSH fill-rate view.
  • GET_DAYS_TOP_RETURNS — Returns a return percentage for a specified day and operating unit, calculated as the count of return lines for top customers divided by the count of bookings for those same customers.
  • GET_DAYS_TOP_DELIVERIES — Computes a delivery performance percentage for a specified day and operating unit, comparing promise dates to actual closed dates.
  • GET_TOP_CUSTOMERS — Populates or retrieves the set of highest-value customers used as the filter basis for the returns and bookings calculations above.
  • GET_BBB_INFO — Returns booking, billing and backlog information consumed by the order-management analytics dashboards.

Tables Accessed

All references are made through APPS synonyms. The package reads SO_LINES_ALL and SO_HEADERS_ALL to identify return line types and to attribute activity to the correct customer and operating unit. OE_BIS_TOP_CUSTOMERS supplies the qualifying customer population used to scope the returns and deliveries metrics, while OE_BIS_BBB_INFO holds the booking, billing and backlog aggregates surfaced by GET_BBB_INFO. GL_PERIODS is referenced for period and date-range resolution. The daily-shipped calculation reads the WSH fill-rate view rather than a base table.

Usage Notes

OE_BIS is not invoked by any other packaged API in the ETRM registry — the "Referenced by 0 other packages" figure confirms it sits at the leaf of the dependency tree. It is normally executed by the Order Management Daily Business Intelligence concurrent programs and by the analytics dashboard regions that render the daily shipping value, top-customer returns and delivery performance tiles. Because the functions are date-parameterised, they are well suited to scheduled nightly collection jobs that roll up one day at a time. Custom code should treat the package as read-only and unsupported; the currency-handling references to line_currency in GET_DAILY_VALUE_SHIPPED are dormant and should not be relied upon.