My Oracle Support Banner

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 DECEMBER 03, 2019

Applies to:

Oracle Argus Interchange - Version 8.1.1 and later
Information 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


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