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 laterInformation in this document applies to any platform.
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
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
Symptoms |
Changes |
Cause |
Solution |