Oracle Shooter

Supplier Contact Supplier Contact, Address and Site Creation and Updation by using SOAP Web Service or WSDL in cloud fusion Service WSDL URL:   https://servername/fscmService/SupplierServiceV2?WSDL   Create Supplier Contact <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <!--Optional:--> <sup:Supplier>Test Supplier App9011</sup:Supplier> <sup:AlternateName>App9011</sup:AlternateName> <sup:TaxOrganizationType>CORPORATION</sup:TaxOrganizationType> <sup:SupplierType>SUPPLIER</sup:SupplierType> <sup:BusinessRelationship>SPEND_AUTHORIZED</sup:BusinessRelationship> <sup:SupplierAddresses> <sup:Operation>CREATE</sup:Operation> <sup:AddressName>Main_add</sup:AddressName> <sup:Country>IN</sup:Country> <sup:AddressLine1>123 Old railway Line</sup:AddressLine1> <sup:Ci

Supplier Site Supplier Site and Address Creation and Updation by using SOAP Web Service or WSDL in cloud fusion Service WSDL URL:  https://servername/fscmService/SupplierServiceV2?WSDL  Supplier Sites Creation <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <sup:Supplier>Test Supplier App9010</sup:Supplier> <sup:AlternateName>App9010</sup:AlternateName> <sup:TaxOrganizationType>CORPORATION</sup:TaxOrganizationType> <sup:SupplierType>SUPPLIER</sup:SupplierType> <sup:BusinessRelationship>SPEND_AUTHORIZED</sup:BusinessRelationship> <sup:SupplierAddresses> <sup:Operation>CREATE</sup:Operation> <sup:AddressName>Main_add</sup:AddressName> <sup:Country>IN</sup:Country> <sup:AddressLine1>123 Old railway Line</sup:AddressLine1> <sup:City>Delhi</sup:City> <sup:State&

Supplier Address Creation Supplier Address Creation and Updation by using SOAP Web Service or WSDL in cloud fusion Service WSDL URL:  https://servername/fscmService/SupplierServiceV2?WSDL Create Supplier with Supplier Address <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <!--Optional:--> <sup:Supplier>Test Supplier App9001</sup:Supplier> <sup:AlternateName>App9001</sup:AlternateName> <sup:TaxOrganizationType>CORPORATION</sup:TaxOrganizationType> <sup:SupplierType>SUPPLIER</sup:SupplierType> <sup:BusinessRelationship>SPEND_AUTHORIZED</sup:BusinessRelationship> <sup:SupplierAddresses> <sup:Operation>CREATE</sup:Operation> <sup:AddressName>Main</sup:AddressName> <sup:Country>IN</sup:Country> <sup:AddressLine1>123 Old railway Line</sup:AddressLine1> <sup:City>Delhi&l

Create Supplier Supplier Creation by using SOAP Web Service / WSDL in cloud fusion Creating a supplier in Oracle Fusion by using a SOAP Web Service involves several steps. Oracle Fusion provides various web services for different modules, and you need to use the appropriate web service for supplier creation based on your specific requirements. Here, I’ll provide a general overview of the steps involved in creating a supplier using a SOAP web service in Oracle Fusion. Service WSDL URL:  https://servername/fscmService/SupplierServiceV2?WSDL ====  Supplier Payload for SOAP UI  –==================== <soapenv:Body> <typ:createSupplier> <typ:supplierRow> <!--Optional:--> <sup:Supplier> Test Supplier App9001 </sup:Supplier> <sup:AlternateName> App100 </sup:AlternateName> <sup:TaxOrganizationType> Corporation </sup:TaxOrganizationType> <sup:SupplierType>

  Payload :-  {      "ReceiptNumber" : "TEST-90001" ,      "ReceiptMethod" : "SD HDFC" ,      "BusinessUnit" : "ABC Private Limited" ,      "CustomerAccountNumber" : "1001" ,      "CustomerSite" : "1001" ,      "Amount" : 1001.95 ,      "Currency" : "INR" ,      "RemittanceBankAccountNumber" : "00030330020116" } Select * from AR_RECEIPT_CLASSES where RECEIPT_CLASS_ID = 300000001865030 select * from HZ_CUST_ACCOUNTS where cust_account_id = 300000001865163 select * from HZ_PARTIES where party_id = 300000001865161 select * from AR_RECEIPT_METHODS where receipt_method_id = 300000001865031 Select * from AR_RECEIPT_CLASSES where RECEIPT_CLASS_ID = 300000001865030 select * from AR_RECEIPT_METHOD_ACCOUNTS_ALL where receipt_method_id = 300000001865031 select * from CE_BANK_ACCOUNTS where BANK_ACCOUNT_ID in (300000004849942, 300000001834143)

DECLARE l_responsibility_id     NUMBER; l_application_id        NUMBER; l_user_id               NUMBER; l_request_id            NUMBER; xml_layout boolean;  gc_wait_interval   NUMBER          := 0;  v_wait             BOOLEAN;    v_phase            VARCHAR2 (10);    v_status           VARCHAR2 (10);     --   v_out              VARCHAR2 (200); --   v_out1             VARCHAR2 (200); --   po_err_msg         VARCHAR2 (1000);    v_dev_phase        VARCHAR2 (200);    v_dev_status       VARCHAR2 (200);    v_message          VARCHAR2 (200); --   v_lay              BOOLEAN; --   v_cnt              NUMBER; cursor c1 is  select vendor_site_code, VENDOR_ID P_CUSTOMER_NAME from ap_supplier_sites_all  where vendor_site_code in ( ) and ORG_ID = 82; BEGIN       SELECT DISTINCT fr.responsibility_id,     frx.application_id      INTO l_responsibility_id,     l_application_id      FROM apps.fnd_responsibility frx,     apps.fnd_responsibility_tl fr     WHERE fr.responsibility_id = frx.responsibility_id  

 how to cancel standard invoice in payables. Here's how to pass correct Content Type: 1) In Postman/REST API Tool, go to Headers tab, and check the box for key : "Content-Type", 2) Pass value = 'application/vnd.oracle.adf.action+json' , without any quotes. 3) This value is also specified in documentation for REST APIs : link :-  Cancel Invoice :- /fscmRestApi/resources/11.13.18.05/invoices/action/cancelInvoice --================================================  OLD ---- https://your link info.com/fscmRestApi/resources/11.13.18.05/invoices {   "name": "cancelInvoice",   "parameters": [ { "InvoiceNumber": "REST_API_1001" }, { "BusinessUnit": "OAL Private Limited" }, { "Supplier": "Test Supplier  App99" }   ] } --================================================  NEW ---- https://your link info.com/fscmRestApi/resources/11.13.18.05/invoices/action/cancelInvoi

 How to create Standard AP Invoice by using REST API in fusion. API LINK :- https://passyour link info.com/fscmRestApi/resources/11.13.18.05/invoices payload:- {     "InvoiceNumber": "REST_1003",     "InvoiceCurrency": "INR",     "InvoiceAmount": 200,     "InvoiceDate": "2022-09-10",     "BusinessUnit": "OAL Private Limited",     "Supplier": "Test Supplier  App99",     "SupplierSite": "DELHI-APP1099",     "InvoiceGroup": "REST-External",     "Description": "TESTING REST API",        "invoiceInstallments": [ {             "InstallmentNumber": 1,             "DueDate": "2022-09-10",             "GrossAmount": 110                    },         {             "InstallmentNumber": 2,             "DueDate": "2022-09-15",             "Gro