Incorrect Copybook Override Used on Attached Business Rules in Production Mode (Doc ID 3005065.1)

Last updated on FEBRUARY 16, 2024

Applies to:

Symptoms

Actual Behavior
============
In production mode after restarting the application server, if the first policy to process the activity that uses ValidateExpression is on a plan where the global version of the secondary copybook is used, any subsequent policy that processes this activity should be picking up the plan level override for this secondary copybook, but is not. It is instead getting the validation on the global override version. In the server log, the sql to load this copybook on this subsequent policy is correctly getting the plan level overruled first in the result set. Vice versa, if the first policy to process this activity after an application restart is on the plan with the copybook override, the correct plan levels override is used. If the subsequent policy to process after this should be using the global level override, it correctly loads the global override.

Expected Behavior
=============
Correct copybook override should be used for the appropriate policy/plan.

Steps To Reproduce
===============

1. Create transaction on the Product level.
   1. Transaction should have a ValidateExpression attached rule that uses a CopyBook.
   2. Within that CopyBook needs to a be a secondary Copybook.
      1. Secondary CopyBook needs to have a Global and a plan level override.
      2. The Global version of this secondary copybook has a validation while the plan override does not.
2. Turn on Production Mode and restart application server.
3. Process the activity that uses this ValidateExpression on a plan where the global version of the secondary copybook is used.
   1. Any subsequent policy that processes this activity should be picking up the plan level override for this secondary copybook.
   2. These policies are getting the validation on the global override version.
   3. In the server log you can observe that the sql to load this copybook on this subsequent policy is correctly getting the plan level override first in the result set. .

Cause

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