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 to [Release 7.5.0]
Information in this document applies to any platform.


On : version, Conversion Manager

 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.

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.

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

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

This is data corruption in Audit tables.


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