PCM_OP_COLLECTIONS_CALC_AGING_BUCKETS Is Showing the Wrong Due Amounts After De-Consolidation (Doc ID 2363229.1)

Last updated on MAY 03, 2021

Applies to:

Symptoms

ACTUAL BEHAVIOR
-----------------------
When hierarchical accounts which have due on child bill, is de-consolidated, the opcode PCM_OP_COLLECTIONS_CALC_AGING_BUCKETS is returning results with old bill due generated when the account was a child.


EXPECTED BEHAVIOR
-----------------------
The dues of the child account before de-consolidation should not be returned by the opcode.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Create two accounts (A1 & A2)
2. Consolidate one account under other i.e., A1 (paying Parent account) , A2 (Child account)
3. Make usage of $200 on parent account and $100 on child account and run billing
4. Bill (B1-1) got generated with 300$
5. De-consolidate accounts i.e., remove A2 from the hierarchy
6. Make usage of 50$ on A2 and bill the account. Bill (B1-2) with 50$ is produced
7. Execute PCM_OP_COLLECTIONS_CALC_AGING_BUCKETS; parent shows 300$ and child shows 150$ (wrong) in buckets

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.