Search Results hr_de_work_incident_report




Overview
Explore in AI Chat

Overview

HR_DE_WORK_INCIDENT_REPORT is a PL/SQL package body owned by the APPS schema that supports the German localization of Oracle Human Resources. Its purpose is to generate the statutory work incident report (Arbeitsunfall- bzw. Meldebericht) required under German workplace accident reporting regulations. The package encapsulates the reporting logic used by the German HR legislative and statutory reporting solution delivered with Oracle E-Business Suite localization for Germany (HR_DE), and it produces a formatted output file suitable for submission to the responsible trade association or regulatory body.

In Oracle EBS 12.1.1 and 12.2.2 the object is a standalone, valid package body that exposes a single documented entry point. It is not referenced by any other database object, confirming that it is a leaf-level reporting utility invoked directly rather than through an API chain. The package body depends on several standard supporting utilities, including FND_DATE, FND_FILE, FND_SESSIONS and HR_GENERAL, and it references the HR_DE_WORK_INCIDENTS_REPORT object together with the PER_PEOPLE_F table, indicating that incident records are joined to person and assignment data to produce the report content.

Key Procedures and Functions

  • RUN_REPORT — The single documented program unit in this package. It drives the report generation process: it initialises the output through the FND_FILE utility, resolves session context via FND_SESSIONS, applies date formatting conventions from FND_DATE, and writes the formatted work incident report. It is the procedure invoked by the associated concurrent program and is responsible for orchestrating all data selection, formatting and file output.

Because the ETRM metadata documents only one procedure, there are no additional published entry points. Any internal helper routines exist only as private constructs within the package body and are not exposed for external calls.

Tables Accessed

  • FND_SESSIONS — referenced through an APPS synonym. The package reads session-level context (such as session identifiers and locale settings) to ensure that the report is generated with the correct language, date format and reporting context for the German localization.
  • PER_PEOPLE_F — the effective-dated people table in Oracle HRMS. It is used to retrieve employee details (name, person identifiers and related attributes) for the persons appearing on the report. The effective-date ("_F") nature of the table means the package must supply a date to return the correct row version of each person record.

No other application tables are documented as being accessed directly by this package body; the remaining dependencies are helper packages (FND_DATE, FND_FILE, HR_GENERAL) and the HR_DE_WORK_INCIDENTS_REPORT construct rather than base data tables.

Usage Notes

HR_DE_WORK_INCIDENT_REPORT is intended for use in the German HR statutory reporting flow. It is not referenced by any other database object, so it is not part of an API dependency chain; instead, it is invoked directly, typically from a concurrent program registered in the German HR localization, which supplies the runtime parameters and directs the output to the concurrent manager log or a report file managed through FND_FILE.

Because output is produced through the Oracle file utility, the results are normally retrieved as a text or formatted document rather than through an online form. The package should be treated as a system-owned object: customisations that modify its behaviour are not supported, and any extension should be implemented by wrapping or copying the logic into a custom package. When troubleshooting, verify that the concurrent program definition, the FND_SESSIONS context and the effective dates applied to PER_PEOPLE_F are consistent, since mismatches in any of these cause the report to return incomplete or empty results.