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

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.

5. Report is not generated and "Error" is displayed.

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