Skip to Main Content
Forums

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg;Oracle Error code: 907, message: ORA-00907: missing right parenthesis a

910254Jan 17 2012 — edited Jan 19 2012
Hi,

i am facing the below error in dashbord..
Kindly assit me

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: 17001] Oracle Error code: 907, message: ORA-00907: missing right parenthesis at OCI call OCIStmtExecute. [nQSError: 17010] SQL statement preparation failed. (HY000)
SQL Issued: SELECT 0 s_0, "Procurement and Spend - Purchase Orders"."Fact"."Agreement Leakage Rate" s_1, "Procurement and Spend - Purchase Orders"."Fact"."Non-Agreement Purchase Rate" s_2, "Procurement and Spend - Purchase Orders"."Fact"."PO Amount" s_3, "Procurement and Spend - Purchase Orders"."Fact"."PO Input Ratio" s_4, "Procurement and Spend - Purchase Orders"."Fact"."Rejected Amount" s_5 FROM "Procurement and Spend - Purchase Orders" WHERE ((Time."Year" = '2009'))
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 16 2012
Added on Jan 17 2012
#business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee
18 comments
11,915 views