Hello everyone,I wrote a Quickreport. The quickreport works correctly. I created a scheduled report about this report. I set all parameters. Report was activated. IFS cloud can not sen email. sql code is
select order_no,
release_no,
line_no,
part_no,
a.buy_qty_due,
Receipt_Info_API.Get_Sum_Qty_Arrived_By_Source(ORDER_NO,
LINE_NO,
RELEASE_NO,
Null,
'PURCHASE_ORDER') received_quantity
from PURCHASE_ORDER_LINE a
where a.buy_qty_due >
Receipt_Info_API.Get_Sum_Qty_Arrived_By_Source(ORDER_NO,
LINE_NO,
RELEASE_NO,
Null,
'PURCHASE_ORDER')
and objstate = 'Received'
and contract = 'PP'
Error message is below:
sql code is
QUICK_REPORT_TEMPLATE_RPI.Execute_Report] rapor yönteminde hata Oracle Error 06502: PL/SQL: sayısal veya değer hatası: invalid LOB locator specified: Oracle Error 22275] ORA-20105: Report.REPRUNERR

