Balance Brought Forward and Total Bill Amount Incorrect when Already Paid

(Doc ID 2398196.1)

Last updated on MAY 17, 2018

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 and later
Information in this document applies to any platform.

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).

cm.pinlog
-------------
E Sun Feb  4 03:11:58 2018  NewCoC3-brm01  cm_b_02:12746  fm_bill_new_item_txfr.cpp:1224 2:NewCoC3-brm01:vf_bulk_overpayment_allocation:12724:-188814448:126:1521203321:4:root.0.0.0.2:::
fm_bill_create_txfr_evt error
<location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1
errno=PIN_ERR_NOT_FOUND:3>
<field num=PIN_FLD_DESCR:5,54 recid=0 reserved=0 reserved2=0
time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
E Sun Feb  4 03:11:58 2018  NewCoC3-brm01  cm_b_02:12746 fm_bill_new_item_txfr.cpp:6212:NewCoC3-brm01:vf_bulk_overpayment_allocation:12724:-188814448:126:1521203321:4:root.0.0.0.2:::
op_bill_new_item_txfr error
<location=PIN_ERRLOC_FLIST:6 class=PIN_ERRCLASS_SYSTEM_DETERMINATE:1
errno=PIN_ERR_NOT_FOUND:3>
<field num=PIN_FLD_DESCR:5,54 recid=0 reserved=0 reserved2=0
time(sec:usec)=0:0>
<facility=0 msg_id=0 version=0>
D Sun Feb  4 03:11:58 2018  NewCoC3-brm01  cm_b_02:12746 fm_bill_item_transfer.c:2162:NewCoC3-brm01:vf_bulk_overpayment_allocation:12724:-188814448:126:1521203321:4:root.0.0.0.2:::
op_bill_item_transfer return flist
# number of field entries allocated 20, used 3
0 PIN_FLD_POID           POID [0] 0.0.0.2 /item/payment 2596738358 1
0 PIN_FLD_RESULT         ENUM [0] 1
0 PIN_FLD_DESCR           STR [0] "Succeeded"

 

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

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

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Bill Presentment - Negative Experience, a balance showing as Brought Forward when already paid before Next Invoice creation date.

Changes

 

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms