My Oracle Support Banner

Fusion Global HR: OTBI OSHA 300A Analysis Report - ORA-01722: invalid number at OCI call OCIStmtFetch (Doc ID 2738960.1)

Last updated on DECEMBER 29, 2020

Applies to:

Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.10.0 and later
Information in this document applies to any platform.

Symptoms

OTBI OSHA 300A Analysis Results in Error

When running the OSHA 300A analysis report, an error occurs:


ERROR
-----------------------

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1722, message: ORA-01722: invalid number at OCI call OCIStmtFetch. (HY000)
State: HY000. Code: 17012. [nQSError: 17012] Bulk fetch failed. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';
SELECT 0 s_0, "Environment Health and Safety - Incidents Real Time"."Incident Details"."Establishment Name" s_1,
DESCRIPTOR_IDOF("Environment Health and Safety - Incidents Real Time"."Incident Details"."Establishment Name") s_2,
count(Case when "Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Date and Time of Fatality" is not null then 'X' END) s_3,
Count(Case when "Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Date and Time of Fatality" is null then Case when "Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Estimated Lost Time" >24 then 'X' END END) s_4,
count(Case when "Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Date and Time of Fatality" is null then Case when ifnull("Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Estimated Lost Time",0)count(Case when "Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Date and Time of Fatality" is null then Case when ifnull("Environment Health and Safety - Incidents Real Time"."Injury or Illness"."Estimated Lost Time",0)

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.