Search Results incr_refresh

Overview

HRI_OPL_JOBH is an Oracle EBS (APPS) PL/SQL package that belongs to the Oracle Human Resources Intelligence / HRMS "OPL" (Oracle Processing Library) family of packages. It provides the job-history (JOBH) flexfield decoding and refresh logic used by the HR business intelligence and Operational Data Store (ODS) / data warehouse components. The package exists to keep denormalized job-flexfield data synchronized with the underlying key flexfield and descriptive flexfield definitions that drive the PER_JOBS entity, and to generate the supporting list-of-values (LOV) views used in the presentation layer. In Oracle EBS 12.1.1 and 12.2.2 the package owner is APPS and its API classification is OTHER, meaning it is not a public, supported business API but an internal utility invoked primarily by concurrent programs and dependent HR Intelligence packages.

A user searching for "incr_refresh" is typically investigating why a job-history refresh did not run, or is troubleshooting incremental refresh behavior. This package is the object that exposes that refresh entry point.

Key Procedures and Functions

• GET_FLEXFIELD_TYPE — Function that returns the flexfield type for a given job type and value set, used to classify which key flexfield structure applies to a job record.
• GENERATE_LOV_VIEWS — Procedure that builds or rebuilds the dynamic LOV views used by the job flexfield inquiry forms, ensuring the pick lists reflect current flexfield definitions.
• FULL_REFRESH — Procedure (with and without standard concurrent-program OUT parameters errbuf and retcode) that rebuilds the entire job-history flexfield data set from scratch. Used when a complete resynchronization is required.
• INCR_REFRESH — Procedure (available both with and without the concurrent errbuf/retcode pair, and in a form accepting a p_refresh_flex argument) that performs an incremental refresh, processing only changed job flexfield data since the last refresh. This is the object referenced by the "incr_refresh" search term.
• DECODE_KEYFLEX_VALUE — Function that decodes a key flexfield value, taking the flexfield number, job type, and up to thirty segments and returning the corresponding decoded value.
• DECODE_DESCR_FLEX_VALUE — Function that decodes a descriptive flexfield value given the attribute category, job type, and up to twenty-plus attribute columns, returning the decoded description.

Tables Accessed

• PER_JOBS — The base job definition table supplying source key and descriptive flexfield values.
• HRI_CS_JOBH_CT — The job-history collection/change table used to determine which rows require incremental processing.
• HRI_CNFG_JOBH_FLEX_COLS — Configuration table identifying which flexfield columns participate in the job-history extraction.
• HRI_EQ_ASG_SUP_WRFC — Supporting work/refresh-control table for the HR Intelligence job-history process.
• AD_DDL — Applications DDL table used during view generation for dynamic SQL execution.
• PLITBLM — PL/SQL table used to hold collections of values across the decode and refresh routines.

Usage Notes

HRI_OPL_JOBH is not intended for direct subscriber use. It is invoked indirectly: the refresh procedures (FULL_REFRESH, INCR_REFRESH) are surfaced through HR Intelligence concurrent programs, while GENERATE_LOV_VIEWS and the decode functions are called from HR forms and from dependent packages. ETRM records exactly one other package referencing HRI_OPL_JOBH, so customization or overloading of these routines should be treated cautiously. When diagnosing an incremental refresh issue, examine the INCR_REFRESH variants and the errbuf/retcode overloads, which are designed for concurrent-program integration and return status through the standard EBS request output parameters.