You are browsing the archive for Oracle Advanced Benefits.

Reconciliation of Premium Contributions to Element Entries Report

 

NAME: Reconciliation of Premium Contributions to Element Entries Report
SHORT CODE: BENRECON
MODULE: Oracle Advanced Benefits

Description: Reconciliation of Premium Contributions to Element Entries
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_report_start_date :
  • p_report_end_date :
  • p_person_id :
  • p_ntl_identifier :
  • p_emp_name_format :
  • p_pgm_id :
  • p_pl_id :
  • p_per_sel_rule_id :
  • p_business_group_id :
  • p_organization_id :
  • p_location_id :
  • p_benfts_grp_id :
  • p_rptg_grp_id :
  • p_payroll_id :
  • p_prem_type :
  • p_output_typ :
  • p_dsply_pl_recn_rep :
  • p_dsply_pl_disc_rep :
  • p_dsply_lfe_rep :
  • p_dsply_pl_prtt_rep :
  • p_dsply_prtt_reps :

 

Participation Audit Activity Purge

 

NAME: Participation Audit Activity Purge
SHORT CODE: BENPURGE
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_concurrent_request_id : Concurrent Request
  • p_business_group_id : Business Group
  • p_effective_date : Effective Date

 

Purge Benmngle rows – Mutlithread

 

NAME: Purge Benmngle rows – Mutlithread
SHORT CODE: BENPRTRD
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_thread_id : Thread ID
  • p_effective_date : Effective_Date
  • p_business_group_id : Business Group
  • 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 Name
  • 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 : Backout Status
  • p_audit_log_flag : Audit Log
  • p_delete_life_evt : Delete Life Event