PCM_OP_COLLECTIONS_CALC_AGING_BUCKETS Issue (Doc ID 2384639.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

On Oracle Communications Billing and Revenue Management (BRM) version 7.5.0.17.0, Collections Manager (CM):

ACTUAL BEHAVIOR
PCM_OP_COLLECTIONS_CALC_AGING_BUCKETS is calculating the wrong due amounts in a scenario.  When an account has two billinfos (where one is paying and the other is a non-paying billinfo), the aging due is getting calculated wrongly.  The aging due is doubled.

For example, Account A1 has two billinfos (B1 and B2) where B1 is paying and B2 is non-paying.

If the usage of $100 is posted on B1 and B2.  The bill generated on B1 would be $200 as it is paying for both B1 ($100) and B2 ($100).  When aging info is executed for the account, it shows $300 but the expected amount is $200.

EXPECTED BEHAVIOR
OP_COLLECTIONS_CALC_AGING_BUCKETS should return the total due amount of the actual charges of the paying and non-paying billinfos.

STEPS
The issue can be reproduced at will with the following steps:
1. Create an account A1
2. Create two billinfos (B1 and B2) one paying and another non paying with subordinate paytype 10007.  The AR billinfo for the non-paying account should point to billinfo 1 (B1).
3. Create usage on B2 like $100 charge.
4. Bill the account.
5. Move the PVT after due date and run the opcode PCM_OP_COLLECTIONS_CALC_AGING_BUCKETS.

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.