[Fusion] Understanding Payments in Oracle Fusion

 

Introduction

Payments are one of the most important parts of Oracle Fusion Accounts Payable. Every business receives invoices from suppliers, processes them, and finally pays those suppliers using checks, bank transfers, or electronic payments.

For many beginners, payment-related tables and terms in Oracle Fusion can feel confusing. Terms like invoice, payment, check, remittance advice, and payment status are often mixed together.

This post explains Oracle Fusion Payments in simple language so technical and non-functional users can understand the complete payment flow easily.

 

Invoice

A document sent by seller to buyer requesting payment for goods or services. It is a bill that says how much money needs to be paid.

Payment

Transfer of money from buyer to seller to settle an invoice or amount due. It is the actual giving/sending of money.

Remittance Advice

A document or message sent by payer to payee informing that payment has been made. It is payment confirmation that tells which invoice was paid.

Let's see data in the Oracle Fusion for Invoice:

• Open fusion instance and Click on Navigator and then click Invoices under Payables

• On Invoices screen, click on Tasks and then select Manage Invoices

• On Manage Invoices screen enter the Invoice Number and click Search button

• Run this query to get Invoice details and copy the Invoice Id:

SELECT * FROM ap_invoices_all aia WHERE aia.invoice_num = '2426266'

• Now run this query to get Invoice payments details and by putting the Invoice Id and then copy the CHECK_ID

SELECT * FROM ap_invoice_payments_all aipa

WHERE aipa.invoice_id = '300002527824311'

• Now run the below query to get payment details and then copy the PAYMENT_ID and CHECK_NUMBER:

select PAYMENT_ID, CHECK_NUMBER from ap_checks_all aca

where aca.check_id ='300002527730164'

• Now run the below query to get SRA_CREATED column which will tell us if remittance advice is created or not (If it's Y) :

select SRA_CREATED from IBY_PAYMENTS_ALL ipa where payment_id='1780406'

Let's see data in the Oracle Fusion for Payment:

• Open fusion instance and Click on Navigator and then click Payments under Payables

• On Payments screen click on Tasks and then select Manage Payments

• On Manage Payments screen, enter the Check_Number in Payment Number and click Search button

• Click on the Payment Number and check the details:

• Click on Paid Invoices tab to view the invoices for which this payment has been created