PCM_OP_COLLECTIONS_CALC_AGING_BUCKETS Issue Due To SR 3-16323836501

(Doc ID 2384639.1)

Last updated on APRIL 16, 2018

Applies to:

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

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.

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