Scribd
Upload
2K views11 pages

Creating Invoices via Oracle Fusion API

1. The document outlines the steps to create an invoice using a web service interface in Oracle Fusion Applications, including installing SOAP UI, adding required privileges, retrieving the WSDL file, and submitting a sample request payload to create an invoice. 2. Key steps include installing SOAP UI, adding privileges for the APP_IMPL_CONSULTANT user, retrieving the WSDL from the URL provided, and submitting an XML request payload with invoice header and line details to call the createInvoiceInterface web service. 3. The sample payload creates a test invoice for $100 USD with a single line item and required header fields like vendor, organization, and terms details.

Uploaded by

Satya Vissakoti
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
2K views11 pages

Creating Invoices via Oracle Fusion API

1. The document outlines the steps to create an invoice using a web service interface in Oracle Fusion Applications, including installing SOAP UI, adding required privileges, retrieving the WSDL file, and submitting a sample request payload to create an invoice. 2. Key steps include installing SOAP UI, adding privileges for the APP_IMPL_CONSULTANT user, retrieving the WSDL from the URL provided, and submitting an XML request payload with invoice header and line details to call the createInvoiceInterface web service. 3. The sample payload creates a test invoice for $100 USD with a single line item and required header fields like vendor, organization, and terms details.

Uploaded by

Satya Vissakoti
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

Steps to create invoice using Web Service: createInvoiceInterface

Pre-Requisites to Implement Web Service with SOAP UI

1. Install SOAP UI https://www.soapui.org/downloads/soapui.html ( Soap Open Source UI)


2. Login to Fusion Applications -> Navigate to Tools -> Security Console
3. Add below privileges to the user who is trying to create the invoice using Web service.

The following tables list the privileges required to perform the service operations and the duty
roles that each privilege is granted to.
Service operations to Privileges Mapping:

4. Execute LDAP Jobs


4.1. Retrieve Latest LDAP Changes
4.2. Send Pending LDAP Requests

5 . Login to Fusion Applications as APP_IMPL_CONSULTANT -> Tools -> Developer


Connect and search with Payables% web services
WSDL File and AP Invoice Creation Payload

WSDL File :
https://xxxx.fa.us2.oraclecloud.com:443/fscmService/InvoiceInterfaceService?WSDL

Launch SOAP UI > Click on SOAP > Create New Project > Enter Initial WSDL value( Copied
from Step 5 ) and Named Project as InvoiceCreation
Click on Request1 and fill the required columns
Enter Authorization Details

Click on the Auth at bottom of the Request Payload

Add new Authorization > Type : Basic


Click on Green Run button
Request Payload:

<soapenv:Envelope xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:typ="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInte
rfaceService/types/"
xmlns:inv="http://xmlns.oracle.com/apps/financials/payables/invoices/quickInvoices/invoiceInte
rfaceService/">

<soapenv:Header/>

<soapenv:Body>

<typ:createInvoiceInterface>

<typ:invoiceInterfaceHeader>

<inv:Source>External</inv:Source>

<inv:OrgId>300000017871360</inv:OrgId>

<inv:VendorId>300000018327939</inv:VendorId>

<inv:VendorSiteId>300000018328066</inv:VendorSiteId>

<inv:AcctsPayCodeCombinationId>10023</inv:AcctsPayCodeCombinationId>

<inv:GroupId>1</inv:GroupId>

<inv:InvoiceAmount currencyCode="USD">100</inv:InvoiceAmount>
<inv:InvoiceCurrencyCode>USD</inv:InvoiceCurrencyCode>

<inv:InvoiceDate>2018-06-19</inv:InvoiceDate>

<inv:InvoiceNumber>VS_AP_02</inv:InvoiceNumber>

<inv:InvoiceReceivedDate>2018-06-19</inv:InvoiceReceivedDate>

<inv:InvoiceTypeLookupCode>STANDARD</inv:InvoiceTypeLookupCode>

<inv:LegalEntityId>300000001053206</inv:LegalEntityId>

<inv:PartyId>300000018327937</inv:PartyId>

<inv:PartySiteId>300000018327989</inv:PartySiteId>

<inv:PayGroupLookupCode>Standard</inv:PayGroupLookupCode>

<inv:PaymentCurrencyCode>USD</inv:PaymentCurrencyCode>

<inv:PaymentMethodCode>CHECK</inv:PaymentMethodCode>

<inv:PaymentPriority>99</inv:PaymentPriority>

<inv:TermsDate>2018-06-19</inv:TermsDate>

<inv:TermsId>10001</inv:TermsId>

<inv:VendorEmailAddress>[email protected]</inv:VendorEmailAddress>

<inv:InvoiceInterfaceLine>

<inv:AccountingDate>2018-06-19</inv:AccountingDate>

<inv:Amount currencyCode="USD">100</inv:Amount>

<inv:Description>test line by AP Webservice</inv:Description>

<inv:DistCodeCombinationId>10023</inv:DistCodeCombinationId>

<inv:ItemDescription>TEST ITEM DESCRIPTION </inv:ItemDescription>

<inv:LineNumber>1</inv:LineNumber>

<inv:LineTypeLookupCode>ITEM</inv:LineTypeLookupCode>
<inv:OrgId>300000017871360</inv:OrgId>

</inv:InvoiceInterfaceLine>

</typ:invoiceInterfaceHeader>

</typ:createInvoiceInterface>

</soapenv:Body>

</soapenv:Envelope>
Submit Import Payables Invoices ESS Job
Request completed successfully

Invoice created successfully

You might also like