Different Number Of Workflows Between DEV (DR) And PROD (RR) In 'Workflow Process Monitoring Configuration View' Due To COMPILED_OBJ_DEFN Migrated As Empty (Doc ID 3037157.1)

Last updated on OCTOBER 01, 2024

Applies to:

Symptoms

Under "Workflow Process Monitoring Configuration View"  that shows  how many workflows are activated in the application, it was noticed a different number of active workflows in RR environment than in DR environment.

On further research, this difference was caused by COMPILED_OBJ_DEFN column in S_RR_WORKFLOW table: for inactive workflows this column was set to NULL in DR environment and for some records it was an empty string in RR environment.

The following issue was reproduced in standard 24.1 application: during an incremental migration, NULL values in COMPILED_OBJ_DEFN  column are migrated as empty string.

Reproducible steps:

1. Execute a  full migration from DR to RR. Check that there are no empty values in COMPILED_OBJ_DEFN column.
2. Login to Tools in DR environment
3. Create a workspace and activate workflow 'BIP Report Generation'. Deliver the workspace to MAIN.
4. Create a second developer workspace and  inactivate workflow 'BIP Report Generation'. Deliver the workspace to MAIN.
5. Check that on the DR database, in S_RR_WORKFLOW table,  the record corresponding to 'BIP Report Generation' workflow and having maximum VERSION_NUM  has  COMPILED_OBJ_DEFN set to NULL. This is correct as the workflow has been inactivated.
6. Execute an incremental migration from DR to RR.
7. Check the record corresponding to  'BIP Report Generation' workflow in S_RR_WORKFLOW table in RR database: it has COMPILED_OBJ_DEFN an empty string with 0 characters, while in DR the column was  NULL.

 

Changes

 Issue was observed after incremental migration.

Cause

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