Search Results bis_pmv_page_parameter_rec




Overview
Explore in AI Chat

Overview

APPS.ISC_DBI_DAYS_SHIP_PKG is a PL/SQL package body owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. Its name associates it with the Oracle Supply Chain (ISC) product family and the DBI (Daily Business Intelligence) reporting framework, and the DAYS_SHIP suffix indicates its focus on the days-to-ship metric, a supply chain performance indicator commonly used to measure the average elapsed time between order entry and shipment. The package is classified as OTHER in the ETRM functional specification, meaning it is a utility or helper object rather than a public API with a formal business interface. Its role is to supply the SQL query text that drives a DBI performance management view, allowing the reporting layer to dynamically retrieve metric data without embedding query logic in the view definition itself. The package body carries a VALID status in the APPS schema, and Oracle marks it as proprietary and confidential.

Key Procedures and Functions

The ETRM metadata documents a single procedure or function within this package body:

  • GET_SQL — The entry point that returns the SQL statement or statements used to populate the days-to-ship DBI page. It is the mechanism by which the performance management view obtains its query definition at runtime.

The package body also participates in the DBI parameter-framework conventions, as evidenced by its dependencies on BIS_PMV_PARAMETERS_PUB, BIS_PMV_PAGE_PARAMETER_REC, and BIS_PMV_PAGE_PARAMETER_TBL. These objects belong to the Page Metric View (PMV) subsystem, which passes page and parameter context into the query-generating code. The dependency on BIS_QUERY_ATTRIBUTES and BIS_QUERY_ATTRIBUTES_TBL shows that the package declares the columns, data types, and formatting attributes of the result set produced by GET_SQL. No parameter lists are documented in the ETRM metadata, so callers should treat the signature as defined by the installed source rather than by any published specification.

Tables Accessed

The documented table reference for this package is PLITBLM, which appears through an APPS synonym. PLITBLM is a PL/SQL inter-language table type used internally by the PL/SQL engine to materialize collections; it is not an application data table and therefore should not be interpreted as a business data source. The substantive data access performed by the days-to-ship metric is contained within the dynamic SQL returned by GET_SQL, which queries the underlying supply chain shipping and order tables at execution time. Consequently, the ETRM dependency listing captures the package's static compile-time references rather than the full set of tables touched during runtime query execution.

Usage Notes

ISC_DBI_DAYS_SHIP_PKG is not referenced by any other database object, confirming that it is invoked by the DBI runtime through dynamic or reflective means rather than by direct static calls from other PL/SQL units. In practice it is executed when a user opens or refreshes the corresponding Days to Ship page in the Oracle Daily Business Intelligence for Supply Chain responsibility, or when a related concurrent program or scheduled DBI data refresh invokes the PMV query framework. The BIS_PMV_PARAMETERS_PUB dependency indicates that the framework may call the package to obtain SQL in response to parameter changes, such as selecting an operating unit, date range, or organization. Implementers extending or debugging the metric should review the GET_SQL output to understand the actual data sources, and should be aware that modifications are not supported by Oracle. Because the package is classified as OTHER with no public API status, custom code should not call it directly; instead, customization efforts should target the DBI view configuration or the underlying query logic exposed through supported extension mechanisms.