CMT Performance Issue - Child XML Load Takes A Long Time For Complex Hierarchy Accounts (Doc ID 1953880.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.4.0 version, CMT

Child XML load to BRM takes a long time for complex hierarchy accounts.

ACTUAL BEHAVIOR  

For complex hierarchy accounts migration, parent accounts are loaded through one xml and the child accounts are loaded through another xml. The child xml load to BRM is very slow and takes a long time.


Checked after truncating the cmt_reference_t table in the Performance environment:
Before truncating, the table had 25 million records and an xml with 37.5K child accounts took more than 2 hours to load. After truncating the table, the child xml for the same volume of records loaded in 7 minutes.

EXPECTED BEHAVIOR

Truncating the table in production is not an option and so need a resolution without truncation.

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