My Oracle Support Banner

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 FEBRUARY 01, 2018

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

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


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