Search Results get_uci




Overview
Explore in AI Chat

Overview

APPS.HR_DE_GENERAL is a German localization PL/SQL package in Oracle E-Business Suite (validated for 12.1.1 and 12.2.2) that provides shared utility logic for human resources data specific to Germany. It belongs to the broader HR_DE family of objects used by Oracle HRMS to manage country-specific legislative requirements, such as social insurance, tax offices, and organizational reporting. The package is classified as an OTHER API in the ETRM metadata, indicating it is intended primarily for internal use by Oracle forms, views, and concurrent programs rather than as a formally published public API. It is owned by the APPS schema and has a VALID status.

The package acts as a reusable helper layer, centralizing lookups and derivations that multiple HR and payroll components require. Rather than duplicating logic such as currency resolution, UCI (Unternehmensnummer/company identifier) retrieval, or end-reason decoding across German HR objects, this package exposes a single set of functions and procedures. It is referenced by several German HR views and payroll archive programs, making it a dependency for country-specific reporting and data extraction.

Key Procedures and Functions

The ETRM metadata documents nine procedures/functions:

  • GET_THREE_DIGIT_CODE — Returns a three-digit code, typically used for German statutory classifications such as tax or social insurance category codes.
  • GET_SOCIAL_INSURANCE_GLOBALS — Retrieves global social insurance configuration values used across German payroll and HR processing.
  • BUSINESS_GROUP_CURRENCY — Resolves the currency associated with a given business group, leveraging FND_CURRENCIES.
  • GET_TAX_OFFICE_DETAILS — Returns details for a German tax office (Finanzamt) based on the relevant identifier.
  • GET_UCI — Retrieves the UCI (company identifier) value for German statutory reporting.
  • GET_ORG_NAME — Returns the name of an organization unit, drawn from HR organization data.
  • MAX_TAX_INFO_DATE — Determines the latest (maximum) tax information effective date for an employee or record.
  • GET_END_REASON_NO — Returns the numeric code for a social insurance end reason.
  • GET_END_REASON_DESC — Returns the descriptive text for a social insurance end reason.

These routines are consumed by views such as HR_DE_SOCIAL_INSURANCE_INFO_V, HR_DE_TAX_INFORMATION_V, HR_DE_SOCINS_PROV_DEFINITION_V, HR_DE_TAX_OFFICE_DEFINITION_V, and HR_ORGANIZATION_INFORMATION_V1.

Tables Accessed

The package reads from a mix of standard and German-specific tables via APPS synonyms. FND_CURRENCIES supplies currency definitions for BUSINESS_GROUP_CURRENCY. HR_ALL_ORGANIZATION_UNITS and HR_ORGANIZATION_INFORMATION provide organization names and attributes used by GET_ORG_NAME and organizational views. PAY_ELEMENT_ENTRIES_F, PAY_USER_COLUMNS, PAY_USER_COLUMN_INSTANCES_F, PAY_USER_ROWS_F, and PAY_USER_TABLES are Oracle Payroll flexfield structures used to resolve user-defined statutory values, including tax and social insurance details. PQH_DE_INS_END_REASONS holds the German social insurance end-reason definitions backing GET_END_REASON_NO and GET_END_REASON_DESC.

Usage Notes

HR_DE_GENERAL is typically invoked indirectly. German HRMS forms, the German HR views listed above, and payroll archive concurrent programs (PAY_NO_ARCHIVE_RSEA, PAY_NO_ARC_RSEA_07, PAY_NO_EOY_ARCHIVE, PAY_NO_PAYSLIP_ARCHIVE) call it to populate statutory fields during queries, payslip generation, and year-end processing. It is referenced by nine other packages, so customizations should call it rather than reimplement its logic. Because it is classified as OTHER, direct custom invocation is possible but should be validated against patch-level changes; the interface is not guaranteed as a public API. Developers extending German HR reports can rely on it for consistent currency, tax office, UCI, and social insurance end-reason resolution.