In this Article i will explain the common way to upload the data to UCM server using web service call.
Step 1: Get the Endpoint from oracle OER
Request Payload : <soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/" xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/"> <soapenv:Header/> <soapenv:Body> <typ:uploadFileToUcm> <typ:document> <erp:Content>UEsDBBQAAAAIABIDc1DzsHaodfhhAAA4CAAATAAAAUG96U3VwcGxpZXJzSW50LmNzdt2QuwoCQQxFe8F/CFunyGwhWGZnMqiMWZlHoY3//xc7O4yIiqWNeVwulxTh2CicBYcTnyWBLhfhLOOxAPiR0w7QyOZPZFpF1F8UYfWTtAtpouou8686hzkeb1ITxCtC1bawekBtuiZfC/o8+0dV/91ubOfAqgwTR9HkJbgHh7f4hYP7Hw4LUEsBAhQAFAAAAAgAEgNzUPOwdqiGAAAADgIAABMAAAAAAAAAAQAgAAAAAAAAAFBvelN1cHBsaWVyc0ludC5jc3ZQSwUGAAAAAAEsshBAAAAtwAAAAAA</erp:Content> <erp:FileName>PozSuppliersInt4.zip</erp:FileName> <!--Optional:--> <erp:ContentType/> <!--Optional:--> <erp:DocumentTitle/> <!--Optional:--> <erp:DocumentAuthor>Sandeep Satyavolu</erp:DocumentAuthor> <!--Optional:--> <erp:DocumentSecurityGroup>FAFusionImportExport</erp:DocumentSecurityGroup> <!--Optional:--> <erp:DocumentAccount>prc$/supplier$/import$</erp:DocumentAccount> <!--Optional:--> <erp:DocumentName/> <!--Optional:--> <erp:DocumentId/> </typ:document> </typ:uploadFileToUcm> </soapenv:Body> </soapenv:Envelope>
Response Payload :
<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing"> <env:Header> <wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpIntegrationService/uploadFileToUcmResponse</wsa:Action> <wsa:MessageID>urn:uuid:50a5b6df-f11e-4f83-d95e</wsa:MessageID> </env:Header> <env:Body> <ns0:uploadFileToUcmResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/"> <result xmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">824274</result> </ns0:uploadFileToUcmResponse> </env:Body> </env:Envelope>
Now Log into the application > Navigate to Tools > File import and Export > Select the UCM Account you uploaded the file and hit search.
Hope this helps!
This is very Helpful artical,Hi Sir can you also share import and Process calling WSDL/SOAP for "SubmitESSJobRequest - 'Load Interface File for Import' process" and "submitESSJobRequest - load the data into base tables" with step by step process.I am new to SOAP and Webservice Can you share all the steps.My email id athawalenilesh11@gmail.com