OIC - Receive Bulk Import ERP Callback using SOAP Adapter

OIC can receive callback from ERP through event subscription as well as direct webservice call from ERP. 

We need to perform following configurations to receive the callback from ERP using SOAP adapter. 

• Make sure the ERP user used to invoke the bulk operation is exists in IDCS as well. 
• Upload the SAAS certificates onto OIC to receive the callback using SAML assertions. 
• Use the following URL to get the certificates. 
• https://saas_host_name:port/fscmService/ServiceCatalogService?WSDL
• Create the .cer files using the above copied certificates

-----BEGIN CERTIFICATE----- 

yglID0RZf9uonYqSdBi19pK1gSTUNDQ28h6dd/N4C4lvrww0Kfmf92C2o9NnCPesoW7UCXbKyjBxZlVJ/Wi2zXp0dBMXCYKcFkw==

-----END CERTIFICATE----- 

• Upload the .cer as SAML certificates

Use the following WSDL to receive a callback from ERP Application. Configure a SOAP adapter with following WSDL and select SAML assertion as a security policy. 

Provide this integration URL in ERP Bulk import request message to receive a callback. 

 OnJobCompletion.wsdl

xmlns:tns="http://oracle.com/sca/soapservice/SOACoreServices/ERPCallbackServiceService/ERPCallbackService" xmlns:inp1="http://xmlns.oracle.com/scheduler" xmlns:wsdl="http://schemas.xmlsoap.org/wsdl/">

   <wsdl:types>

      <xsd:schema attributeFormDefault="unqualified" elementFormDefault="unqualified" targetNamespace="http://xmlns.oracle.com/scheduler" xmlns:xsd="http://www.w3.org/2001/XMLSchema">

         <xsd:element name="onJobCompletion">

            <xsd:complexType>

               <xsd:sequence>

                  <xsd:element type="xsd:int" name="requestId"/>

                  <xsd:element type="xsd:string" name="state"/>

                  <xsd:element name="resultMessage" type="xsd:string"/>

               </xsd:sequence>

            </xsd:complexType>

         </xsd:element>

      </xsd:schema>

   </wsdl:types>

   <wsdl:message name="onJobCompletionRequestMessage">

      <wsdl:part name="ERPCallbackInput_pn" element="inp1:onJobCompletion"/>

   </wsdl:message>

   <wsdl:portType name="onJobCompletion_ptt">

      <wsdl:operation name="onJobCompletion">

         <wsdl:input message="tns:onJobCompletionRequestMessage"/>

      </wsdl:operation>

   </wsdl:portType>

</wsdl:definitions>

OIC - REST Adapter - Receive Attachment and Upload To Object Storage

Use the following Steps to accept the Attachment in the request message. 

• Create an APP Driven Orchestration
• Add Rest Adapter at the trigger action
• Provide Name and URI 
• Select POST/PUT operation
• Select Configure Request and Response Payload options. 
• Under Request page , select Accept attachment option. 
• If you are expecting additional payload , add the sample Json payload. 
• Under Response page, provide sample Json payload 
• Select Done. 

Use the following Steps to upload the incoming attachment to an Object Storage. 

• Add an Object Storage REST adapter. 
• Give a name and URI - /n/{tenancy_name}/b/{bucket_name}/o/{object_name}
• Select PUT operation. 
• Select Configure Request payload. 
• Under Request Page , select Binary as a Request format option. 
• Complete the settings. 

Map Incoming Attachment to Object Storage.

• Source section , Select Request wrapper
• Go to Attachments
•  Select Attachment Reference 
• Drag and Drop it to Target Stream element.