Detached Migrations With Rule Conflicts (Doc ID 3065472.1)

Last updated on JANUARY 02, 2025

Applies to:

Symptoms

On : 11.3.1.6 version, General

ACTUAL BEHAVIOR
---------------
As part of trying to create large Release Packages with multiple Configuration Packages the Rules Palette stops creating a package when there are conflicting rule versions when using detached migrations.

For non-detached migrations, rule conflict logic appears to work with the latest rule version migrating successfully.
For detached migrations, however, rule conflict logic appears to identify and call out rule version conflicts but attempts to write multiple copies of the rule into the detached migration package.
It also does not provide a popup with an error message and pushes the release package into the BUILT section of Release Packages.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Add multiple Configuration Packages that have different versions of the same rule into the same configuration package.
2. Make sure detached migration is selected as part of creating the release package.
3. Build the package.

Results: The package will move into the BUILT section of Release Packages but the generated ZIP file will only contain a subset of the required rule XML files along with not adding the ReleaseManfifest.XML file too.

Upgrading from V10.2.0.39 to V11.3.1.6
This issue caused users to spend a lot of time while attempting to use Detached Migrations to migrate our config from our Build environment to our System Testing Environment.
This bug will continue to cause issues for all future migrations where the same rule is included in multiple config packages.

### Workaround ###
We have written SQL to
(1) find all rules listed in more than one configuration package that is in a Ready To Migrate status;
(2) for each rule found, identify the highest version number present;
(3) delete all lower versions from config packages.

Changes

Cause

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