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.

Post Mass Additions Book Parameter List Of Values (LOV) Is Empty

Issue : Post Mass Additions Book Parameter List Of Values (LOV) Is Empty
Solutions:
Case-1 : There are no record in fa_mass_additions interface in POST queue.
Case-2 : provide data access set for the user to Asset boot for the roles Asset Administrator, Asset Accounting Manager.

Sample Soap Payload for Uploading attachment to the requisitions

Sample Soap Payload for Uploading attachment to the requisitions 
<!-- Request Payload -->
<soapenv:Envelope xmlns:erp="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/" xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/" xmlns:typ="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
   <soapenv:Header/>
   <soapenv:Body>
      <typ:uploadAttachment>
         <typ:entityName>POR_REQUISITION_HEADERS</typ:entityName>
<!---POR_REQUISITION_HEADERS – for requisition header attachments
POR_REQUISITION_LINES – for requisition line attachments---->
         <typ:categoryName>MISC</typ:categoryName>
         <typ:allowDuplicate>yes</typ:allowDuplicate>
         <!--Zero or more repetitions:-->
         <typ:attachmentRows>
            <!--Optional:-->
            <erp:UserKeyA>Requsition number</erp:UserKeyA>
            <!--Optional:-->
            <erp:UserKeyB>Business Unit</erp:UserKeyB>
            <!--Optional:-->
            <erp:UserKeyC>#NULL</erp:UserKeyC><!--Line number-->
            <!--provide line number if adding attachments to lines else provide null-->
            <!--Optional:-->
            <erp:UserKeyD>#NULL</erp:UserKeyD>
            <!--Optional:-->
            <erp:UserKeyE>#NULL</erp:UserKeyE>
            <!--Optional:-->
            <erp:AttachmentType>TEXT</erp:AttachmentType>
            <!--Optional:-->
            <erp:Title>SampleFILE.txt</erp:Title>
            <!--Optional:-->
            <erp:Content>Testing Attachment for PO using Requsition number</erp:Content>
         </typ:attachmentRows>
      </typ:uploadAttachment>
   </soapenv:Body>
</soapenv:Envelope>

Response 

<env:Envelope xmlns:env="http://schemas.xmlsoap.org/soap/envelope/" xmlns:wsa="http://www.w3.org/2005/08/addressing">
   <env:Header>
      <wsa:Action>http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService//ErpObjectAttachmentService/uploadAttachmentResponse</wsa:Action>
      <wsa:MessageID>urn:uuid:b09e60ec-9867-43dc-9984-80529b6b39e0</wsa:MessageID>
   </env:Header>
   <env:Body>
      <ns0:uploadAttachmentResponse xmlns:ns0="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">
         <result xmlns="http://xmlns.oracle.com/apps/financials/commonModules/shared/model/erpIntegrationService/types/">"Attachment1":"SUCCEEDED"</result>
      </ns0:uploadAttachmentResponse>
   </env:Body>
</env:Envelope>

Importing Supplier Attachments in oracle Cloud

You can import attachments for supplier profiles, supplier sites and supplier business classifications for existing suppliers. Different types and categories of attachments can be imported.

You can import attachments for:

• Supplier profile
• Supplier sites
• Supplier business classifications

For File type attachments, you must add the file to a .zip file and upload the .zip to the Procurement Suppliers UCM account: /prc/supplier/import.

Multiple files can be added to the same .zip file and can be organized within folders as needed.

The template is designed to accept the path along with the file name. 

 

Place the file ‘PricingSheet-Supplier1.pdf’ used for attachment in company_data.zip and upload to UCM folder /prc/supplier/import in file import and export.

Generate csv from the SupplierAttachmentImportTemplate FBDL .

Upload the file to UCM folder /prc/supplier/import

Run Load Interface File for Import  as Shown below.

 

Once the above process completes Successfully Run “Import Supplier Attachments” with batch Id As Input which was given in FBDL template as Show below.

 

Will get the Status of import as shown below.

 

Supplier screen