Local Affiliate Incoming Review Screen Is Not Showing Any Local Events (Doc ID 1539516.1)

Last updated on OCTOBER 14, 2013

Applies to:

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

Symptoms

Incoming local events are not appearing in incoming review screen when selected ALL button and search.

 

It is returning one of the following errors in the cmn_error_log table;

Error 1:

Argus Safety.COM :- Oracle error 8194 occurred.
Error fetching data, ORA-01036: illegal variable name/number

SQL: SELECT LG.lam_id, LG.local_ref_num, LG.receipt_date, GSS_UTIL.f_group(lg.group_id) group_name, GSS_UTIL.f_country(lg.country_id) country, GSS_UTIL.f_lp_initials(lg.lam_id) initials, LG.central_case_id, GSS_UTIL.f_case_num(lg.central_case_id) case_num,  GSS_UTIL.f_trade_name(lg.lam_id) trade_name, GSS_UTIL.f_evt_description(lg.lam_id) description, GSS_UTIL.f_site(lg.lam_id) site_desc, GSS_UTIL.f_followup_count(lg.lam_id) followup_count  FROM LAM_GENERAL LG  WHERE central_incom = 1  Order By  Upper( local_ref_num ) asc


Error 2:

P_ERROR_TEXT set to Oracle error 8194 occurred.
Error fetching data, ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "ARGUS_APP.GSS_UTIL", line 1824

SQL: SELECT LG.lam_id, LG.local_ref_num, LG.receipt_date, GSS_UTIL.f_group(lg.group_id) group_name, GSS_UTIL.f_country(lg.country_id) country, GSS_UTIL.f_lp_initials(lg.lam_id) initials, LG.central_case_id, GSS_UTIL.f_case_num(lg.central_case_id) case_num, GSS_UTIL.f_trade_name(lg.lam_id) trade_name, GSS_UTIL.f_evt_description(lg.lam_id) description, GSS_UTIL.f_site(lg.lam_id) site_desc, GSS_UTIL.f_followup_count(lg.lam_id) followup_count FROM LAM_GENERAL LG WHERE central_incom = 1 Order By Upper( local_ref_num ) asc

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