My Oracle Support Banner

ERROR_1 error appears when exporting the case listing with relevant test(J) (Doc ID 2007940.1)

Last updated on APRIL 22, 2021

Applies to:

Oracle Argus Safety Japan - Version 7.0.1 to 8.0.1 [Release 7.0.0 to 8.0]
Information in this document applies to any platform.


When exporting the case listing with the relevant test(J) field, the error "ERROR_1" appears.

1. Go to reports > aggregate reports > Case listing
2. Navigate to Patient > Relevant Tests and then select the "Patient Tests Relevant Tests Taken By Patient(J)"
3. Press the [export] button

error_1 displayed


Error Log:
In the cmn_error_log (Utilities > logs > view error log), the following error is displayed.

Argus Safety.COM :- Oracle error 8197 occurred.SQL execution error,
ORA-00904: "CASE_PAT_TESTS"."CASE_ID": invalid identifierSQL:

select  case_master.case_id , CASE_PAT_TESTS.rel_tests_j  from CASE_MASTER , CASE_PAT_TESTS
where  case_master.case_id in (select case_id from user_case where user_id = gss_wnds.get_user_id())
and CASE_MASTER.case_id = CASE_PAT_TESTS.case_id  order by case_master.case_id





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

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