My Oracle Support Banner

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

Last updated on SEPTEMBER 20, 2019

Applies to:

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

Symptoms

On : 12.0.0.1.0 version, Server for PDC

ACTUAL BEHAVIOR
---------------
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.


EXPECTED BEHAVIOR
-----------------------
Account Number should be displayed instead Account Poid

STEPS
-----------------------
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.


Cause

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
Symptoms
Cause
Solution
References


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