Balance Brought Forward and Total Bill Amount Incorrect when Already Paid (Doc ID 2398196.1)

Last updated on AUGUST 10, 2023

Applies to:

Symptoms

On : 7.5.0.0.0 version, Invoicing

ACTUAL BEHAVIOR
----------------------
Customers have paid their bill, but on the following invoice that is created - the Bill shows the amount paid as a Balance Brought Forward still.
This is incorrect, the Invoice doesn't match to the values in the database (doesn't reflect balance brought forward).

Snippets of the cm.pinlog

EXPECTED BEHAVIOR
-----------------------
The expected behavior is to have the same value in the Invoice and the database.

STEPS
-----------------------
1.Try with an account that has DD set up, and schema other than 1
2. Let initial 1-2 payments be via DD
3. Then for the next bill, do DD payment, reverse it, do an offline payment
4. Do this payment using Payment Tool. Make sure to load from pin01 of the payment tool.
5. The payment needs to remain unallocated at account level.
Let the payment be allocated using tstbulk_overpayment_allocation.

BUSINESS IMPACT
-----------------------
Bill Presentment - Negative Experience, a balance showing as Brought Forward when already paid before Next Invoice creation date.

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.