Sample SOAP Payload to Run a BI Publisher Report

Created a Report Supplier Listing
Below are the properties of the report in Oracle Cloud

WSDL : https://[YourDomain]/xmlpserver/services/ExternalReportWSSService?WSDL

Sample payload to run the report with one parameter.
xmlns:soap="http://www.w3.org/2003/05/soap-envelope"
xmlns:pub="http://xmlns.oracle.com/oxp/service/PublicReportService">
<soap:Header/>
<soap:Body>
<pub:runReport>
<pub:reportRequest>
<pub:attributeFormat>xml</pub:attributeFormat>
<!-- Flatten XML should always be false when we have XML type of output to display the XML tags as mentioned in BIP Data Model and display XML structure in as expected format -->
<pub:flattenXML>false</pub:flattenXML>
<pub:parameterNameValues>
<!--1st Parameter of BIP Report-->
<pub:item>
<pub:name>Supplier_number</pub:name>
<pub:values>
<pub:item>1252</pub:item>
</pub:values>
</pub:item>
</pub:parameterNameValues>
<pub:reportAbsolutePath>/Custom/Procurement/Purchasing/Supplier listing.xdo</pub:reportAbsolutePath>
<!-- Setting sizeOfDataChunkDownload to -1 will return the output to the calling client -->
<pub:sizeOfDataChunkDownload>-1</pub:sizeOfDataChunkDownload>
</pub:reportRequest>
</pub:runReport>
</soap:Body>
</soap:Envelope>

The output of the payload is in base64 format.

Accounts Payables setups in Oracle Fusion

Below are the mandatory setup for Payables in fusion

• Assign Roles to User
• Manage Payables Lookups
• Manage Payment Terms
• Common Options for AP and PO
• Manage Invoice Options
• Manage Payment Options
• Open Payables Periods
• Manage Suppliers

Oracle Fusion Payables:

Oracle Fusion Payables is used to manage invoice and payments of Organization

Assign Roles to User

The Following data roles should be assigned for the User to access the transactions for payables.

1.Account Payables Supervisor

2.Account Payables Specialist.

3.Account Payables Manager.

Step-1: Tools –>Security Console.

Manage payables Lookups

Paygroup is used to group the supplier for payment Process.

Navaigation : Setup and maintainaceà

Financials > Define Invoicing and Payments Configuration >Define Payables > Define payables Configurations>Manage Payables Lookups

Create a paygroup and save and Close

Manage Payment Terms

Payment Terms:

Payment Terms determine due dates, Discount dates and Installment details for the Supplier Invoices.

Due date : It is the last date to make payment for invoice.

Discount Date: It is a last date to get discount for invoice for Supplier.

Term date Basis: It is the base date for the payment terms to calculate due date and discount date.

Navaigation : Setup and maintainaceà

Financials > Define Invoicing and Payments Configuration >Define Payables > Define Common Options for Payables and Procurement >Manage Payment Terms

Enter the values for Discount due date and discount and set assignments and click on Save and close.

Common Options for AP and PO

for AP and PO are the Controlling features at Business Unit level.

There are two types of options.
1.  Common Options for payables and procurement.
2.  General Payables Options.

Common Options for payables and procurement are shared by both payables and procurement.

Navaigation : Setup and maintainaceà

Financials > Define Invoicing and Payments Configuration > Define Payables > Define Common Options for payables and Procurement > Manage Common Options for payables and Procurement

Set the options as per client requirement and click on save and close. 

General Payables options will be shared by only Payables.

Below is the task list for general payables options.

1.Invoice Options

2. Payment Options.

3.Tax Reporting and withholding Tax Options.

Manage invoice Options

1.Invoice Options control how oracle fusion payables control invoice.

Navaigation : Setup and maintainaceà

Financials > Define Invoicing and Payments Configuration > Define Payables > Define General Payables Options > Manage Invoice Options

Manage Payment Options

1.Invoice Options control how oracle fusion payables control Payments.

Navaigation : Setup and maintainaceà

Financials > Define Invoicing and Payments Configuration > Define Payables > Define General Payables Options > Manage Payment Options

Enable all the payment options and click on save and close.

Open Payables Periods

Navigator > Payables >Invoices

Manage Suppliers:

• Supplier is an organization or a person who is supplying goods or services to Organization.
• Suppliers are modeled as a global entity and are not created within a business unit or within any other organizational
• Supplier Sites are associated with a procurement business unit.

The Data roles required to get full access to Supplier and Supplier Sites are

1.Buyer.

2.Supplier Administrator.

Supplier Record Contains of 4 level.

Supplier Profile

Addresses

Sites

Contacts.

Navigation : Procurementà Supplier.

This gives us all the information of Suppliers.