Please find the product team comments: The issue is inclause ( {stritemid*}) parameter causing issue, so suggested to Ashok kumar try this parameter as :stritemid, this is working fine.
Issue Query: SELECT rn, sno, itemcode, itemname,stocklocation, stocksublocation,batch,silo,stockqty, pono,requiredqty, stockallocated, company,itemid,locationid,sublocationid FROM table(FIFO_PACKMATERAIL ( :companyid , :issue_date, ({stritemid*}) , ({strpono*}) )) PM Order By rn,sno,itemcode,stocklocation,stocksublocation,batch,silo Changed query: SELECT rn, sno, itemcode, itemname,stocklocation, stocksublocation,batch,silo,stockqty, pono,requiredqty, stockallocated, company,itemid,locationid,sublocationid FROM table(FIFO_PACKMATERAIL ( :companyid , :issue_date, :stritemid , :strpono ) ) PM Order By rn,sno,itemcode,stocklocation,stocksublocation,batch,silo