Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Fusion Benefits Rate Start Date Fast Formula

3397090Jul 17 2017 — edited Jul 17 2017

Hi Everyone,

My Requirement.

Assume an employee is hired and placed on biweekly payroll. New hire life event is processed and benefits are elected. Requirement is that the new rates should start from the first check date [ Date Paid ] in month following hire date.

-I have tried three options.

DEFAULT_DATA_VALUE FOR US_TPI_PAYROLL_CHECK_DATE IS '1900/01/01 00:00:00' (date)

L_DATE_PAID = US_TPI_PAYROLL_CHECK_DATE

RT_STRT_DT = L_DATE_PAID

return L_DATE_PAID

Error:-

" The rate start date cannot be determined. Check the rate start date configuration for this plan or program. (BEN-990151)

If the plan design allows for an enterable rate start date, ensure that a date is entered.

There might also be a configuration error whereby the rate start date rule and the rate end date rule are mismatched, and provide either a gap or an overlap.

It is also possible that a rate start date formula requires revision."

DEFAULT_DATA_VALUE FOR PAY_ACT_REP_PRA_PAID_EFF_DATE IS '1900/01/01 00:00:00' (date)

L_DATE_PAID = PAY_ACT_REP_PRA_PAID_EFF_DATE

RT_STRT_DT = L_DATE_PAID

return L_DATE_PAID

Error:- This DataBase Item is Empty or Too large.

rate_sd_date = BEN_FN_GET_CHAR_VALUE('PAY_TIME_PERIODS','START_DATE',' ',' ','START_DATE')

Date_Paid = BEN_FN_GET_CHAR_VALUE('PAY_TIME_PERIODS','DATE_PAID',' ',' ','DATE_PAID')

l_sd_converted_date='1951/01/01 00:00:00' (date)

Date_Paid = rate_sd_date

return Date_Paid

Error:-

" The rate start date cannot be determined. Check the rate start date configuration for this plan or program. (BEN-990151)

If the plan design allows for an enterable rate start date, ensure that a date is entered.

There might also be a configuration error whereby the rate start date rule and the rate end date rule are mismatched, and provide either a gap or an overlap.

It is also possible that a rate start date formula requires revision."

Could you make out what I might be missing or where I might be going wrong ?

Thanks,

Sudakar

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 14 2017
Added on Jul 17 2017
0 comments
679 views