You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting error when running OTBI

edited Oct 7, 2025 5:21PM in Reporting and Analytics for HCM 2 comments

Summary:

Getting error when running OTBI analysis using Benefits - Person Information Real time

Content (please ensure you mask any confidential information):

Hi,

Getting below error when running an OTBI analysis. I reviewed the OTBI but not able to figure out the error. Please help with the error message.

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65PState: 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: 904, message: ORA-00904: "PERSONDETAILSPEO"."PERSON_ID": invalid identifier Help: https://docs.oracle.com/error-help/db/ora-00904/ at OCI call OCIStmtExecute. (HY000)State: HY000. Code: 17010. [nQSError: 17010] SQL statement preparation failed. (HY000)SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Benefits - Person Information Real Time"."Benefit Person"."Benefit Person Full Name" s_1, "Benefits - Person Information Real Time"."Benefits Survey Questionnaire Additional Attributes"."Questionnaire Last Update Date" s_2, "Benefits -

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!