The assigned cases disappear after sorting the cases in the "Workflow State" on Personal Argus Status screen
(Doc ID 2498089.1)
Last updated on JULY 13, 2023
Applies to:
Oracle Life Sciences Argus Safety Japan - Version 8.1.2 and laterInformation in this document applies to any platform.
Symptoms
The assigned cases disappear when Argus-J user sorted the assigned cases in the "Workflow state" column on the Personal Argus Status screen.
---------------------------------------------
Steps
---------------------------------------------
1. Log-in to Argus with Argus-J user account
2. Go to Dashboard > Personal Argus Status
3. Confirm that the assigned cases are displayed
4. Click the "Workflow state" column header in order to sort by "Workflow state"
5. The assigned cases that was listed at step3 disappeared. No assigned case displays.
---------------------------------------------
Note
---------------------------------------------
1. This issue does not occur when non Argus-J user sorted the assigned case in the "Workflow State".
2. The following error appears in utilities > View Error log
Application : Argusvr2.exe
Error Text :
Argus Safety.COM :- Oracle error 8197 occurred.
SQL execution error, ORA-00904: "STATE_NAME_J": invalid identifier
SQL: SELECT case_id, wl_type, owner_id, a2, case_num, report_type,report_type_j, state_name, NVL (product_name,product_name_j) product_name,
NVL(product_name_j, product_name) product_name_j, NVL (desc_coded, NVL (desc_reptd, desc_reptd_j)) desc_coded,
NVL (desc_reptd_j, NVL (desc_coded, desc_reptd)) desc_coded_j
FROM case_worklist cw, lm_report_type lrt, lm_countries lc, cfg_workflow_states cws
WHERE cw.worklist_owner_id = :P_USER_ID AND cw.rpt_type_id = lrt.rpt_type_id AND cw.country_id = lc.country_id
AND cw.state_id = cws.state_id AND ROWNUM < 501 order by Upper(state_name_J) asc, UPPER(case_num)
PL/SQL Call Statck: SQL673 PKG_CONSOLE_COMMON.P_ERROR_LOG1 __anonymous_block
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 |