Cloud

Supplier Site Setup for Payables Payments created using REST API

Oracle Circle

Payments REST API and its dependence on Supplier Site setup:

Payments REST API is a useful automated way to create payments (partial or full) against open Payables Invoices. Sample REST API Payload to achieve this is shown below.

API Name: fscmRestApi/resources/latest/payablesPayments

Screenshot1 Bad Payload

PayeeSite field on the payload corresponds to the supplier site name that the Payables Invoice belongs to. While submitting this payload via this web service, it can sometimes give the below error on the response message.

“The value for the attribute Site is invalid. Provide a valid value. (AP-810667)”

Oracle - Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud
Guide to Oracle Cloud: 5 Steps to Ensure a Successful Move to the Cloud

Explore key considerations, integrating the cloud with legacy applications and challenges of current cloud implementations.

Get the Guide

This error can happen due to the same site being associated with multiple Business Units, and API cannot differentiate between either Business Units, even though Business Unit is part of the payload.

Also, note that the Payment Business Unit could be different from than Invoice Business Unit.

Screenshot2 Bad Supplier Setup

Resolution:

Create Supplier sites in supplier maintenance with a unique site name. For example, appending a prefix or a suffix as shown in the payload below:

Screnshot4 Good Supplier Setup

Once sites are set up like above, the below payload should work (assuming all other values are valid) and create the payment against the Invoice.

Screenshot3 Good Payload

 

 

About the Author

Amit has over 20 years experience in design and implementation of  solutions for Oracle’s Cloud and EBusiness Suite products, across various medium to large scale industries such as Manufacturing, Energy, Retail, Government, Telecommunications, Food and Beverages, Aviation, Shipping, Mining, Publication, Media, Agriculture and Trading. His application knowledge spans across multiple Oracle ERP areas like Financials, Procurement, Supply chain, Manufacturing, Projects, in addition to Technical tools and platforms like Oracle Forms, Oracle Reports, Workflow, BI Publisher, OTBI, Linux, Oracle SOAP and REST APIs using Python and Cloud Integration Tools like OCI.

More from this Author

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Subscribe to the Weekly Blog Digest:

Sign Up
Categories