ECC Outstanding Receivables Dashboard Shows Invoice Twice if the Invoice was Modified (Doc ID 2812083.1)

Last updated on DECEMBER 07, 2021

Applies to:

Oracle Enterprise Command Center Framework - Version 12.2.4 to 12.2.10 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When an existing invoice is modified in Receivables, for example, an additional line added to the invoice, that invoice will show twice in the Outstanding Receivables dashboard after the incremental refresh is run. After adding the line, a new payment_schedule_id is created. The invoice now shows twice with the interim refresh but corrects itself when the full refresh is run.

Steps to Reproduce:

Responsibility: Receivables Manager
Navigation: Receivables Command Center

Create an invoice in AR and complete it.
Run the incremental refresh. The above invoice shows in Outstanding Receivables tab (correct).
Go back to AR and incomplete the invoice from #1, and add a line to it, save and complete.
Run the incremental refresh. The above invoice now shows twice in Outstanding Receivables tab. Once with the original balance, once with the total balance after adding another line.