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 5:21PM in Reporting and Analytics for HCM

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!