Results for “hr_dflex_utility”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
HR_DFLEX_UTILITY is an Oracle Application Object Library utility package body in the APPS schema that supports the Descriptive Flexfield (DFF) infrastructure used across Oracle E-Business Suite Release 12.1.1 and 12.2.2. Its principal business function is to manage the validation behavior of descriptive flexfield segments, most notably by allowing specific DFF validation routines to be suppressed (ignored) when a calling process, form, or interface does not require — or cannot satisfy — standard segment validation. The package also maintains descriptive flexfield attribute metadata, reconciling flexfield usage definitions with the underlying column and context definitions.
The package is registered with a status of VALID and is classified under the API classification OTHER, indicating that it is an internal support utility rather than a published, externally supported integration API. Despite this internal classification, it is heavily depended upon: the ETRM documentation records that HR_DFLEX_UTILITY is referenced by 228 other database objects, placing it among the more broadly consumed utility packages in the HR and flexfield layer.
Key Procedures and Functions
The documented package exposes four procedures and functions:
- CREATE_IGNORE_DF_VALIDATION — Establishes an "ignore descriptive flexfield validation" directive for the current session or process, registering the flexfield application and context whose validation should be bypassed.
- CHECK_IGNORE_DF_VARRAY — Tests whether a given descriptive flexfield validation directive is present in an in-memory PL/SQL table (varying array) of ignored validations. The PLITBLM dependency confirms the use of PL/SQL table types.
- REMOVE_IGNORE_DF_VALIDATION — Reverses CREATE_IGNORE_DF_VALIDATION, removing the previously registered bypass so that normal descriptive flexfield validation resumes.
- INS_OR_UPD_DESCFLEX_ATTRIBS — Inserts or updates descriptive flexfield attribute records, keeping flexfield segment attribute metadata synchronized with the flexfield definitions held in the FND_DESCR_FLEX_* tables.
Parameter lists are not documented in the available metadata and are therefore not reproduced here; the descriptions above reflect documented purpose only.
Tables Accessed
The package reads and writes the following documented tables via APPS synonyms:
- FND_APPLICATION — resolves the application owning a descriptive flexfield.
- FND_DESCR_FLEX_COLUMN_USAGES — the core repository of descriptive flexfield segment-to-column usage definitions.
- FND_DESCR_FLEX_COL_USAGE_TL — the translated (language-specific) prompt and description text for those column usages.
- FND_DESCR_FLEX_CONTEXTS — context (global and context-sensitive segment) definitions.
- FND_SESSIONS — session-level state used to scope validation directives.
- PER_ALL_PEOPLE_F — the HR people table, read to validate HR-related flexfield attribute values against the person record.
- PLITBLM — the standard PL/SQL table-of-varchar2 type used for the in-memory ignored-validation array.
Usage Notes
HR_DFLEX_UTILITY is not intended for direct invocation by end users or external integrations. It is called internally by Oracle HRMS forms, concurrent programs, and the broader HR API stack (HR_API, HR_UTILITY, HR_MESSAGE, HR_MULTI_MESSAGE) whenever a process must load or save records containing descriptive flexfields but must temporarily suppress segment validation — for example, data migrations, interface/conversion routines, or mass updates where legacy data does not conform to current DFF value sets. Custom code should prefer the supported HR_API and FND_DFLEX interfaces and treat HR_DFLEX_UTILITY as an internal dependency, since its procedures are classified OTHER and are not part of the documented public API surface. The presence of APP_EXCEPTION and FND_MESSAGE in the dependency list indicates that errors are raised through the standard Oracle error-handling and message-framework mechanisms.