My Oracle Support Banner

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 JUNE 16, 2020

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.4 and later
Oracle Payables - Version 12.2.4 and later
Information in this document applies to any platform.

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution


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