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

(Doc ID 2007940.1)

Last updated on SEPTEMBER 21, 2015

Applies to:

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

Symptoms

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




Steps:
---------------------
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

 

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