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

Logical SQL Error - OTBI

Accepted answer
edited Aug 22, 2019 4:18PM in Reporting and Analytics for ERP 1 comment


When attempting to create a new Analysis using simple Logical SQL


I am attempting to create a new analysis using the logical SQL below; however, whenever I submit the following error occurs. I have reviewed the PPT deck from Oracle, but something must still be incorrect in the formatting? This issue appears when using Firefox, Chrome or Opera. Any ideas or suggestions appreciated. 

select a."General Information"."Invoice ID", b."Invoice"."Invoice ID" 
    ((select "General Information"."Invoice ID" from "Payables Invoices - Transactions Real Time") a
    inner join
    (select "Invoice"."Invoice ID" from "Procurement - Procure To Pay Real Time") b

Howdy, Stranger!

Log In

To view full details, sign in.


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