Unable To Reject Lam Events (Doc ID 1325239.1)

Last updated on MAY 25, 2011

Applies to:

Oracle Argus Affiliate - Version: 4.2.1.1B and later   [Release: and later ]
Information in this document applies to any platform.

Symptoms

Getting the following error when trying to reject a LAM event from incoming review screen:

"Reject Local Event:
Can not reject local event due to the following reason:

Error Occurred. Please contact System Administrator"

Observed the following error in the cmn_error_log:

INSERT INTO cmn_error_log(error_id, error_date, error_msg_id, error_text, osuser, program, machine, treminal, oracle_user#, user_id) VALUES(S_CMN_ERROR__ERROR_ID.NEXTVAL, SYSDATE, 8197, 'Oracle error 8197 occurred.
SQL execution error, ORA-00917: missing comma

SQL: INSERT into LAM_ACTION_ITEM (id, lam_id, action_date, code, description) VALUES (184, 11473, sysdate, 5, ''Initial Local Event Rejection Reason: Case rejected as  to kept as ''LAM use only'''')', 'IUSR_NCORP-ARGUS-05', 'Argusvr2.exe', 'ARGUS-05', 'ARGUS-05', 0, gss_wnds.get_user_id)

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