Not Able To Perform E2B Validation For Any Case Using ICSR Check Icon In Argus 8.1.1
(Doc ID 2536730.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Interchange - Version 8.1.1 and laterInformation in this document applies to any platform.
Symptoms
On Applications Oracle Argus Safety Version : 8.1.1
Unable to perform E2B check for any case using ICSR Check icon.
Whenever users click on ICSR check icon, receive below error message (in ERROR_LOG table)
Below error is getting reflected in ERROR_LOG.
. :- ORA-00904: "LSP"."STUDY_KEY": invalid identifier
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 73
ORA-06512: at "ARGUS_APP.PKG_UTL_SQL", line 100
Bind Variables::AGENCY_ID = 109502:CASE_ID = 109502:ID = 109502:LICENSE_ID = 0:MODULE = 0:PROD_SEQ_NUM = 0:PROFILE = ICH-ICSR V2.1 MESSAGE TEMPLATE - CUSTOM
:REG_REPORT_ID = 0:RESULT = 0:STUDY_ID = 109502SQL:SELECT DECODE(lrt.e2b_code,2,DECODE(x.cnt,0,DECODE(lcc.e2b_code,1,0,1),DECODE(lcc.e2b_code,2,0,3,0,1)),0)
FAILURE FROM case_master cm,case_study cs,lm_case_classification lcc,lm_report_type lrt,(SELECT COUNT(1) cnt
FROM case_study cs,lm_study_products lsp,lm_lic_products llp,lm_license ll
WHERE cs.case_id = :case_id AND cs.study_key = lsp.study_key
AND lsp.product_id = llp.product_id AND llp.license_id = ll.license_id
AND ll.license_type_id IN (4,5,6)) x
WHERE cm.case_id = :case_id
AND cs.case_id = :case_id AND cs.classification_id = lcc.classification_id(+)
AND cm.rpt_type_id = lrt.rpt_type_id(+)PL/SQL Call Stack: SQL
673 PKG_CONSOLE_COMMON.P_ERROR_LOG
18 PKG_UTL_SQL.P_LOG_SQL_ERROR
106 PKG_UTL_SQL.F_OPEN_CURSOR
14195 ESM_PKG.P_E2B_CHECK
4774 ESM_UTL.P_E2B_CHECK1
__anonymous_block
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 |