Search Results run_diagnostic




Overview
Explore in AI Chat

Overview

HRI_BPL_DATA_SETUP_DGNSTC is a diagnostic utility package owned by the APPS schema in Oracle E-Business Suite. Its purpose is to support the Human Resources Intelligence (HRI) data setup diagnostic framework, providing the programmatic engine that validates the configuration and integrity of HRMS and related setup data. In release 12.1.1 and 12.2.2 the package is classified as OTHER, meaning it is not exposed as a public integration API but as an internal diagnostic instrument invoked by the diagnostic UI or by administrators performing troubleshooting.

The package header, versioned as hribdgdp.pkh, defines the type structures and procedure signatures used to collect and return diagnostic results. It is a read-only inspection tool: it examines setup rows across the HRMS schema and reports findings, impacts, and remediation links rather than altering transactional data.

Key Procedures and Functions

The package exposes three documented program units.

  • RUN_DIAGNOSTIC — The primary entry point and the object referenced in the "run_diagnostic" search. It accepts an object name and type identifying the setup entity to be examined, a mode controlling the diagnostic behavior, an effective date range, and a row limit. It returns a tabular result set together with an impact indicator, an impact message, a documentation link URL, and the dynamically constructed SQL statement used for the check. This is the routine that drives the diagnostic engine.
  • DEBUG_SUP_LOOP — A debugging routine that walks the supervisor hierarchy for a given person as of an effective date. It returns a loop results table containing person and supervisor names and numbers, enabling developers and support analysts to trace supervisory chain logic used by the diagnostic.
  • GET_DYNAMIC_SQL — A function that returns the dynamic SQL text for a supplied SQL type and statement identifier. It centralizes the construction of the flexible, data-driven queries that RUN_DIAGNOSTIC executes.

The header additionally declares collection types for data columns and results, and a record type capturing person, person number, supervisor name, and supervisor number, which are used to structure diagnostic output.

Tables Accessed

The package references the following tables through APPS synonyms.

  • HRI_ADM_DGNSTC_SETUP — The diagnostic configuration table that defines diagnostic setup and metadata driving RUN_DIAGNOSTIC.
  • PER_ALL_PEOPLE_F — The dated person table, supplying full names and employee numbers for persons and their supervisors.
  • PER_ALL_ASSIGNMENTS_F — The dated assignment table, providing assignment context for the persons under examination.
  • PER_ASSIGNMENT_STATUS_TYPES — Supply status type values used to filter or classify assignment records.
  • PLITBLM — The standard PL/SQL table used for temporary storage during processing.

Usage Notes

HRI_BPL_DATA_SETUP_DGNSTC is normally invoked indirectly through the HRMS diagnostic framework rather than called directly by end users. Administrators reach it through the diagnostic or data setup validation pages, where RUN_DIAGNOSTIC is executed for the selected setup object. Because the package is referenced by two other packages, it also functions as a lower-level service within the diagnostic layer.

Custom code should treat the package as read-only and subject to change between patch levels. Customers requiring persistent extensions should wrap rather than modify the source, and should validate behavior in a clone before production use.