ORA-24333 - Zero Iteration Count [message #362957] |
Thu, 04 December 2008 12:09 |
Shashitham Talla
Messages: 1 Registered: December 2008 Location: Chicago USA
|
Junior Member |
|
|
Dear all
Error@ ORA-24333 - Zero Iteration Count !!!!!
Here is the program,..for my report,
Strangely I am able to run the query Successfully for my report in SQL developer and report builder and I can even give a bind parameters using both , but the requirement for this report is I should ether run this report in discoverer or xml
For that I have successfully created a report in report builder and when I create a Concurrent Program and Run It,… I get an error
ORA-24333 - Zero Iteration Count
=> with Tender As ( Select F1.Store_code as Store_Code, ……
any suggestion is greatly appreciated ….
Thanks in Advance
Cheers
With Tenders As ( Select F1.Store_code AS Store_code,
F2.Tender_type_code AS Tender_type_code,
Sum(F2.Payment_amount) As Trans_amount,
Count(F2.trx_id) as Trans_count
From ors_transactions F1
Join ors_transaction_payments F2
On F1.trx_id = F2.trx_id
Where Trunc(F1.Transaction_date) Between '01-Aug-2008' And '02-Aug-2008'
Group BY F1.Store_code, F2.Tender_type_code )
select vsd.flex_value as store_code,
vsd.description as store_name,
'Tender_Amount' As Code1,
a1.CASH as Cash,
a2.Visa as Visa
from xxrei.vw_store_details vsd ,
(Select Store_code as store_code,
sum(Trans_amount) as CASH
From Tenders
Where Tender_type_Code IN ('CASH','CHECK','Other Checks')
group by Store_code )a1,
(Select Store_code as store_code,
Trans_amount as Visa
From Tenders
Where Tender_type_Code = 'Visa/MC' )a2
where vsd.flex_value = a1.Store_code (+)
and vsd.flex_value = a2.Store_code (+)
order by vsd.flex_value ;
|
|
|
|
|