Extract Thread

 

NAME: Extract Thread
SHORT CODE: BENXTHRD
MODULE: Oracle Advanced Benefits

Description: Benefits Extract Thread
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_ext_dfn_id : Extract Name
  • p_thread_id : Thread
  • p_effective_date : Effective Date
  • p_business_group_id : Business Group
  • p_data_typ_cd : Data Type
  • p_ext_typ_cd : Extract Type
  • p_ext_crit_prfl_id : Criteria Profile
  • p_ext_rslt_id : Result
  • p_ext_file_id : File
  • p_ext_strt_dt : Start Date
  • p_ext_end_dt : End Date
  • p_prmy_sort_cd : Primary Sort
  • p_scnd_sort_cd : Secondary Sort
  • p_output_name : Output File
  • p_apnd_rqst_id_flag : Append Request
  • p_request_id : Request Id
  • p_use_eff_dt_for_chgs_flag : Change Flag
  • p_master_process_flag : Master Process Flag
  • p_eff_start_date : Effective Start Date
  • p_eff_end_date : Effective End Date
  • p_act_start_date : Actual Start Date
  • p_act_end_date : Actual End Date
  • p_penserv_mode : Penserver Mode

 

Leave a reply

Your email address will not be published. Required fields are marked *