Search Results isc_dbi_days_ship_pkg

Overview

ISC_DBI_DAYS_SHIP_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that forms part of the Oracle Supply Chain Intelligence (ISC) and Daily Business Intelligence (DBI) reporting infrastructure. Its functional purpose is to supply the SQL query definition behind the "Days to Ship" performance metric — a supply chain KPI that measures the elapsed time between order entry or booking and the shipment of goods to the customer. This metric allows planners, order management analysts, and supply chain managers to monitor fulfillment cycle time, identify bottlenecks in the order-to-ship process, and benchmark performance across organizations, customers, and time periods.

The package is a pure query-generation ("SQL provider") utility rather than a transactional API. It contains no business logic that modifies application data; instead, it returns a SQL statement that the DBI/BI Publisher reporting engine executes at runtime to populate a dashboard region or concurrent program output.

Key Procedures and Functions

• GET_SQL — The single documented routine in the package. It constructs and returns the SQL query text used to calculate the Days to Ship metric. In the standard DBI architecture, GET_SQL is called by the reporting framework (through the BIS_PMV_PAGE_PARAMETER_TBL and BIS_QUERY_ATTRIBUTES_TBL metadata tables) to obtain the query string, which is then executed and rendered in a Daily Business Intelligence dashboard page. Parameter lists are not exposed in the documented metadata and should be confirmed by inspecting the package specification in the target environment; callers conventionally pass identifying context such as the page, region, or query identifier so the routine can return the correctly filtered statement.

The presence of both a Package specification and a Package body, with a status of VALID, indicates the object is fully compiled and callable in the documented 12.1.1 environment.

Tables Accessed

• PLITBLM — Referenced through an APPS synonym. In Oracle EBS this is the PL/SQL table of lines (the standard PLITBLM index-by table type) used internally by the package to hold or assemble query lines and parameter strings before they are returned to the caller.
• BIS_PMV_PAGE_PARAMETER_TBL — A DBI framework table that stores page-level parameter definitions used by the reporting engine when invoking the query provider.
• BIS_QUERY_ATTRIBUTES_TBL — A DBI framework table holding query attribute configuration, including the association between a query definition and its provider package.

These dependencies confirm the package operates within the standard BIS/DBI metadata-driven reporting model rather than accessing operational order or shipping tables directly; the actual data extraction is performed by the generated SQL at execution time.

Usage Notes

ISC_DBI_DAYS_SHIP_PKG is not invoked directly from Oracle Forms or from typical end-user concurrent programs. It is called by the Daily Business Intelligence engine when a user opens the relevant supply chain dashboard page containing the Days to Ship region, or when a scheduled DBI collection/refresh process regenerates the page content. The framework resolves the query provider through the BIS metadata tables, calls GET_SQL, executes the returned statement, and formats the results.

Customization should be approached with caution. Because the package is registered as a DBI query provider, modifying GET_SQL alters the shipped metric and can affect dashboard consistency across patches. Any extension should be layered through supported DBI page customization or by creating an equivalent custom provider package rather than editing the seeded APPS object. The package is referenced by no other documented packages, so its impact surface is limited to the DBI reporting layer.