Search Results get_days_top_deliveries




Overview
Explore in AI Chat

Overview

APPS.OE_BIS is a PL/SQL package within the Oracle E-Business Suite Order Management module that supplies business intelligence and analytical reporting data for order fulfillment performance. The package name derives from "Order Entry Business Information System," and its functions support dashboards, KPIs, and management reporting around shipping velocity, returns activity, delivery responsiveness, and customer revenue contribution. The package is declared with AUTHID CURRENT_USER, meaning it executes with the privileges of the calling schema rather than the definer, and it is classified as a non-API "OTHER" object within the ETRM repository. As such, it is an internal reporting utility rather than a public integration interface.

Key Procedures and Functions

  • GET_DAILY_VALUE_SHIPPED — Returns the total monetary value of goods shipped on a given day, for a specified warehouse and currency. It supports daily shipping value metrics.
  • GET_DAYS_TOP_RETURNS — Returns the number of days associated with top returns activity for a given day and organization. It is a scalar reporting function.
  • GET_DAYS_TOP_DELIVERIES — Returns the number of days associated with top deliveries activity for a given day and organization. This is the function most commonly searched by users investigating delivery performance metrics.
  • GET_TOP_CUSTOMERS — A procedure that populates top-customer analytical data for a specified period, currency, and organization. It writes results for downstream reporting.
  • GET_BBB_INFO — A procedure that gathers "Better Business Bureau"-style or comparable order fulfillment performance information for a specified period, currency, and organization.

Note that GET_DAYS_TOP_RETURNS and GET_DAYS_TOP_DELIVERIES carry the PRAGMA RESTRICT_REFERENCES directive limiting side effects (WNDS, RNPS, WNPS), confirming their role as read-oriented scalar functions. No parameter lists are invented here beyond what the documented metadata shows.

Tables Accessed

The package references several base and staging tables through APPS synonyms:

  • GL_PERIODS — Used to resolve accounting period boundaries for period-based reporting functions such as GET_TOP_CUSTOMERS and GET_BBB_INFO.
  • SO_HEADERS_ALL — The order header table, read to obtain order-level attributes such as customer, currency, and organization for aggregation.
  • SO_LINES_ALL — The order line table, read for quantity, value, shipment, and returns detail used in the analytical calculations.
  • OE_BIS_TOP_CUSTOMERS — A results/staging table populated by GET_TOP_CUSTOMERS for top-customer rankings.
  • OE_BIS_BBB_INFO — A results/staging table populated by GET_BBB_INFO for fulfillment performance information.

Usage Notes

OE_BIS is typically invoked from Oracle Order Management reporting forms, concurrent programs, or custom BI dashboards that surface daily shipping value, delivery performance, returns, and top-customer metrics. Because it is documented as referenced by zero other packages, it is not a dependency of standard outbound APIs; it functions as a leaf-level reporting utility. Calls are made under the invoking user's privileges due to AUTHID CURRENT_USER, so appropriate data access to SO_HEADERS_ALL, SO_LINES_ALL, and GL_PERIODS is required. The functions are suitable for direct SQL or PL/SQL invocation, while the procedures are designed to populate the OE_BIS staging tables for subsequent query. In Oracle EBS 12.1.1 and 12.2.2, the package remains an internal analytical object rather than a supported integration interface.