Search Results bis_previous_effective_start_date

Overview

ISC_FS_INV_RPT_PKG is an Oracle E-Business Suite PL/SQL package body owned by the APPS schema that supports the reporting layer of Oracle Inventory and Cost Management within the Enterprise Territory and Resource Management / channel revenue context. Its principal role is to construct the dynamic SQL fragments and metadata references required to render inventory value and demand-based inventory reporting against the pre-aggregated materialized views used by Oracle's business intelligence reporting framework. The package is part of the ISC (Inventory Supply Chain) family of reporting utilities and is closely coupled with the ISC_FS_RPT_UTIL_PKG helper package, which supplies parameter extraction and bind group management services.

The package operates as a report definition provider rather than a general-purpose business API. It returns SQL text fragments that are interpolated into the query generated by the ETRM reporting engine, allowing the same logical inventory report to be pointed at different underlying materialized views depending on the report type and time-comparison semantics selected by the end user.

Key Procedures and Functions

• GET_TBL_SQL — Generates the SQL statement that retrieves the aggregated inventory fact data for a given report definition. This function resolves the appropriate fact materialized view name based on the report type, including the inventory value views ISC_FS_015_MV and ISC_FS_016_MV, and applies the group identifier and dimension bind mapping supplied through the page parameter table.
• GET_TRD_SQL — Produces the SQL used to retrieve the time-dimension or trend-related dataset associated with the inventory report. It complements GET_TBL_SQL by supplying the period and comparison axis required for yearly or sequential time comparison reporting.

Both functions work in conjunction with internal logic such as GET_FACT_MV_NAME, which inspects the TIME_COMPARISON_TYPE and PERIOD_TYPE parameters to decide which physical view backs the report, and calls ISC_FS_RPT_UTIL_PKG.BIND_GROUP_ID to register dimension bind groups for inventory category and item organization.

Tables Accessed

The documented table reference for this package, resolved through APPS synonyms, is PLITBLM, a PL/SQL index-by table type used to pass and carry collections of values internally between the reporting utility routines. In addition to this PL/SQL structure, the generated SQL targets inventory fact materialized views, principally ISC_FS_015_MV for inventory value reporting and ISC_FS_016_MV for unit and dollar on-hand value reporting, both filtered by the run-time group identifier.

Usage Notes

ISC_FS_INV_RPT_PKG is not typically invoked directly by end users or by custom application code. It is called by the Oracle EBS business intelligence reporting framework when an inventory report definition is executed, most often from a report page or concurrent program driven by the ETRM reporting engine. The user search term "bis_previous_effective_start_date" reflects the broader BIS reporting infrastructure with which this package interoperates, particularly the BIS_PMV_PAGE_PARAMETER_TBL and BIS_QUERY_ATTRIBUTES_TBL structures used to carry page parameters and query output definitions. Because the package returns SQL text rather than executing it, any consumer must supply a valid group identifier and a populated parameter table for correct operation. Customizations should be limited to report definitions rather than modification of this package body, which is a shipped Oracle object.