I am trying to develop a report in obiee 22.214.171.124 using EBS R12.1.1 while developing i am getting following type of error.
I have EBS R12 & Obiee both on different machine on linux.
Could anyone please help me.
View Display Error
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 23006] The session variable, NQ_SESSION.ICX_SESSION_COOKIE, has no value definition. (HY000)
SQL Issued: SELECT 0 s_0, "RAHIL"."PO_PAYMENT"."PO_NUMBER" s_1, "RAHIL"."PO_PAYMENT"."TRANSACTION_DATE" s_2, "RAHIL"."PO_PAYMENT"."TRANSACTION_TYPE" s_3 FROM "RAHIL"
Its got nothing to do with the source (EBS), check your Initialization block, make sure the query is run properly there. If the Init block is good then you will get rid of this error without any issues.