My Oracle Support Banner

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

Last updated on OCTOBER 10, 2021

Applies to:

Oracle Health Sciences Data Management Workbench - Version 3.0.0 and later
Information in this document applies to any platform.


On Oracle Health 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.

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


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

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