Saving Enrollment Changes Results in Error: APP-PAY-07155: The Hr object is invalid

(Doc ID 259335.1)

Last updated on JULY 18, 2016

Applies to:

Oracle Advanced Benefits - Version 11.5.8 and later
Information in this document applies to any platform.

Symptoms

 

Customer has processed a life event and now wants to change the enrollment.

APP-PAY-07155: The Hr object is invalid.
Cause: The HR object which is attempted to be locked is inconsistent with the corresponding object in the HR schema.
Action: Retry the action with the correct object version number
 


The pyupip trace log shows where the error is. Excerpt from pyupip trace log:

Entering: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger 10
ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger 20
Entering: BEN_BENEFIT_PRVDD_LEDGER_BK3.DELETE_BENEFIT_PRVDD_LEDGER_B 10
Leaving: BEN_BENEFIT_PRVDD_LEDGER_BK3.DELETE_BENEFIT_PRVDD_LEDGER_B 20
Entering: ben_bpl_del.del 5
Entering: ben_bpl_del.del 5
Entering: dt_api.Validate_DT_Del_Mode 5
Entering: dt_api.Validate_DT_Del_Mode 5
Leaving: dt_api.Validate_DT_Del_Mode 10
Leaving: dt_api.Validate_DT_Del_Mode 10
Entering: ben_bpl_shd.lck 5
Leaving: ben_Benefit_Prvdd_Ledger_api.delete_Benefit_Prvdd_Ledger 80
Exception raised in ben_det_enrt_rates.p_det_enrt_rates 10
Status:0
 

The following script further verifies the cause of the issue:


col full_name format a40
col name format a25

PROMPT Before count of duplicate rate records ..

select distinct
per.full_name,
pl.name
from per_all_people_f per,
ben_pl_f pl,
ben_prtt_enrt_rslt_f pen,
ben_prtt_rt_val prv1
where prv1.rt_end_dt = to_date('31/12/4712','dd/mm/rrrr')
and prv1.prtt_rt_val_stat_cd is null
and pen.prtt_enrt_rslt_id = prv1.prtt_enrt_rslt_id
and per.person_id = pen.person_id
and pen.effective_start_date between per.effective_start_date
and per.effective_end_date
and pen.effective_start_date between pl.effective_start_date
and pl.effective_end_date
and pl.pl_id = pen.pl_id
and exists
(select 'x'
from ben_prtt_rt_val prv2
where prv2.prtt_enrt_rslt_id = prv1.prtt_enrt_rslt_id
and prv2.prtt_rt_val_stat_cd is null
and prv2.acty_base_rt_id = prv1.acty_base_rt_id
and prv2.rt_strt_dt >= prv1.rt_strt_dt
and prv2.rt_end_dt >= prv2.rt_strt_dt
and prv2.prtt_rt_val_id <> prv1.prtt_rt_val_id)

 

 

Changes

 Oracle Advanced Benefits - Version: 11.5.7
This problem can occur on any platform.
BENENFEB.fmb - NON Flex Program
BENEFXEB.fmb - Flex Program

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms