My Oracle Support Banner

Case Listing Report Generation Error When Specific Patient History Fields Are Selected (Doc ID 2422693.1)

Last updated on SEPTEMBER 23, 2019

Applies to:

Oracle Argus Safety - Version 8.1.2 to 8.1.2 [Release 8.1]
Microsoft Windows x64 (64-bit)

Symptoms

Case Listing Report is not getting generated with Specific Patient History fields.


Steps to Repeat:
----------------
1. Navigate to Reports-->Aggregate Reports--> Case Listing
2. Create Case Listing Report and select the fields as following under "Selected Fields" -

Relevant History Age
Relevant History Age Unit
Relevant History Coding Status
Relevant History Condition
Relevant History Condition as reported
Relevant History Condition Code
Relevant History Condition HLGT
Relevant History Condition HLGT Code
Relevant History Condition HLT
Relevant History Condition HLT Code
Relevant History Condition LLT
Relevant History Condition LLT Code
Relevant History Condition SOC
Relevant History Condition SOC Code
Relevant History Condition synonym code
Relevant History Condition to be coded
Relevant History Condition Type
Relevant History Continues
Relevant History Dictionary
Relevant History Family History

(User has selected "Date Range" as "Last 30 days", however in customer support environment the issue is reproducible with "All Dates" range value).

3. Click Print to generate the report in PDF format.
4. Go to Background Report Generation status page to check Report generation status.

Issue: Report is not generated and "Error" is displayed. User is getting below error in logs while report generation -

Argus Safety.COM :- Oracle error 1 occurred.ORA-1858: a non-numeric character was found where a numeric was expected SQL: select case_master.case_id , CASE_PAT_HIST.AGE , LM_AGE_UNITS.age_unit , CODE_STATUS.status , CASE_PAT_HIST.condition , gss_util.gmt_date_of_any_timezone_char(CASE_PAT_HIST.item_reptd,-4.000000,'dd-MON-yyyy hh24:mi') , CASE_PAT_HIST.item_code , CASE_PAT_HIST.item_hlgt ,CASE_PAT_HIST.item_hlgt_code , CASE_PAT_HIST.item_hlt ,CASE_PAT_HIST.item_hlt_code , CASE_PAT_HIST.item_llt ,
CASE_PAT_HIST.item_llt_code , CASE_PAT_HIST.item_soc ,CASE_PAT_HIST.item_soc_code , CASE_PAT_HIST.item_syn_code ,CASE_PAT_HIST.item_coded , LM_CONDITION_TYPE.cond_type , CMN_LOOKUP.state3 ,CFG_DICTIONARIES.name , CMN_LOOKUP1.state2 , CASE_PAT_HIST.seq_num from
CASE_MASTER , CASE_PAT_HIST , LM_AGE_UNITS , CODE_STATUS , LM_CONDITION_TYPE, CMN_LOOKUP , CFG_DICTIONARIES , CMN_LOOKUP CMN_LOOKUP1 whereCASE_PAT_HIST.AGE_UNIT_ID=LM_AGE_UNITS.AGE_UNIT_ID (+) andCASE_PAT_HIST.item_code_status=CODE_STATUS.id (+) and
CASE_PAT_HIST.CONDITION_TYPE_ID=LM_CONDITION_TYPE.CONDITION_TYPE_ID (+) and CASE_PAT_HIST.continue=CMN_LOOKUP.id (+) and CASE_PAT_HIST.item_dict=CFG_DICTIONARIES.dict_id (+) and CASE_PAT_HIST.family_history=CMN_LOOKUP1.id (+) and 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_HIST.case_id order by CASE_MASTER.CASE_ID , CASE_PAT_HIST.seq_num PL/SQL Call Stack: 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


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