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