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>

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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