Results for “ben_once_r_cntng”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

APPS.BENBV_HRS_WKD_IN_PERD_FCTR_V is a business-group-secured reporting view over the Oracle Advanced Benefits (BEN) "Hours Worked in Period Factor" entity. It presents the configuration records that control how the Benefits engine determines hours worked within a defined period for eligibility, proration, and related benefit calculations. Rather than exposing raw coded values from the underlying table, the view enriches each row with decoded, user-facing descriptions by calling the HR_BIS.BIS_DECODE_LOOKUP function against a set of BEN lookups. This makes the view suitable for concurrent program extracts, BI Publisher reports, Fast Formulas diagnostics, and integration queries where a readable representation of the factor setup is required.

The view name follows the standard Oracle EBS "BENBV" (Benefits Business View) convention, and the underlying table is exposed through a synonym, BEN_HRS_WKD_IN_PERD_FCTR. The view is defined WITH READ ONLY, so it is intended strictly for query and reporting rather than DML.

Underlying Base Objects

The view is defined over two documented objects:

• BEN_HRS_WKD_IN_PERD_FCTR (SYNONYM) — the synonym resolving to the BEN base table that stores hours-worked-in-period factor definitions. All business columns, ID columns, WHO columns, and the descriptive flexfield reference originate here.
• HR_BIS (PACKAGE) — the HR/Benefits "Business Intelligence Service" package whose BIS_DECODE_LOOKUP function translates stored lookup codes into decoded meanings, and whose GET_SEC_PROFILE_BG_ID function supplies the security profile business group used in the WHERE clause.

Row-level security is applied by filtering on HWF.BUSINESS_GROUP_ID = NVL(HR_BIS.GET_SEC_PROFILE_BG_ID, HWF.BUSINESS_GROUP_ID). When the session's security profile returns a business group ID, only rows for that business group are visible; when it returns NULL, all business groups are returned. This is consistent with standard Oracle EBS multi-tenancy and security-profile behavior in 12.1.1 and 12.2.2.

Key Columns

• NAME — the name of the hours-worked-in-period factor definition.
• HRS_WKD_CALC_RL, HRS_WKD_DET_RL, RNDG_RL — rules governing calculation, detail determination, and rounding.
• MN_HRS_NUM, MX_HRS_NUM — minimum and maximum hours numeric thresholds applied to the factor.
• PYRL_FREQ_CD and its decoded value — payroll frequency, decoded via the BEN_FREQ lookup.
• HRS_SRC_CD — source of hours, decoded through BEN_HRS_WKD_SRC.
• RNDG_CD — rounding method, decoded through BEN_RNDG.
• HRS_WKD_DET_CD — hours-worked detail code, decoded through BEN_HRS_WKD_DET.
• ONCE_R_CNTUG_CD — "once per contingency" indicator, decoded through BEN_ONCE_R_CNTNG.
• HRS_WKD_BNDRY_PERD_CD — boundary period code; note the decode uses lookup type LOOKUP_NOT_FOUND.
• HRS_ALT_VAL_TO_USE_CD — the alternative value to use when hours worked cannot be determined. This is the column most relevant to the user search term ben_hrs_alt_val_to_use, and it is decoded through the BEN_HRS_ALT_VAL_TO_USE lookup type.
• NO_MX_HRS_WKD_FLAG, NO_MN_HRS_WKD_FLAG — yes/no flags, both decoded through YES_NO.
• Descriptive flexfield — exposed as the token '_DF:BEN:BEN_HRS_WKD_IN_PERD_FCTR:HWF'.
• ID and WHO columns — HRS_WKD_IN_PERD_FCTR_ID, BUSINESS_GROUP_ID, BNFTS_BAL_ID, DEFINED_BALANCE_ID, plus LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATED_BY, and CREATION_DATE.

Common Use Cases and Queries

The view supports configuration audits, eligibility troubleshooting, and migration extracts. A typical query isolating alternative-value behavior for a business group follows:

• SELECT name, hrs_alt_val_to_use_cd, pyrl_freq_cd, hrs_src_cd, mn_hrs_num, mx_hrs_num FROM apps.benbv_hrs_wkd_in_perd_fctr_v WHERE hrs_alt_val_to_use_cd IS NOT NULL ORDER BY name;
• Filtering by payroll frequency and rounding: SELECT name, rndg_cd, py_rl_freq_cd FROM apps.benbv_hrs_wkd_in_perd_fctr_v WHERE py_rl_freq_cd = 'M';
• Reviewing flexfield-configured factors: SELECT hrs_wkd_in_perd_fctr_id, name FROM apps.benbv_hrs_wkd_in_perd_fctr_v WHERE hrs_wkd_in_perd_fctr_id = :p_id;

Because decoded columns are produced through BIS_DECODE_LOOKUP, query performance benefits from filtering on code columns rather than on decoded descriptions, and the view should be treated as read-only in all deployments.