Skip to main content

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

 

 

Be the first to reply!

Reply