NAME: Extract Definition Download to Data File – FNDLOAD
SHORT CODE: BENXUPLDR
MODULE: Oracle Advanced Benefits

Description: Extract System Down Loader called internally
Navigation: Oracle Advanced Benefits Responsibility -> View -> Requests -> Submit a new request -> Select Single Request -> Click ‘OK’ -> Select Name of concurrent program / report.

Report Parameters:

• Mode : Mode
• Loader Configuration File : Loader Configuration File
• Data File : Data File
• Entity : Entity
• File Name : File Name
• CM_DOWNLOAD : concurrent manager downlaod
• Business Group : Business Group

NAME: Extract Process
SHORT CODE: BENXTRCT
MODULE: Oracle Advanced Benefits

Description: Extract Process
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_effective_date : Effective Date
• p_business_group_id : Business Group
• p_output_type : Output Type
• p_out_dummy :
• p_xdo_template_id : Template

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