Search Results run_report

Overview

The APPS.HR_DE_WORK_INCIDENT_REPORT package is a German-localized (DE) Oracle E-Business Suite database package that provides the backend PL/SQL implementation for reporting on workplace incidents. In the context of Oracle EBS 12.1.1 and 12.2.2, the package supports statutory and internal reporting requirements associated with recording and outputting work incidents (Arbeitsunfälle and related events) captured within the HR incident tracking functionality. The package is defined with AUTHID CURRENT_USER, meaning it executes with the privileges of the invoking user rather than the defining schema, and its source header indicates it has been maintained as a non-shipped (noship) object within the APPS schema.

The primary business purpose of the package is, per its embedded source comment, to "Output work incidents." It therefore acts as the executable engine behind a concurrent program or report that extracts incident data for a specified business group and date range, delivering the results to the concurrent manager output. Because it is a report driver rather than an open interface or business API, it is classified in ETRM as OTHER rather than as a public API.

Key Procedures and Functions

• RUN_REPORT — The single documented procedure exposed by this package. It serves as the standard concurrent program entry point, accepting the errbuf and retcode OUT parameters required by the Oracle Concurrent Manager and input parameters for the business group and reporting date range. When invoked, it drives the extraction and output of work incident records for the selected organization and period. Its signature follows the conventional report template used throughout EBS concurrent processing, where the caller supplies the business group identifier and from/to date values to scope the returned data set.

No additional procedures or functions are documented in the ETRM metadata. The package specification exposes only the procedure listed above; any internal helper logic resides in the package body and is not part of the documented interface.

Tables Accessed

The documented table reference for this package is FND_SESSIONS, accessed through an APPS synonym. FND_SESSIONS is part of the Oracle Application Object Library (AOL) foundation and is commonly used to resolve runtime session context, such as the effective user, responsibility, and application information during concurrent execution. The package likely consults this table to establish session or environment context while the report runs. It should be noted that the metadata lists only this foundation table; the underlying business data tables containing the actual work incident records are not enumerated in the documented references and would be resolved within the package body. Implementers performing impact analysis should therefore treat the documented table list as incomplete for data lineage purposes and inspect the package body for the full set of accessed objects.

Usage Notes

• Concurrent program invocation: The procedure is designed to be registered as a concurrent program executable, with the business group and date parameters exposed as report parameters. Users submit it from the standard Submit Requests form or a responsibility-specific menu.
• Localization scope: Because the package name carries the HR_DE prefix, it is specific to the German localization. It should be invoked in environments where the German HR legislative functionality is installed and configured.
• Custom code: While the procedure can technically be called from custom PL/SQL, it is intended for concurrent manager execution. Direct calls must supply the errbuf and retcode OUT variables in the expected format.
• Version applicability: The object metadata is documented for ETRM 12.2.2 and applies equally to 12.1.1; the source header revision suggests the package has remained stable across releases.