Custom ESM Profile Is Not Working After Upgrade To 7.0.1. Cannot Import E2b Successfully
Last updated on JUNE 29, 2017
Applies to:
Oracle Argus Safety - Version 7.0.1 and laterInformation 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
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
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
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
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