Custom ESM Profile Is Not Working After Upgrade To 7.0.1. Cannot Import E2b Successfully

(Doc ID 1468024.1)

Last updated on JUNE 29, 2017

Applies to:

Oracle Argus Safety - Version 7.0.1 and later
Information in this document applies to any platform.
***Checked for relevance on 24-JUL-2014***
***Checked for relevance on 29-JUN-2017***

Symptoms

ESM is writing the following errors in the error_log table when importing E2B file using the custom profile:

Error 1:

Error in CFG_E2B.AE_USER_PROC for Profile ICH-ICSR V2.1 MESSAGE TEMPLATE - EMA V1.2, DTD Element PATIENTEPISODENAME
ORA-06550: line 30, column 7:
PLS-00306: wrong number or types of arguments in call to 'GET_MEDDRA_INFO'
ORA-06550: line 30, column 7:
PL/SQL: Statement ignored


Error 2:

Error in CFG_E2B.AE_USER_PROC for Profile ICH-ICSR V2.1 MESSAGE TEMPLATE - EMA V1.2, DTD Element MEDICINALPRODUCT
ORA-06550: line 124, column 2:
PLS-00306: wrong number or types of arguments in call to 'P_ENCODE_DRUG'
ORA-06550: line 124, column 2:
PL/SQL: Statement ignored
ORA-06550: line 175, column 7:
PLS-00306: wrong number or types of arguments in call to 'P_INSERT_INDICATION'
ORA-06550: line 175, column 7

Error 3:

Error in CFG_E2B.AE_USER_PROC for Profile ICH-ICSR V2.1 MESSAGE TEMPLATE - EMA V1.2, DTD Element PATIENTLASTMENSTRUALDATE
ORA-06550: line 27, column 43:
PLS-00302: component 'F_FULL_DATE_IN_CHAR' must be declared
ORA-06550: line 27, column 10:
PL/SQL: Statement ignored


Error 4:

Error in CFG_E2B.AE_USER_PROC for Profile ICH-ICSR V2.1 MESSAGE TEMPLATE - EMA V1.2, DTD Element RECEIVEDATE
ORA-06550: line 20, column 26:
PLS-00302: component 'F_DATE_IN_CHAR' must be declared
ORA-06550: line 20, column 26:
PLS-00302: component 'F_DATE_IN_CHAR' must be declared
ORA-06550: line 20, column 14:
PL/SQL: ORA-00904: "ESM_IMP_UTL"."F_DATE_IN_CHAR": invalid identifier
ORA-06550: line 20, column

 

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