Oracle Error in workbook

MarcLaf

Hi,

I have a Workbook with a Condition and a Calculation criteria:

Calculation: 

Condition:

Running Oracle BI Discoverer 11g...

When I execute the workbook, I get an Oracle Error:

If I take out the Condition from the workbook, Everything works fine, No error!!!

Can someone shed a bit of light on this?

Thanks in advance,

Marc L

Brajesh Shukla

You can use table with outer join only with one table. This is syntax issue while joining the tables, please correct it, then should work.

You can get the SQL from View SQL Inspector or DIscoverer Administrator. to find out which table exactly causing the issue