Incorrect Values For AR_Billinfo And Parent_Billinfo In Bill_t During Upgrade (Doc ID 1412383.1)

Last updated on MARCH 13, 2012

Applies to:

Oracle Communications Billing and Revenue Management - Version: 6.5.0.0.1 to 7.3.0.0.1 - Release: 6.5.0 to 7.3.0
Information in this document applies to any platform.

Goal

The OOTB upgrade script does always update the historic bills with the current values of ar_billinfo_obj and parent_billinfo_obj. There are cases where the accounts have been moved amongst different billing accounts and bills generated have been different for each case. The upgrade script, it simply updates all values with the accounts current ar_billinfo_obj and parent_billinfo_obj id values.

Please confirm if this (below OOB query) will not have any impacts in the upgraded environment.

UPDATE bill_t b
SET (b.ar_billinfo_obj_id0 ,b.ar_billinfo_obj_db ,b.ar_billinfo_obj_type      ,b.ar_billinfo_obj_rev ,b.billinfo_obj_db ,b.billinfo_obj_id0 ,b.billinfo_obj_rev ,b.billinfo_obj_type
,b.parent_billinfo_obj_db ,b.parent_billinfo_obj_id0 ,b.parent_billinfo_obj_rev ,b.parent_billinfo_obj_type) =
(SELECT bi.ar_billinfo_obj_id0 ,bi.ar_billinfo_obj_db ,bi.ar_billinfo_obj_type ,bi.ar_billinfo_obj_rev ,bi.poid_db ,bi.poid_id0 ,bi.poid_rev ,bi.poid_type
,bi.parent_billinfo_obj_db ,bi.parent_billinfo_obj_id0 ,bi.parent_billinfo_obj_rev ,bi.parent_billinfo_obj_type FROM billinfo_t bi
WHERE bi.account_obj_id0 = b.account_obj_id0
AND bi.account_obj_type = b.account_obj_type
AND bi.account_obj_db = b.account_obj_db
);

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms