Skip to Main Content

Cloud Platform

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Parsing XML in Oracle Integration Cloud

User_IPAFBSep 9 2022 — edited Sep 11 2022

Hi
We have subscribed to business event for create customer contact , but the response of the event is only contact point id, we want to extract this value from xml response and then feed to DB adapter to get other information abt contact.
I want help on how to extract Value below response using OIC and then feed to DB adapter i am getting below response message in OIC when business event is raised.
<BusinessEvent_Input xmlns="http://xmlns.oracle.com/apps/wf/businessevents">
<InputParameters>
<ns:BusinessEvent xmlns:ns="http://xmlns.oracle.com/apps/wf/businessevents">
<ns:EventName>oracle.apps.ar.hz.ContactPoint.create</ns:EventName>
<ns:EventKey>oracle.apps.ar.hz.ContactPoint.create9715196</ns:EventKey>
<ns:ParameterList>
<ns:Parameter>
<ns:Name>ERROR_TYPE</ns:Name>
<ns:Value>ERROR</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>USER_ID</ns:Name>
<ns:Value>0</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>CONTACT_POINT_ID</ns:Name>
<ns:Value>50367298</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>SECURITY_GROUP_ID</ns:Name>
<ns:Value>0</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>RESP_APPL_ID</ns:Name>
<ns:Value>660</ns:Value>
</ns:Parameter>
<ns:Parameter>
<ns:Name>RESP_ID</ns:Name>
<ns:Value>52184</ns:Value>
</ns:Parameter>
</ns:ParameterList>
</ns:BusinessEvent>
</InputParameters>
</BusinessEvent_Input>

Thanks
Sumir

Comments
Post Details
Added on Sep 9 2022
1 comment
703 views