Create Potential Life Event in Oracle Advanced Benefits(OAB)

DECLARE

   v_ptnl_ler_for_per_id   NUMBER;

   v_obv_number            NUMBER;

   v_error                 VARCHAR2 (4000);

BEGIN

   DBMS_OUTPUT.ENABLE (1000000);

   apps.ben_ptnl_ler_for_per_api.create_ptnl_ler_for_per

                             (p_validate                      => FALSE,

                              p_ptnl_ler_for_per_id           => v_ptnl_ler_for_per_id,

                              p_lf_evt_ocrd_dt                => SYSDATE

                                                            --v_lf_evt_ocrd_dt

                                                                        ,

                              p_ptnl_ler_for_per_stat_cd      => 'UNPROCD',

                              p_ler_id                        => 17,

                              p_person_id                     => 2596,

                              p_business_group_id             => 0,

                              p_unprocd_dt                    => SYSDATE,

                              p_ntfn_dt                       => SYSDATE,

                              p_object_version_number         => v_obv_number,

                              p_effective_date                => SYSDATE

                             );

EXCEPTION
   WHEN OTHERS
   THEN
      v_error := SUBSTR (SQLERRM, 1, 250);
      DBMS_OUTPUT.put_line (v_error);
END;

Self Service: Using Eligibility Profiles to determine access in Employee Self Service

General Requirement - I am trying out a general approach to restricting access to functions by eligibility profile.

For example, let's say we have an organization with 6 grades A,B,C,D,E,F where A is lowest and F is highest. I want to prevent a user from being able to use the Change Grade function in self service is they are grade A, B or C.

Solution:

This is possible using the SSHR Actions eligibility model.

You need to create an eligibility profile for your Change Grade action using the Employment > Grade criteria for grades D, E and F, i.e. not including grades A, B, and C.

This eligibility profile then needs to be attached to a performance plan linked to your SSHR function for Change Grade, this is done in the 'Plan Eligibility' form task flowed from the 'Plan' form.

Note: The Miscellaneous tab in the Plan form is where you enter the SSHR function name for your Change Grade action. You need to ensure Plan Type has an 'Option Type' of 'Personnel Actions'.

Create a Reporting Group with 'Purpose' of 'Personnel Action' and a 'Function' equal to your Change Grade function name. (Note: If you are using one launch point for all your Manager Actions then instead enter that function name here for the launching function from the menu.) In the components section enter the plan name you previously created.

Last step you need to set the system profiles:

HR:Allow use of eligibility for Self Service actions - Yes
HR:Allow processing of ineligible Self Service actions - No
HR:Run BENMNGLE when processing a Self Service action - Yes

How to Set Eligibility so that an Employee is not Eligible for a Spousal Life Insurance Plan unless they have a Spouse

How to set eligibility in Standard and Advanced Benefits so that an employee is not found eligible for the Spousal Life Insurance plan unless they have an eligible Spouse contact.

Solution:
Navigations:

• Total Compensation > Programs and Plans > Plans
• Total Compensation > Programs and Plans > Plan Enrollment Requirements
• People > Enter & Maintain > query employee > Others button > Contacts

Requirement:
Employees/Participants should not be eligible for the Spousal Life Insurance Plan unless they have a Spouse entered on the Contact form.
Setup:

1. Go to to Plans form for the Spousal Life Insurance plan.
2. On the General tab, select Family Member Code 'Check Designation Requirements'
3. Go to the Plan Enrollment Requirements form for the Spousal Life Insurance plan.
4. On the General tab > Plan tab > Designation Requirements button, enter:

Group Relationship:  Spouse 

Type:  Dependents 

Min: 1 

Max: 1 

Relationship Type:  Spouse

Delete Option from Plan on Test Instance before Go Live - Oracle Advanced Benefits(OAB)

select * from ben_prtt_enrt_rslt_f where oipl_id = 9002
select * from per_all_people_f where person_id = 1497
select * from ben_oipl_f where oipl_id = 9002
select * from ben_opt_f where opt_id = 9003
delete from ben_prtt_enrt_rslt_f where oipl_id = 9002

select * from ben_elig_per_elctbl_chc where oipl_id = 9002
delete from ben_elig_per_elctbl_chc where oipl_id = 9002

Note - This is for my future reference. Oracle does not recommend it.

Disable The Fn + Function Key Combination on HP Laptops

Really wanted to share this.

 

In my case I changed it from Enabled to Disabled and it worked.

On most HP and Compaq notebook computers, it is necessary to press and hold the function key (fn) while pressing one of the f1 through f12 keys to activate the default functions; such as, increasing or decreasing the brightness of the display, the sound volume, sleep, keyboard lock, etc. On the HP Envy notebooks and other notebooks with advanced BIOS options, the function keys can be configured so that it is not necessary to press and hold the fn key.

Figure 1: Location of function keys

1 - Function Keys f1 through f12

2 - Configurable Function key fn

Disable or enable fn in the BIOS

To disable, or enable, the function key (fn) in the BIOS, do the following steps.

