My Oracle Support Banner

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

Last updated on AUGUST 28, 2023

Applies to:

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


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 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

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




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.