InForm Job Fails with 'ORA-01403: no data found' (Doc ID 2970678.1)

Last updated on AUGUST 28, 2023

Applies to:

Symptoms

On Oracle Life Sciences Data Management Workbench (DMW) 2.4.8 version:
when attempting to submit a InForm data load job,
the following error occurs:

ERROR
--------
Error from OWB/CDR DB Server-PLSQL Operator: statement:"begin CDR_WE19_1B5E41_1.PLSQL_UTIL_PROG_PKG.PROCESSPLSQLUTILJOB ; end;" caught:java.sql.SQLException: ORA-20200: *** ERROR: InForm_Submit:Datasource is found - ORA-01403: no data found
ORA-06512: at "APPS.CDR_ATK_UTILS", line 866
ORA-06512: at "APPS.DME_INFORM_MODEL", line 2791
ORA-06512: at "APPS.CDR_EXE_RUNTIME", line 15042
ORA-06512: at "CDR_WE19_1B5E41_1.PLSQL_UTIL_PROG_PKG", line 4
ORA-06512: at line 1

STEPS
-------
The issue can be reproduced with the following steps:
1. Submit an InForm data load job.
2. Check for the job status.

Changes

Cause

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