1. Press the power button to turn on the computer.
2. Press the f10 key to open the BIOS setup window.
3. Press the right-arrow or left-arrow keys to navigate to the System Configuration option.
   Figure 2: BIOS setup window

   
4. Press the up-arrow or down-arrow keys to navigate to the Action Keys Mode option, and then press the enter key to display the Enable / Disable menu.
5. Select the desired mode:

   Disabled : Requires pressing and holding the function key (fn) while pressing one of the f1 through f12 keys to use the action indicated on the action key.
   For example, on some computer models, if the Action Keys Mode is Disabled , pressing the f11 key will minimize and maximize a web browser if open. Alternatively, pressing and holding the fn + f11 keys will mute the sound.
   The action keys may vary depending on the model of notebook.
   Enabled : Requires pressing only one of the f1 through f12 keys to use the action as indicated on the action key.
   For example, on some computer models, if the Action Keys Mode is Enabled , pressing f11 will mute the sound as indicated on the action key. Alternatively, pressing and holding fn + f11 will minimize and maximize a web browser if open.
   The action keys may vary depending on the model of notebook.
6. Press the f10 key to save the selection and restart the computer.

The function key (fn) option can be reset at any time.

Oracle Advanced Benefits(OAB) Ad-hoc Queries

1. Enrollment Results:

 

SELECT DECODE (TO_CHAR (enrt_cvg_thru_dt, 'DD-MM-RRRR'),
               '31-12-4712', 'Add',
               'Del'
              ),
       enrt_cvg_thru_dt
  FROM ben_prtt_enrt_rslt_f pen
 WHERE business_group_id = 82
   AND :p_effective_date BETWEEN pen.enrt_cvg_strt_dt AND pen.enrt_cvg_thru_dt
   AND pen.enrt_cvg_thru_dt <= pen.effective_end_date
   AND pen.prtt_enrt_rslt_stat_cd IS NULL
   AND pen.sspndd_flag = 'N'
   AND pen.person_id IN (1512,1307)
 
 
2. Enrollment Rates

For each enrollment you can have different rates. Rates are store in table ben_prtt_rt_val
you can use the following query for rates

SELECT *
FROM ben_prtt_rt_val
WHERE prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
 
But here main things to take care is rt_strt_dt and rt_end_dt. rt_strt_dt will always be less than equal to rt_end_date for a recurring rate but rt_strt_dt and rt_end_dt are equal when rt is non-recurring.

3. Eligibility Results

These results are store for each life event in person record. Also in this table you will find if a particular enrollments is set for default or auto enrollment with dflt_flag and auto_enrt_flag.
SELECT epe.*
FROM ben_elig_per_elctbl_chc epe,
ben_per_in_ler pil
WHERE pil.person_id = p_person_id
AND epe.per_in_ler_id = pil.per_in_ler_id;

4. Enrolled Dependents

SELECT *
FROM ben_elig_cvrd_dpnt_f dpnt,
ben_prtt_enrt_rslt_f pen
WHERE dpnt.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
AND EXISTS (SELECT pil.per_in_ler_id
FROM ben_per_in_ler pil
WHERE pil.per_in_ler_id = pen.per_in_ler_id
AND pil.business_group_id = p_business_group_id
AND pil.per_in_ler_stat_cd NOT IN ('VOIDD','BCKDT'))
AND p_effective_date BETWEEN dpnt.cvg_strt_dt AND Nvl(dpnt.cvg_thru_dt,p_effective_date)
AND (Nvl(dpnt.cvg_thru_dt,p_effective_date) <= dpnt.effective_end_date
OR p_effective_date BETWEEN dpnt.effective_start_date AND Nvl(dpnt.effective_end_date,p_effective_date))
AND dpnt.dpnt_person_id = p_person_id

In above query you can dpnt_person_id is the dependent. You can see the enrolled person in ben_prtt_enrt_rslt_f table.

5. Pending Action Items

SELECT *
FROM ben_prtt_enrt_rslt_f pen,
ben_prtt_enrt_actn_f pea,
ben_per_in_ler pil
WHERE pen.prtt_enrt_rslt_id = pea.prtt_enrt_rslt_id
AND pil.per_in_ler_id (+) = pea.per_in_ler_id
AND (pil.per_in_ler_stat_cd NOT IN ('VOIDD','BCKDT')
OR pil.per_in_ler_stat_cd IS NULL)
AND pen.sspndd_flag = 'Y'
AND p_effective_date BETWEEN pen.enrt_cvg_strt_dt AND pen.enrt_cvg_thru_dt
AND pen.enrt_cvg_thru_dt <= pen.effective_end_date
AND pen.prtt_enrt_rslt_stat_cd IS NULL

Reference - http://oracle-apps-tech.blogspot.com/2009/03/oracle-advanced-benefit-oab-queries.html
 

Enrolling Dependent from Benefits self Service in Oracle Advanced Benefits(OAB)

In Oracle Advanced Benefits, if employee select Employee + Spouse option through SSHR, system should ask him to select spouse from available dependents for enrollment.

