How to Improve Performance of PPC Migration from One Environment to Another (Doc ID 2985735.1)

Last updated on DECEMBER 13, 2023

Applies to:

Goal

OHI Product: Oracle Health Insurance Claims Adjudication
OHI Version: 3.22.2.0.12
Screen/Interface where problem occurs: CMT Migration for Provider Pricing Clauses

The goal is to migrate the production configuration to a lower environment.  One of the bigger items for migration is the Provider Pricing Clauses.  To get an estimate on Provider Pricing Clauses CMT build, we tried building CMT for one item and it took 15 minutes. So based on this timeline of 15 minutes per item and total item count of 55,823, this will take around 580 days to complete which is excessive. Our goal is to complete this migration within a day.
Is there a way to improve the performance of the PPC Migration?

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.