My Oracle Support Banner

Installation Failure For A Validation Check Batch In Quality Control Life Cycle (Doc ID 2987687.1)

Last updated on NOVEMBER 28, 2023

Applies to:

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


While trying to promote a VC batch from Dev to QC life cycle, the install transformation fails with the following error:

XFM_INSTALL:18-SEP-23 07:06:00:dme_debug_xform_map.diagnoseXfm returned invalidMap=$YESNO$NO
XFM_INSTALL:18-SEP-23 07:06:00:************ TIME SPENT IN DIAGNOSE XFM STAGE: 1 SECONDS *******************
XFM_INSTALL:18-SEP-23 07:06:00:Table '<table name>', Version <version number> - You do not have permission to update validation status (UNAME=<username>)
XFM_INSTALL:18-SEP-23 07:06:00:Validation status update Failed for one or more contained objects.
XFM_INSTALL:18-SEP-23 07:06:00:User-Defined Exception in Package installXForm Procedure dme_df_xform_map
XFM_INSTALL:18-SEP-23 07:06:00: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:18-SEP-23 07:06:00:EXCEPTION:Update Install Flag:ORA-20000: Row is Locked - Update Row
Job failed with error(s). :: 09-18-2023 07:06:00.329
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 13104
ORA-06512: at "APPS.DME_DF_XFORM_MAP", line 24025
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 15804
ORA-06512: at "<CDR schema name>.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Closed connection after completing ZZ user operation :: 09-18-2023 07:06:00.379

********** End of Execution, dumping residue buffered log message **********

Job's execution phase did not completed successfully.




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

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

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