VC Install Job Is Failing - You do not have permission to update validation status (Doc ID 2811418.1)

Last updated on JULY 13, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench 3.0.0 version, Validation

When attempting to do VC Install, the process fails and
the following error occurs in the logfile.

ERROR
-----------------------
XFM_INSTALL:03-AUG-21 16:35:42:************ TIME SPENT IN DIAGNOSE XFM STAGE: 0 SECONDS *******************
XFM_INSTALL:03-AUG-21 16:35:42:Table '<TABLE_NAME>', <Version <ver_no> - You do not have permission to update validation status (UNAME=<USER_NAME>)
XFM_INSTALL:03-AUG-21 16:35:42:Validation status update Failed for one or more contained objects.
XFM_INSTALL:03-AUG-21 16:35:42:User-Defined Exception in Package installXForm Procedure dme_df_xform_map
XFM_INSTALL:03-AUG-21 16:35:42:SQL Error Occurred ORA-ERR No : User-Defined Exception, Function Name : installXForm, Package Name : dme_df_xform_map. Please contact your System Administrator.
XFM_INSTALL:03-AUG-21 16:35:42:EXCEPTION:Update Install Flag:ORA-20000: Row is Locked - Update Row
Requesting lock $CDR$<COMP_ID>$852360277$DEF in EXCLUSIVE mode for user <USER_NAME> at 03-AUG-2021 04:35:40
:
:
"
Requesting lock $CDR$<COMP_ID>$852360277$DEF in EXCLUSIVE mode for user <USER_NAME> at 03-AUG-2021 04:35:42

Job failed with error(s).
ORA-20200: *** ERROR: Exception while Installing the VC Batch..Hence cannot proceed further
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INST_XFORM_MAP", line 12933
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 23573
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 16158

Cause

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