DMW: Error "InForm_Submit:SD, Query And DMW FLAG Programs Are Skipped Due To Loadset Data Adapter Failure" (Doc ID 2702960.1)

Last updated on JULY 13, 2023

Applies to:

Goal

On Oracle Life Sciences Data Management Workbench (DMW) 2.4.8.4, when attempting to submit an InForm data load job, it fails with the following error:

Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_W###_######_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: InForm_Submit:SD, Query and DMW FLAG programs are skipped due to Loadset Data adapter failure - User-Defined Exception
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 2736
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 14988
ORA-06512: at "CDR_W###_######_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

Solution

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