Search Results set_debugging

Overview

APPS.HRI_DBI_WMV_SEPARATION is an Oracle HRMS intelligence (HRMS Intelligence / Daily Business Intelligence) PL/SQL package that consolidates separation and turnover metrics for the Annualized Turnover portlets within Oracle E-Business Suite. The package is defined with AUTHID DEFINER and carries an internal object identifier of HRI_DBI_WMV_SEPARATION, a supervisor context type of HRI_SUPVSR, and an information category of the same name. Separation events are surfaced through the event group HRI_WMV_SEPARATION_EVG, with dedicated constants distinguishing LOSS_SEP (loss event), SEP_INV (involuntary separation), and SEP_VOL (voluntary separation). The package also defines canonical end-of-time and start-of-time character constants via HR_GENERAL and FND_DATE, which are used to bound the reporting window. This object is part of the workforce metrics (WMV) family within the HRMS Intelligence schema, responsible for populating summary tables consumed by manager and executive dashboards. The $Header reference to hridbite.pkh indicates the package belongs to the HRMS intelligence turnover utilities group, and the package is designed to operate both in full-refresh and incremental-refresh modes.

Key Procedures and Functions

• GLOBAL_WMT — a function returning a VARCHAR2 global watermark value used to detect the last processed point of data and to coordinate refresh deltas.
• FULL_REFRESH — refreshes all summary data for the Annualized Turnover portlets within a specified start and end date window (defaulting to end-of-time).
• REFRESH_FROM_DELTAS — refreshes summary data based on events occurring since the last refresh, leveraging the global watermark. This is the incremental, typically scheduled path.
• FULL_REFRESH_DEBUG — a debug-enabled wrapper around FULL_REFRESH that emits diagnostic output for troubleshooting a complete rebuild of turnover summary records.
• REFRESH_FROM_DELTAS_DEBUG — the debug counterpart to REFRESH_FROM_DELTAS, providing detailed tracing during incremental processing.
• SET_DEBUGGING — toggles the package-level debug flag, enabling or disabling the runtime tracing consumed by the debug procedures. This is the procedure referenced by the search term set_debugging.
• SET_CONCURRENT_LOGGING — controls whether the package writes output through the concurrent manager logging framework, allowing diagnostics to be captured in concurrent request logs.

Tables Accessed

• HRI_MB_WMV — the WMV metrics base table holding the summary records the package builds and updates.
• HR_PTL_SUMMARY_DATA and HR_PTL_SUMMARY_DATA_S — portlet summary tables (and their synonym/seed variant) that store aggregated turnover metrics consumed by the Annualized Turnover portlets.
• PER_ALL_ASSIGNMENTS_F — supplies current and historical assignment data used to identify employees and supervisors.
• PER_ASSIGNMENT_STATUS_TYPES — used to classify separation statuses and derive voluntary versus involuntary categorisation.
• PER_PERIODS_OF_SERVICE — the authoritative source for hire and termination dates used to calculate annualized turnover.
• PLITBLM — a PL/SQL index-by table type used internally for array-based processing and bulk operations rather than as a physical table.

Usage Notes

This package is not typically invoked interactively by end users. It is invoked by concurrent programs that schedule full or delta refreshes of turnover summary data for HRMS Intelligence portlets, and it may also be called programmatically from custom code that administers the WMV summary refresh cycle. When diagnosing stale or incorrect turnover figures, administrators typically invoke the debug variants after enabling SET_DEBUGGING, and may additionally enable concurrent logging via SET_CONCURRENT_LOGGING to capture output in the concurrent request log. Because the package is declared AUTHID DEFINER, execution requires appropriate grants on APPS and on the underlying PER tables. In Oracle EBS 12.1.1 and 12.2.2, the package resides in the APPS schema against SYNONYMS over the HRMS intelligence objects, and it is not referenced by other packages, meaning it functions as a top-level refresh utility rather than a shared library.