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

Last updated on JULY 13, 2023

Applies to:

Symptoms

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

It returns 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

Changes

Cause

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