BRM 12 Upgrade: BOC Failure Report Showing POID Instead Of Account Number
(Doc ID 2543481.1)
Last updated on JUNE 27, 2022
Applies to:Oracle Communications Billing and Revenue Management - Version 18.104.22.168.0 and later
Information in this document applies to any platform.
On : 22.214.171.124.0 version, Server for PDC
When the Billing job is scheduled, job is completed and in failure report generated with Bill error and observed Account POID is displayed instead of Account Number.
Account Number should be displayed instead Account Poid
The issue can be reproduced at will with the following steps:
1.Set pvt one month behind
2.Create an account , i.e account poid created is 432032
3.Change account_no from root.0.0.0.1-432032 to some other number 0.0.0.1-432032-1
4.Run below query to change bal_grp poid to wrong number
5.update billinfo_t set bal_grp_obj_id0 = bal_grp_obj_id0 + 1000 where account_obj_id0 in (select a.poid_id0 from account_t a, account_nameinfo_t b where a.poid_id0 = b.obj_id0 and b.first_name like 'inv_fail_bill%');
6.Set pvt to current date
7.Create a immediate billing job in BOC
8.Check history for billing job with status failed and link to failure report
9.Click open View failure report.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document