CMT Performance Issue - Child XML Load Takes A Long Time For Complex Hierarchy Accounts
Last updated on JANUARY 05, 2017
Applies to:Oracle Communications Billing and Revenue Management - Version 126.96.36.199.0 to 188.8.131.52.0 [Release 7.5.0]
Information in this document applies to any platform.
On : 184.108.40.206.0 version, CMT
Child XML load to BRM takes a long time for complex hierarchy accounts.
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.
Truncating the table in production is not an option and so need a resolution without truncation.
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