You are browsing the archive for Concurrent Requests & Reports.

Manage Life events process

 

NAME: Manage Life events process
SHORT CODE: BENCONC
MODULE: Oracle Advanced Benefits

Description: Manage Life Events.
Navigation: Oracle Advanced Benefits Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_effective_date : Effective Date
  • p_mode : Mode of operation
  • p_validate : Validate Only
  • p_person_id : Person to process
  • p_person_type_id : Type of persons to process
  • p_pgm_id : Program name
  • p_business_group_id : Business Group
  • p_pl_id : Plan name
  • p_popl_enrt_typ_cycl_id : Enrollment type cycle
  • p_no_programs : No Programs
  • p_no_plans : No Plans
  • p_comp_selection_rule_id : Comp selection rule
  • p_person_selection_rule_id : Person selection rule
  • p_ler_id : Life Event
  • p_organization_id : Organization
  • p_benfts_grp_id : Benefits Group
  • p_location_id : Location
  • p_pstl_zip_rng_id : Postal Zip Range
  • p_rptg_grp_id : Reporting group
  • p_pl_typ_id : Plan type
  • p_opt_id : Option name
  • p_eligy_prfl_id : Eligibility profile
  • p_vrbl_rt_prfl_id : Variable rate profile
  • p_legal_entity_id : Government Report

 

Participation Process: Compensation – Internal Only

 

NAME: Participation Process: Compensation – Internal Only
SHORT CODE: BENCOMOD
MODULE: Oracle Advanced Benefits

Description: Manage Life Events.
Navigation: Oracle Advanced Benefits Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_benefit_action_id : Benefit Action
  • p_effective_date : Effective Date
  • p_mode : Mode of operation
  • p_derivable_factors : Derivable Factors
  • p_validate : Validate
  • p_person_id : Person to process
  • p_pgm_id : Program name
  • p_business_group_id : Business Group
  • p_pl_id : Plan name
  • p_popl_enrt_typ_cycl_id : Enrollment Start Date
  • p_lf_evt_ocrd_dt : Life Event Occured Date
  • p_person_type_id : Type of persons to process
  • p_no_programs : Plans not in Programs
  • p_no_plans : Only Programs
  • p_comp_selection_rule_id : Comp selection rule
  • p_person_selection_rule_id : Person selection rule
  • p_ler_id : Life Event
  • p_organization_id : Organization
  • p_benfts_grp_id : Benefits Group
  • p_location_id : Location
  • p_pstl_zip_rng_id : Postal Zip Range
  • p_rptg_grp_id : Reporting group
  • p_pl_typ_id : Plan type
  • p_opt_id :

 

COBRA Benefit Notification Letter (XML)

 

NAME: COBRA Benefit Notification Letter (XML)
SHORT CODE: BENCOBN1_XML
MODULE: Oracle Advanced Benefits

Description: COBRA Benefit Notification Letter
Navigation: Oracle Advanced Benefits Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

  • p_effective_date : Effective Date
  • p_person_id : Person to process
  • p_business_group_id : Business Group
  • p_organization_id : Organization
  • p_benfts_grp_id : Benefit Groups
  • p_location_id : Locations
  • p_pgm_id : Program
  • DebugFlag : DebugFlag