Search Results get_page_params




Overview
Explore in AI Chat

Overview

APPS.ISC_DBI_PLAN_PARAM_PKG is a database package body in the Oracle E-Business Suite Advanced Planning and Demand Planning (DBI) modules. Its documented purpose is to supply default parameter values consumed by the Plan Management page parameter portlet within the DBI/Planning analytics framework. In practice, the package serves as a lightweight parameter access layer: rather than requiring the user or the calling page to derive context values (such as which plan snapshot is currently active, which planning currency is in force, or which enterprise period applies), the portlet invokes these functions to retrieve canonical defaults from the underlying plan snapshot and time dimension tables.

The package was shipped under the header revision recorded in the source ($Header: ISCRGAGB.pls 120.0), and is classified as an "OTHER" API, meaning Oracle does not publish it as a supported public interface for customer extension. It is an internal utility package. Its functions are read-only and stateless, each returning a scalar value through a simple SELECT against a view or table, which makes it cheap to call repeatedly from page-rendering logic. The object is documented as being referenced by zero other packages, indicating that its consumers are UI-layer constructs (the parameter portlet) rather than other PL/SQL units.

Key Procedures and Functions

  • get_plan — Returns the plan snapshot identifier of the first row following the "NA" (None Plan) entry. The underlying view is pre-sorted by plan run date and plan name, so the function effectively identifies the most current meaningful plan to use as the default selection.
  • get_plan_currency — Returns the DBI Global currency code. The documented implementation returns the constant 'FII_GLOBAL1', representing the DBI global currency designation rather than a plan-specific currency.
  • get_plan_period — Returns the current enterprise period identifier by locating the row in the enterprise time period table whose start and end dates encompass the system date.
  • a — Returns the earliest data start date across all plan snapshots, providing the lower bound of available planning data.
  • b — Returns the latest data end date (cutoff date) across all plan snapshots, providing the upper bound of available planning data.
  • get_page_params — The function corresponding to the user's search term. It returns all default parameter values for the Plan Management page parameter portlet, aggregating the contextual defaults described above for consumption by the portlet UI.

Tables Accessed

The package reads from two documented objects through APPS synonyms. FII_TIME_ENT_PERIOD is queried by get_plan_period to resolve the enterprise period whose date range contains SYSDATE. ISC_DBI_PLAN_SNAPSHOTS is queried by functions a and b to obtain the minimum data start date and maximum cutoff date across all plan snapshots. Additionally, get_plan selects from the view ISC_PLAN_SNAPSHOT_V, which exposes plan snapshot rows already ordered by run date and plan name for default plan selection. All access is read-only; the package performs no inserts, updates, or deletes.

Usage Notes

ISC_DBI_PLAN_PARAM_PKG is invoked at page-render time by the Plan Management page parameter portlet in the DBI/Planning HTML interface. It is not intended for direct invocation by customer forms or concurrent programs, and Oracle does not document it as an extensible API. Custom code should avoid depending on the package signature, since internal utilities of this class may change without notice between releases. When troubleshooting Parameter Portlet defaults in EBS 12.1.1 or 12.2.2, verifying the contents of ISC_DBI_PLAN_SNAPSHOTS and FII_TIME_ENT_PERIOD is the appropriate diagnostic step, as the package simply reflects those tables.