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:

Symptoms

Background:
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. 

Problem:
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

Actual Behavior:
In BILL_NO B1-4610488 for both actg_type 2 and 1 it is retuning 60 as TOTALS

Expected  Behavior:
When accounting type is Balance Forward Accounting it should return 495 instead of 60.

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.