CMT: Some Of AU Columns On AU_ACCOUNT_T And AU_PURCHASED_BUNDLE_T Are Populated With Incorrect Values (Doc ID 2041179.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Communications Billing and Revenue Management - Version 7.5.0.0.0 to 7.5.0.0.0 [Release 7.5.0]
Information in this document applies to any platform.

Symptoms

On :  7.5.0.6.0 version, Conversion Manager



ACTUAL BEHAVIOR  
----------------------
 AU* fields  for  AU_ACCOUNT_T and AU_PURCHASED_BUNDLE_T tables are not correctly populated.

NOTE: The issue exists only on Multi schema setup, these fields are getting populated correctly on single DB setup.


EXPECTED BEHAVIOR
-----------------------
1. AU_PURCHASED_BUNDLE_T.AU_PARENT_OBJ_ID0 should be equal to PURCHASED_BUNDLE_T.POID_ID0 and it should be similar for all AU_PARENT_* columns.

2. For AU_ACCOUNT_T, issue reported is AU_PARENT_OBJ_DB should be 2 as it is db2. Currently it is 1.


STEPS
--------
The issue can be reproduced at will with the following steps:

1. Run pin_cmt -import -file <<XML_Filename>> <<Stage_id>>
2. Run pin_cmt -deploy -1 <<Stage_id>>
3. Check the DB results.


BUSINESS IMPACT
-----------------------
This is data corruption in Audit tables.

Cause

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