You are browsing the archive for Oracle Advanced Benefits.

Premium Calculation Process

 

NAME: Premium Calculation Process
SHORT CODE: BENPRCON
MODULE: Oracle Advanced Benefits

Description: Premium Calculation.
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_validate : Validate
  • p_person_id : Person to process
  • p_business_group_id : Business Group
  • p_pgm_id : Program Name
  • p_pl_typ_id : Plan Type Name
  • p_pl_id : Plan Name
  • p_person_selection_rule_id : Person selection rule
  • p_comp_selection_rule_id : Comp object selection rule
  • p_organization_id : Organization
  • p_legal_entity_id : Government Reporting Establishment
  • p_debug_messages : Debug Messages

 

Premium Calculation(thread)

 

NAME: Premium Calculation(thread)
SHORT CODE: BENPRCOM
MODULE: Oracle Advanced Benefits

Description: Premium Calculation.
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_validate : Validate Only
  • p_benefit_action_id : Benefit Action Id
  • p_thread_id : Thread Id
  • p_effective_date : Effective Date
  • p_business_group_id : Business Group
  • p_mo_num : Month Number
  • p_yr_num : Year Number
  • p_first_day_of_month : First Day of Month

 

Purge Backed-out Or Voided Life Events

 

NAME: Purge Backed-out Or Voided Life Events
SHORT CODE: BENPRBCK
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_business_group_id : Business Group
  • p_person_id : Person to Process
  • p_person_selection_rule_id : Person selection rule
  • p_life_event_id : Life Event Name
  • p_from_ocrd_date : From Occurred Date
  • p_to_ocrd_date : To Occurred Date
  • p_organization_id : Organization Name
  • p_location_id : Location
  • p_benfts_grp_id : Benefits Group
  • p_legal_entity_id : Legal Entity
  • p_payroll_id : Payroll
  • p_life_evt_typ_cd : Life Event Type
  • p_bckt_stat_cd : Backed Out Status
  • p_audit_log_flag : Audit Log Flag
  • p_delete_life_evt : Delete Life Events
  • p_delete_ptnl_life_evt : Delete Voided Potential Life Event