Solution:
1. Go to Program Enrollment Requirement
2. Select Designation Level as Plan Type in Program
3. Select Plan Type name
4. Select Plan Type Dependent Designation as Required
5. Select Dependent Coverage Start Date and Dependent Coverage End Date
6. Click Dependent Change of Life Event
7. Add Life Event e.g. New Hire and select Change Dependent Coverage as May Either Add or Remove Dependents
8. Save the record
9. Retest Issue from self service.

Enrollment Codes with Descriptions for Standard and Advanced Benefits(OAB)

List of Enrollment Codes
 

Current, Can Keep or Choose; New, Nothing: If a person is currently enrolled in this compensation object, the person can keep their current elections or make new elections. If a person is not yet enrolled, the person cannot make an election.
Current, Can Keep or Choose; New, Can Choose: If a person is currently enrolled in this compensation object, the person can keep their current elections or make new elections. If a person is not yet enrolled, the person can make new elections.
Current, Can Keep or Choose But Starts New; New, Can Choose: If a person is currently enrolled in this compensation object, the person can keep their current elections or make new elections. The coverage ends at the end of the plan year and restarts the next day so that the participant must explicitly re-elect each year, even though the coverage amount may stay the same. If a person is not yet enrolled, the person can make new elections.

Note: You can only select this code from the Program or Plan Enrollment Requirements windows at either the plan type in program, plan in program, or plan level based on a life event. It is recommended that you select this code only for the Open enrollment life event.

Current, Choose Only; New, Can Choose: If a person is currently enrolled in this compensation object, the person must make an explicit election to stay enrolled. If a person is not yet enrolled, the person can make new elections.
Current, Choose Only; New, Nothing: If a person is currently enrolled in this compensation object, the person must make an explicit election to stay enrolled. If a person is not yet enrolled, the person cannot make an election.
Current, Keep Only; New, Can Choose: If a person is currently enrolled in this compensation object, the person must keep their current elections. If a person is not yet enrolled, the person can make new elections.
Current, Keep Only; New, Nothing: If a person is currently enrolled in this compensation object, the person must keep their current elections. If a person is not yet enrolled, the person cannot make an election.
Current, Lose Only; New, Can Choose: If a person is currently enrolled in this compensation object, the person must de-enroll from their current elections. If a person is not yet enrolled, the person can make new elections.
Current, Lose Only; New, Nothing: If a person is currently enrolled in this compensation object, the person must de-enroll from their current elections. If a person is not yet enrolled, the person cannot make new elections.

Automatic Codes:
Current, Assign; New, Assign (Automatic): If the enrollment method code is Automatic, both current and new enrollees automatically enroll and cannot de-enroll.
Current, Nothing; New, Assign (Automatic): If the enrollment method code is Automatic, current enrollees automatically de-enroll; new enrollees automatically enroll and cannot de-enroll.
Current, Assign; New, Nothing (Automatic): If the enrollment method code is Automatic, current enrollees automatically enroll and cannot de-enroll; people not already enrolled cannot make an election.

Rule: Select Rule if you define a FastFormula rule to determine a person's electability based on their current enrollment status. The formula must be of the type Enrollment Opportunity.

List of Default Enrollment Codes

New, Defaults; Current, Nothing: If a person is not yet enrolled in a given benefit, enroll that person in the default enrollment for that benefit. If the person is already enrolled in that benefit, de-enroll the person from that benefit.
New, Defaults; Current, Defaults: If a person is not yet enrolled in a given benefit, enroll that person in the default enrollment for that benefit. If a person is already enrolled in a benefit, enroll the person in the default enrollment for that benefit.
New, Defaults; Current, Same Enrollment and Rates: If a person is not yet enrolled in a given benefit, enroll that person in the default enrollment for that benefit. If a person is already enrolled in a benefit, do not change that enrollment or the activity rate.
New, Defaults; Current, Same Enrollment but Default Rates: If a person is not yet enrolled in a given benefit, enroll that person in the default enrollment for that benefit. If a person is already enrolled in a benefit, do not change the enrollment but assign the default activity rate.
New, Nothing; Current, Same Enrollment and Rates: If a person is not yet enrolled in a given benefit, do not enroll that person in that benefit. If a person is already enrolled in a benefit, do not change that enrollment or the activity rate.
New, Nothing; Current, Same Enrollment but Default Rates: If a person is not yet enrolled in a given benefit, do not enroll that person in that benefit. If a person is already enrolled in a benefit, do not change that enrollment but assign the default activity rate.
New, Nothing; Current, Defaults: If a person is not yet enrolled in a given benefit, do not enroll that person in that benefit. If a person is already enrolled in a benefit, enroll that person in the default enrollment for that benefit.
New, Nothing; Current, Nothing: If a person is not yet enrolled in a given benefit, do not enroll that person in that benefit. If the person is already enrolled in that benefit, de-enroll that person from that benefit.
Rule: Indicates that you will specify a FastFormula rule for this default treatment. The formula must be of the type Default Enrollment.