ESM Service Is Writing "PLS-00306: wrong number or types of arguments in call to 'P_ENCODE_DRUG'" Errro In The ERROR_LOG Table When Importing An E2B File (Doc ID 1453433.1)

Last updated on MAY 03, 2012

Applies to:

Oracle Argus Safety - Version 5.1.3 and later
Information in this document applies to any platform.

Symptoms

ESM Service is writing the following error in the import log file when trying to import an E2B file:

"Critical Error occurred while moving data to staging area. <CASE_ID:XXX> <SEQ_NUM:XXX>. Please see ERROR_LOG table for detail errors for report_id (XXXX)"

The following error is there in the error_log table when queried based on the report_id in the import log file:

"Error in CFG_E2B.AE_USER_PROC for Profile XXXX - EMEA V2.0 - ICH-ICSR V2.1 - MT, DTD Element MEDICINALPRODUCT

ORA-06550: line 123, column 9:
PLS-00306: wrong number or types of arguments in call to 'P_ENCODE_DRUG'
ORA-06550: line 123, column 9:
PL/SQL: Statement ignored"

Getting the following error when accepting the above E2B Reports from Reports > Pending E2b Screen:
   "XML ServiceRequest Failed. Error number: -2147417851\n"

 


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