Billing Care: Displaying Parent Account Poid Instead Of Parent Account No For Child Account (Doc ID 2878789.1)

Last updated on AUGUST 31, 2022

Applies to:

Symptoms

The issue can be reproduced at will with the following steps:

1.30 MARCH: In (Billing Care) BC, Create an invoice account and purchase some MCF charges, lets call this parent account, DOM =1, bill cycle is 30 MARCH to 1 MAY
2.In BC, Create an invoice account and purchase some MonthlyCycleForward(MCF) charges, lets call this child account, DOM=1, bill cycle is 30 MARCH to 1 MAY
3.In BC, open the parent account and add the child account under hierarchy, and also add the child billinfo as a non-paying account in the billinfo hierarchy
4.Need to change the account number of parent account to see the issue… so run below query in sql developer:

update account_t set account_no = 'qaz123' where poid_id0=5972865; -- this is the parent account
commit;
1 MAY: Run pin_bill_day
1 JUNE: Run pin_bill_day
Open child account with Bills tab  ,See that Bill in progress shows account number, that is, 'qaz123'  switch to a bill now it shows parent account number as “0.0.0.1-5972865” instead of “qaz123” …. This is the issue.

ACTUAL BEHAVIOR
---------------
In case of child account , under bills tab paid by parent account number is displayed correctly for bill in progress but for all previous bills it displays parent account poid .

EXPECTED BEHAVIOR
-----------------------
Under Child Account under Bill in progress it should shows account number

Cause

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