Message-Triggered Submission Fails with ORA-31000: Resource 'http://oracle.pharma.com/cdr/esr.xsd' Is Not An XDB Schema (Doc ID 1595161.1)

Last updated on SEPTEMBER 01, 2016

Applies to:

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

Symptoms

On Oracle Life Sciences Data Hub (LSH) Release 2.2.0.3.

Using Message-Triggered Submission by calling 'CDR_PUB_EXE_MSG_API.SUBMIT_MESSAGE', it fails with the following error message:

ERROR at line 1:
ORA-31000: Resource 'http://oracle.pharma.com/cdr/esr.xsd' is not an XDB schema
document
ORA-06512: at "SYS.XMLTYPE", line 310
ORA-06512: at "APPS.CDR_EXE_ESR_PROCESS", line 1803
ORA-06512: at "APPS.CDR_EXE_MSG_API", line 183
ORA-06512: at "APPS.CDR_PUB_EXE_MSG_API", line 26
ORA-06512: at "ODW_SHLD_USER.OCDA_PLS_ETL_WORKFLOW_PROC", line 38
ORA-06512: at line 3

Cause

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 hundreds of Community platforms