Search Results get_report_param

Overview

POA_BIS_ALERTS is a PL/SQL package body owned by the APPS schema that provides the core alerting and target-comparison infrastructure for Oracle Purchasing intelligence reporting. Its principal business purpose is to evaluate procurement performance against user-defined targets and to raise workflow-based exceptions when actual results fall outside acceptable ranges. The package underpins the Procurement "alerts" feature, allowing organizations to define target values, tolerance ranges, and notification responsibilities at specific organization, plan, and time-period levels, and then to automatically notify the appropriate parties when performance deviates.

The package is classified as OTHER in the ETRM repository, indicating it is primarily an internal utility rather than a published, general-purpose API. It is not referenced by any other package, and its procedures are invoked directly by concurrent programs or forms that drive the periodic alerting process. The header comment reflects a legacy lineage dating to early E-Business Suite releases, with the last recorded revision in 2003, though the package remains functional in 12.1.1 and 12.2.2.

Key Procedures and Functions

The documented interface exposes approximately twenty-three procedures and functions, organized around target retrieval, period handling, actual-value calculation, and alert processing.

• GET_TARGET_VALUE, GET_TARGET_ORGS — Retrieve target definitions and the organizations associated with a given target level, plan, and time period.
• GET_PERIOD_INFO, GET_CURRENT_PERIOD_INFO, GET_PREVIOUS_PERIOD_INFO — Resolve accounting period boundaries used to align targets and actuals to the correct time frame.
• GET_GL_INFO, GET_VALUE, SET_VALUE — Access General Ledger configuration and provide generic value get/set helpers used throughout the package.
• GET_ACTUAL and the GET_ACTUAL_* family (GET_ACTUAL_POACTLKG_ALL_M, GET_ACTUAL_POACTLKG_OU_M, GET_ACTUAL_POACTLKG_ORG_M, GET_ACTUAL_POASPSAL_ALL_M, GET_ACTUAL_POASPSAL_OU_M) — Compute actual performance metrics at the All, Operating Unit, and Org levels across the POACTLKG and POASPSAL materialized views.
• GET_REPORT_PARAM — Resolves report parameters, the internal helper the user search most likely targeted, supporting the parameterization of alert report output.
• GET_ORG_NAME, INSERT_ROW — Utility procedures for organization naming and row insertion.
• COMPARE_TARGETS — The analytical core that compares retrieved actuals against targets and tolerance ranges.
• PROCESS_ALERT_PREVIOUS_PERIOD, PROCESS_ALERT_CURRENT_PERIOD — Orchestrate the end-to-end alerting workflow for the prior and current periods, invoking comparison and notification logic.

Tables Accessed

The package reads and writes the following documented objects through APPS synonyms:

• BIS_EXCPT_WF_S — Stores workflow exception records generated when targets are breached.
• GL_DAILY_RATES, GL_PERIODS — Supply currency conversion rates and accounting period definitions.
• HR_ORGANIZATION_INFORMATION — Provides organization classification and naming data.
• POA_BIS_SAVINGS — Holds procurement savings and target data central to comparison logic.
• DUAL — Used for single-row PL/SQL computations.
• PLITBLM — A PL/SQL index-by table facility used for in-memory processing.

Usage Notes

POA_BIS_ALERTS is normally invoked indirectly. The primary entry points, PROCESS_ALERT_CURRENT_PERIOD and PROCESS_ALERT_PREVIOUS_PERIOD, are scheduled as concurrent programs that run on a periodic basis to evaluate procurement performance and dispatch workflow notifications. Individual helper procedures such as GET_TARGET_VALUE and GET_ACTUAL are called from these orchestration routines rather than directly by end users. Custom code that needs to reproduce alert behavior should call the public procedures and respect the target-level, plan, time-period, and org-id identifying keys established by the BIS reporting model.