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

Last updated on FEBRUARY 07, 2024

Applies to:

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

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