I am trying to develop a report in obiee 220.127.116.11 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"
Thanks & Regards,
Check to make sure that you have followed this: http://docs.oracle.com/cd/E21043_01/bi.1111/e16364/ebs_actions.htm or Doc ID 1343143.1 from MOS.
Let us know if you have followed the steps and are still seeing the error.
Please assign points if helpful/correct.
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.