Creating AR Invoice Using RecInvoiceService SOAP Webservice We can use below SOAP WSDL to insert data into AR Invoice Interface table. WSDL: This WSDL is having below Methods: Under InvoiceServiceSoapHttp, We have different methods which we can use for inserting data into RA_INTERFACE_LINES_ALL table or Creating AR invoice directly in Receivable. Method Name Usage createSimpleInvoice […]
How to Call BIP Report Output in chunks using SOAP WSDL
Whenever we want to fetch huge amounts of data from BIP report (More than 10MB) in OIC, we usually get payload limitations error. To avoid this error, we have below two options: (A) Schedule BIP report and send File to FTP server and then read data from FTP in segment in OIC. (B) Retrieve BIP […]
Customer-Trading Party Creation using SOAP API
Follow below SOAP API for creating customer-Trading Party: (A) Create Location: Use Below SOAP API WSDL and Payload to create Location: SOAP WSDL: https://fa-xxx-xxx-saasfaxxx.fa.ocs.oraclecloud.com/foundationParties/LocationService?WSDL Method: https://fa-xxxx-xxx-saasfaxxxx.fa.ocs.oraclecloud.com:443/crmService/FoundationPartiesLocationService Payload: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:typ=”http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/applicationModule/types/” xmlns:loc=”http://xmlns.oracle.com/apps/cdm/foundation/parties/locationService/” xmlns:par=”http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/” xmlns:sour=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/sourceSystemRef/” xmlns:loc1=”http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/location/”> <soapenv:Header/> <soapenv:Body> <typ:createLocation> <typ:location> <loc:Country>US</loc:Country> <loc:Address1>1 Test address11</loc:Address1> <loc:City>Columbia</loc:City> <loc:PostalCode>29210</loc:PostalCode> <loc:State>South Carolina</loc:State> <loc:CreatedByModule>HZ_WS</loc:CreatedByModule> </typ:location> </typ:createLocation> </soapenv:Body> </soapenv:Envelope> Location is created now. […]
How to Call BIP Report using SOAP Webservice in SOAP UI (ReportService WSDL)
In this section, we will see how to call BIP report using SOAP Webservice. Oracle provided a SOAP web service ReportService with “runReport” operation with which we can call BIP report and get output in Base64 format. We will call simple BIP report created in cloud application using SOAP Web service. Here we will use […]
How to get UCM ID from document ID using Generic SOAP WSDL
We can get Document ID once we upload the files to UCM using Erpintegrations REST API as shown below: We can get UCM id from this document ID using generic SOAP WSDL with the details below: WSDL: Method: GenericSoapOperation Request: <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:ucm=”http://www.oracle.com/UCM”> <soapenv:Header/> <soapenv:Body> <ucm:GenericRequest webKey=”cs”> <ucm:Service IdcService=”GET_FILE”> <ucm:Document> <ucm:Field name=”dID”>2700074</ucm:Field> </ucm:Document> </ucm:Service> </ucm:GenericRequest> […]
SOAP Webservice To Apply/Release Hold On Sales Order in Oracle Fusion
We need to use below SOAP Webservice to apply Hold on Sales Order in Oracle Fusion: WSDL URL: Operations: RequestHold Sample Payload: <?xml version=”1.0″ encoding=”UTF-8″?> <soapenv:Envelope xmlns:soapenv=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:dood=”http://xmlns.oracle.com/apps/scm/doo/decomposition/orderDetailServices/DooDecompOrderDetailSvcComposite”> <soapenv:Header /> <soapenv:Body> <dood:RequestHoldProcessRequest> <dood:ApplyHoldRequestParams> <dood:SourceOrderSystem>OPS</dood:SourceOrderSystem> <dood:SourceHoldCode>XX_TEST_HOLD</dood:SourceHoldCode> <dood:HoldComments>XX Test Hold Comment</dood:HoldComments> <dood:SourceOrderNumber>XX_TEST_SALES_ORDER_01</dood:SourceOrderNumber> <dood:HoldName>XX Test Hold</dood:HoldName> <dood:AppliedBy>Test_user</dood:AppliedBy> </dood:ApplyHoldRequestParams> </dood:RequestHoldProcessRequest> </soapenv:Body></soapenv:Envelope> 2. Releasing Hold on Sales Order WSDL URL: […]