Search Results isc_fs_inv_rpt_pkg

Overview

ISC_FS_INV_RPT_PKG is an Oracle E-Business Suite PL/SQL package owned by the APPS schema that supports the inventory reporting layer of Oracle Supply Chain Intelligence (formerly Daily Business Intelligence). The package is classified as OTHER in the ETRM and forms part of the ISC (Inventory, Shipping, and Costing) family of reporting packages that underpin the pre-built inventory dashboards and analytical regions delivered with the EBS Intelligence application. Its role is to supply the dynamic SQL and output attribute definitions that the Business Intelligence System (BIS) page framework requires in order to render inventory-related report regions at runtime. The package does not maintain transactional data; instead, it acts as a metadata provider, returning custom SQL statements and their corresponding column definitions to the BIS engine, which executes them against the reporting tables and returns the result set to the user interface. The header comment identifies the file as iscfsinvrpts.pls, indicates a version of 120.0 dated 2005/08/28, and carries the "noship" designation, reflecting its historical development lineage in the Oracle EBS Intelligence release stream. The same package source is present in both EBS 12.1.1 and 12.2.2, as the BIS reporting layer was carried forward largely unchanged between these releases.

Key Procedures and Functions

The package exposes two documented procedures, both of which conform to the standard BIS custom SQL provider signature used throughout the EBS Intelligence reporting framework.

• GET_TBL_SQL — Returns a custom SQL statement and its associated output column attributes for a table-style inventory report region. This is the procedure most commonly located by administrators and developers searching for "get_tbl_sql" within the EBS codebase, since the name is shared with several sibling ISC reporting packages that each implement their own region-specific variant. It receives the BIS page parameter table and returns the SQL text and query attribute definitions to the calling BIS framework.
• GET_TRD_SQL — Returns a custom SQL statement and output attribute definitions for a trend-style inventory report region. The "TRD" mnemonic follows the BIS convention for trend reports, which display period-over-period comparisons rather than flat tabular output.

Both procedures use the standard BIS parameter and output types (BIS_PMV_PAGE_PARAMETER_TBL, BIS_QUERY_ATTRIBUTES_TBL) and declare their output parameters as NOCOPY for performance. The ETRM documents no additional public or private members.

Tables Accessed

The only table documented against this package through APPS synonyms is PLITBLM. This is a standard BIS framework table that stores multilingual prompt and label information used when rendering page regions. The package references it so that the generated report output can be presented with the correct language-specific column headings and row descriptions. The business data returned to the user is not read directly by this package; it is read by the BIS engine when it executes the SQL text that GET_TBL_SQL and GET_TRD_SQL construct and pass back.

Usage Notes

ISC_FS_INV_RPT_PKG is not invoked directly by end users or by ordinary custom code. It is called by the BIS page rendering framework when a user opens an inventory dashboard region that has been configured to source its data from a custom SQL provider. In practice this means the package is exercised through the OBI/BIS administrative pages and the corresponding EBS Intelligence responsibilities, where the region definition points at ISC_FS_INV_RPT_PKG as its data source. Because the procedures return SQL text rather than a result set, the framework must have already validated the page parameters before the call, and any failure inside the SQL string propagates as an error at execution time in the reporting engine rather than at invocation time in the package. Customizations should generally avoid modifying this package in place, since it is a shipped Oracle object and is replaced during patching; extensions are better implemented as a new BIS custom SQL provider package registered against the region. The ETRM records no other packages referencing ISC_FS_INV_RPT_PKG, confirming it is a leaf provider in the reporting call graph.