PCM_OP_AR_GET_ACCT_BILLS & PCM_OP_AR_GET_BILLS Opcodes Return Incorrect Bill Total
(Doc ID 2860112.1)
Last updated on AUGUST 10, 2023
Applies to:Oracle Communications Billing and Revenue Management - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
One was using only Balance Forward Accounting (actg_type 2) and later planned to support even Open Item accounting (actg_type 1). Options were even provided to change the accounting type which was initially created as balance forward.
In the InvoiceList view (in Siebel) the total amount of the bill (TOTALS) appears to be incorrect and does not match the invoice amount ( PCM_OP_AR_GET_ACCT_BILLS is getting called by the QueryInvoiceList composite).This is a big issue for agents as customers often communicate their invoice total when calling customer and bills cannot be identified by bill total.
Bill total calculations:
For Balance Forward Accounting
CURRENT_TOTAL + SUBORD_TOTAL + PREVIOUS_TOTAL
For Open Item Accounting
CURRENT_TOTAL + SUBORD_TOTAL
Snippet from OP_AR_GET_ACCT_BILLS_outputFlist
In BILL_NO B1-4610488 for both actg_type 2 and 1 it is retuning 60 as TOTALS
When accounting type is Balance Forward Accounting it should return 495 instead of 60.
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