R12: AP: ECC: Amount Differnce Between Scheduled Amount and Scheduled Accounted Amount in Payables Command Center > Supplier Balance (Doc ID 2681390.1)

Last updated on APRIL 04, 2025

Applies to:

Symptoms

In Payables Command Center > Supplier Balance tab, there is amount mismatch between Open Payables - Supplier Balance and Detailed Insight - Open Invoices - Sum of invoices Scheduled Amount.

As default, each section shows following amount.
  Open Payables - Supplier Balance: sum of invoices Scheduled Accounted Amount(AP_ECC_INSTALLMENTS_V.AMOUNT_REMAINING_BASE).
  Detailed Insight - Open Invoices - Scheduled Amount: Scheduled Amount(AP_ECC_INSTALLMENTS_V.AMOUNT_REMAINING).

If invoices are accounted in functional currency, both columns should be same amount.

However, there is difference between these sections.
If scheduled accounted amount is added to Detailed Insight - Open Invoices section, there is also difference at each invoice level.

There is no difference between AMOUNT_REMAINING and AMOUNT_REMAINING_BASE in view AP_ECC_INSTALLMENT_V.
But Scheduled Amount(AMOUNT_REMAINING) in the front end shows slightly different amount from AP_ECC_INSTALLMENT_V.
Rounded amount is displayed in Scheduled Amount(AMOUNT_REMAINING) in the front end.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.