Supplier and Supplier Site Bank account assignment can be end dated using below REST API in oracle Fusion. Step1: Get INSTRUMENT_PAYMENT_USE_ID for Supplier/ Supplier Sites level. Run below SQL queries to get INSTRUMENT_PAYMENT_USE_ID for Supplier and Supplier Site level. Supplier: SELECT DISTINCT APS.SEGMENT1, IPIUA.INSTRUMENT_PAYMENT_USE_ID FROM POZ_SUPPLIERS_V APS, IBY_EXTERNAL_PAYEES_ALL IEPA, IBY_EXT_PARTY_PMT_MTHDS PMTMTHDS, IBY_PMT_INSTR_USES_ALL IPIUA, IBY_EXT_BANK_ACCOUNTS IEBA […]
Creating Implementation User using REST API
Creating Implementation User using REST API We can use the REST API below for creating implementation users: REST API Endpoint: /hcmRestApi/scim/Users Method: POST Content-Type: application/json Payload: { “schemas”:[ “urn:scim:schemas:core:2.0:User” ], “userName”:”TEST_DUMMY_USER” }
How to Call BIP Report using SOAP Webservice in SOAP UI
In this section, we will see how to call BIP report using SOAP Webservice. Oracle provided a SOAP web service ExternalReportWSSService 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> […]
Uploading File to UCM using ErpIntegrations REST API
Uploading File to UCM using ErpIntegrations REST API We can use the REST API for uploading files to UCM as below: REST API Endpoint: Method: POST Content-Type: application/json Payload: { “OperationName”:”uploadFileToUCM”, “DocumentContent”:”VGhpcyBpcyB0ZXN0IEZpbGUgZm9yIFVDTQ==”, “DocumentAccount”:”fin$/payables$/import$”, “ContentType”:”txt”, “FileName”:”TEST UCM Uplaod File.txt” } The payload details are as follows: OperationName This should be constant […]
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: […]