ERROR_1 error appears when exporting the case listing with relevant test(J)
(Doc ID 2007940.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences 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.
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
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |