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> ...

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> <s...

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>Del...

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:S...

  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 (...

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    ...