how to parse ebs business event and extract attribute from eventData — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

how to parse ebs business event and extract attribute from eventData

edited Jan 20, 2020 10:16AM in Integration 1 comment

Content

i'm trying to integrate EBS on premis to Other application on the cloud , the problem is the event data is passed as raw format
and i want to parse this xml payload and extract values to map it to my attribute ,

what is the best approch? here is a sample of the xml payload that is sent from EBS

<BusinessEvent_Input xmlns="http://xmlns.oracle.com/apps/wf/businessevents"&gt;
    <InputParameters>
        <ns:BusinessEvent xmlns:ns="http://xmlns.oracle.com/apps/wf/businessevents"&gt;
            <ns:EventName>oracle.apps.per.api.employee.create_employee</ns:EventName>
            <ns:EventKey>241</ns:EventKey>
            <ns:EventData>&lt;?xml version ='1.0' encoding ='ASCII'?&gt;&lt;employee&gt;&lt;hire_date&gt;2020/01/20 00:00:00&lt;/hire_date&gt;&lt;business_group_id&gt;82&lt;/business_group_id&gt;&lt;last_name&gt;test_test&lt;/last_name&gt;&lt;****&gt;M&lt;/****&gt;&lt;person_type_id&gt;103&lt;/person_type_id&gt;&lt;per_comments&gt;&lt;/per_comments&gt;&lt;date_employee_data_verified&gt;&lt;/date_employee_data_verified&gt;&lt;date_of_birth&gt;2000/01/20 00:00:00&lt;/date_of_birth&gt;&lt;email_address&gt;&lt;/email_address&gt;&lt;employee_number&gt;42665&lt;/employee_number&gt;&lt;expense_check_send_to_addres&gt;&lt;/expense_check_send_to_addres&gt;&lt;first_name&gt;test_test&lt;/first_name&gt;&lt;known_as&gt;&lt;/known_as&gt;&lt;marital_status&gt;&lt;/marital_status&gt;&lt;middle_names&gt;&lt;/middle_names&gt;&lt;nationality&gt;&lt;/nationality&gt;&lt;national_identifier&gt;&lt;/national_identifier&gt;&lt;previous_last_name&gt;&lt;/previous_last_name&gt;&lt;registered_disabled_flag&gt;&lt;/registered_disabled_flag&gt;&lt;title&gt;&lt;/title&gt;&lt;vendor_id&gt;&lt;/vendor_id&gt;&lt;work_telephone&gt;&lt;/work_telephone&gt;&lt;attribute_category&gt;&lt;/attribute_category&gt;&lt;attribute1&gt;&lt;/attribute1&gt;&lt;attribute2&gt;&lt;/attribute2&gt;&lt;attribute3&gt;&lt;/attribute3&gt;&lt;attribute4&gt;&lt;/attribute4&gt;&lt;attribute5&gt;&lt;/attribute5&gt;&lt;attribute6&gt;&lt;/attribute6&gt;&lt;attribute7&gt;&lt;/attribute7&gt;&lt;attribute8&gt;&lt;/attribute8&gt;&lt;attribute9&gt;&lt;/attribute9&gt;&lt;attribute10&gt;&lt;/attribute10&gt;&lt;attribute11&gt;&lt;/attribute11&gt;&lt;attribute12&gt;N&lt;/attribute12&gt;&lt;attribute13&gt;&lt;/attribute13&gt;&lt;attribute14&gt;&lt;/attribute14&gt;&lt;attribute15&gt;&lt;/attribute15&gt;&lt;attribute16&gt;&lt;/attribute16&gt;&lt;attribute17&gt;&lt;/attribute17&gt;&lt;attribute18&gt;&lt;/attribute18&gt;&lt;attribute19&gt;&lt;/attribute19&gt;&lt;attribute20&gt;&lt;/attribute20&gt;&lt;attribute21&gt;&lt;/attribute21&gt;&lt;attribute22&gt;&lt;/attribute22&gt;&lt;attribute23&gt;&lt;/attribute23&gt;&lt;attribute24&gt;&lt;/attribute24&gt;&lt;attribute25&gt;&lt;/attribute25&gt;&lt;attribute26&gt;&lt;/attribute26&gt;&lt;attribute27&gt;&lt;/attribute27&gt;&lt;attribute28&gt;&lt;/attribute28&gt;&lt;attribute29&gt;&lt;/attribute29&gt;&lt;attribute30&gt;&lt;/attribute30&gt;&lt;per_information_category&gt;AE&lt;/per_information_category&gt;&lt;per_information1&gt;&lt;/per_information1&gt;&lt;per_information2&gt;&lt;/per_information2&gt;&lt;per_information3&gt;&lt;/per_information3&gt;&lt;per_information4&gt;&lt;/per_information4&gt;&lt;per_information5&gt;&lt;/per_information5&gt;&lt;per_information6&gt;&lt;/per_information6&gt;&lt;per_information7&gt;&lt;/per_information7&gt;&lt;per_information8&gt;&lt;/per_information8&gt;&lt;per_information9&gt;&lt;/per_information9&gt;&lt;per_information10&gt;&lt;/per_information10&gt;&lt;per_information11&gt;&lt;/per_information11&gt;&lt;per_information12&gt;&lt;/per_information12&gt;&lt;per_information13&gt;&lt;/per_information13&gt;&lt;per_information14&gt;&lt;/per_information14&gt;&lt;per_information15&gt;&lt;/per_information15&gt;&lt;per_information16&gt;&lt;/per_information16&gt;&lt;per_information17&gt;&lt;/per_information17&gt;&lt;per_information18&gt;&lt;/per_information18&gt;&lt;per_information19&gt;&lt;/per_information19&gt;&lt;per_information20&gt;&lt;/per_information20&gt;&lt;per_information21&gt;&lt;/per_information21&gt;&lt;per_information22&gt;&lt;/per_information22&gt;&lt;per_information23&gt;&lt;/per_information23&gt;&lt;per_information24&gt;&lt;/per_information24&gt;&lt;per_information25&gt;&lt;/per_information25&gt;&lt;per_information26&gt;&lt;/per_information26&gt;&lt;per_information27&gt;&lt;/per_information27&gt;&lt;per_information28&gt;&lt;/per_information28&gt;&lt;per_information29&gt;&lt;/per_information29&gt;&lt;per_information30&gt;&lt;/per_information30&gt;&lt;date_of_death&gt;&lt;/date_of_death&gt;&lt;background_check_status&gt;N&lt;/background_check_status&gt;&lt;background_date_check&gt;&lt;/background_date_check&gt;&lt;blood_type&gt;&lt;/blood_type&gt;&lt;correspondence_language&gt;&lt;/correspondence_language&gt;&lt;fast_path_employee&gt;&lt;/fast_path_employee&gt;&lt;fte_capacity&gt;&lt;/fte_capacity&gt;&lt;honors&gt;&lt;/honors&gt;&lt;internal_location&gt;&lt;/internal_location&gt;&lt;last_medical_test_by&gt;&lt;/last_medical_test_by&gt;&lt;last_medical_test_date&gt;&lt;/last_medical_test_date&gt;&lt;mailstop&gt;&lt;/mailstop&gt;&lt;office_number&gt;&lt;/office_number&gt;&lt;on_military_service&gt;N&lt;/on_military_service&gt;&lt;pre_name_adjunct&gt;&lt;/pre_name_adjunct&gt;&lt;rehire_recommendation&gt;&lt;/rehire_recommendation&gt;&lt;projected_start_date&gt;&lt;/projected_start_date&gt;&lt;resume_exists&gt;N&lt;/resume_exists&gt;&lt;resume_last_updated&gt;&lt;/resume_last_updated&gt;&lt;second_passport_exists&gt;N&lt;/second_passport_exists&gt;&lt;student_status&gt;&lt;/student_status&gt;&lt;work_schedule&gt;&lt;/work_schedule&gt;&lt;suffix&gt;&lt;/suffix&gt;&lt;benefit_group_id&gt;&lt;/benefit_group_id&gt;&lt;receipt_of_death_cert_date&gt;&lt;/receipt_of_death_cert_date&gt;&lt;coord_ben_med_pln_no&gt;&lt;/coord_ben_med_pln_no&gt;&lt;coord_ben_no_cvg_flag&gt;N&lt;/coord_ben_no_cvg_flag&gt;&lt;coord_ben_med_ext_er&gt;&lt;/coord_ben_med_ext_er&gt;&lt;coord_ben_med_pl_name&gt;&lt;/coord_ben_med_pl_name&gt;&lt;coord_ben_med_insr_crr_name&gt;&lt;/coord_ben_med_insr_crr_name&gt;&lt;coord_ben_med_insr_crr_ident&gt;&lt;/coord_ben_med_insr_crr_ident&gt;&lt;coord_ben_med_cvg_strt_dt&gt;&lt;/coord_ben_med_cvg_strt_dt&gt;&lt;coord_ben_med_cvg_end_dt&gt;&lt;/coord_ben_med_cvg_end_dt&gt;&lt;uses_tobacco_flag&gt;&lt;/uses_tobacco_flag&gt;&lt;dpdnt_adoption_date&gt;&lt;/dpdnt_adoption_date&gt;&lt;dpdnt_vlntry_svce_flag&gt;N&lt;/dpdnt_vlntry_svce_flag&gt;&lt;original_date_of_hire&gt;2020/01/20 00:00:00&lt;/original_date_of_hire&gt;&lt;adjusted_svc_date&gt;&lt;/adjusted_svc_date&gt;&lt;person_id&gt;190617&lt;/person_id&gt;&lt;assignment_id&gt;&lt;/assignment_id&gt;&lt;per_object_version_number&gt;2&lt;/per_object_version_number&gt;&lt;asg_object_version_number&gt;&lt;/asg_object_version_number&gt;&lt;per_effective_start_date&gt;2020/01/20 00:00:00&lt;/per_effective_start_date&gt;&lt;per_effective_end_date&gt;4712/12/31 00:00:00&lt;/per_effective_end_date&gt;&lt;full_name&gt;test_test, test_test&lt;/full_name&gt;&lt;per_comment_id&gt;&lt;/per_comment_id&gt;&lt;assignment_sequence&gt;&lt;/assignment_sequence&gt;&lt;assignment_number&gt;&lt;/assignment_number&gt;&lt;town_of_birth&gt;&lt;/town_of_birth&gt;&lt;region_of_birth&gt;&lt;/region_of_birth&gt;&lt;country_of_birth&gt;&lt;/country_of_birth&gt;&lt;global_person_id&gt;&lt;/global_person_id&gt;&lt;party_id&gt;&lt;/party_id&gt;&lt;name_combination_warning&gt;FALSE&lt;/name_combination_warning&gt;&lt;assign_payroll_warning&gt;FALSE&lt;/assign_payroll_warning&gt;&lt;orig_hire_warning&gt;FALSE&lt;/orig_hire_warning&gt;&lt;/employee&gt;</ns:EventData>

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!