My Oracle Support Banner

BRM 12 Upgrade: BOC Failure Report Showing POID Instead Of Account Number (Doc ID 2543481.1)

Last updated on FEBRUARY 07, 2024

Applies to:

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


On : 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. to some other number
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

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