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 NOVEMBER 12, 2024
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 <
2. Run pin_cmt -deploy -1 <
3. Check the DB results.
BUSINESS IMPACT
-----------------------
This is data corruption in Audit tables.
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 |