7.8.3 Reinstall Existing Oracle LSH Workflows

After you install Oracle LSH and stop OWB Services, you must reinstall any existing workflows using the cdrupgworkflows.sql script. The following procedure includes details to run the script and reinstall the workflows in different ways depending on how you want to do it. For example, you can reinstall the existing Oracle LSH workflows under all application areas or under a set of application areas. Or, you can reinstall a single workflow instance in a particular work area.

Note:

If you did not use the Oracle LSH Workflow feature in past releases, you can skip this procedure.

1. On the Oracle LSH server, navigate to the $CDR_TOP/patch/115/sql. Then copy the cdrupgworkflows.sql file for the Oracle Database server.
2. Log in to the Oracle Database as APPS.
3. Run the cdrupgworkflows.sql script you copied from the Oracle LSH server. You see the following message:
   Enter application area names as a comma-delimited list (ex. AA1,AA2) or enter ALL for all application areas. Do not enter anything if you want to re-install a single workflow instance The list should not exceed 240 characters.
   Application Area Names:
4. At the Application Area Names prompt, enter the application area name. You see the following message:
   Do you want to reinstall the Workflows even if they have been reinstalled already in 3.0 ? Enter YES or NO
5. Enter NO unless you want to reinstall the workflows again. (To reinstall them again, enter YES.) You see the run date and name of the application area you chose. For example:

   Run Date = 18-MAY-2020 05:07:39 
   Application Area Names = "DK_AA" 
   

   You also see:
   This script will re install the workflow instances in the specified application areas To continue, press upper-case Y and Return key. Press any other key to abort:
6. Enter Y to continue.
   Here is a sample of the type of output you see:

   ********************** WITHIN WORKFLOW UPGRADE SCRIPT ******************** 
   piWfInstID= 
   piForceInstall=YES 
   piAANames =DK_AA 
   Processing each Application area 
   ------------------------------------------ 
   Upgrading Workflows in Application Area -DK_DOMAIN>DK_AA(Application Area OBJ ID -22770300) 
   Checking the WF -DK_DOMAIN > DK_AA > WA1>wf1(WF_INST_OBJ_ID = 22770307, WF_INST_OBJ_VER =2 
   ,Installed version =1 OWF Desc = LSH3.0) 
   This workflow is installed as per the 3.0 implementation. But user has requested a re install 
   Upgraded the Workflow. New OWF Name =CKKXWOBWupgrade status S 
   ------------------------------------------ 
   Done with processing all the application areas 
   
   *******************************************************************