采购订单在创建之后,无论单据状态是‘创建’、‘重新审核’都不能进行删除。报错如下:
发生时间: 2016-06-17 08:51:07
错误编号: BOS_ExecuteNonQuery
错误信息: ORA-01732: 此视图的数据操纵操作非法
Sql语句: DELETE FROM Wb_v_OrderTrack WHERE Wb_v_OrderTrack.FID IN (SELECT FId FROM ( select COLUMN_VALUE as FID from table(cast(:FID_udt as udt_inttable))) where FId=Wb_v_OrderTrack.FID)
===================================================
调用堆栈:
Server stack trace:
在 Kingdee.BOS.App.Data.AbstractDatabase.ExecuteNonQuery(DbCommand command, IEnumerable`1 listParam)
在 Kingdee.BOS.App.Data.DBUtils.Execute(Context ctx, String strSQL, IEnumerable`1 paramList, Boolean needTranslate)
在 Kingdee.BOS.App.Data.OLEDbDriver.KSqlTask.Execute(IDbConnection con, IDbTransaction tran)
在 Kingdee.BOS.Orm.Drivers.OrmTransactionBase.ExecuteSqlTasks(IList`1 tasks)
在 Kingdee.BOS.Orm.Drivers.OrmTransactionBase.Commit()
在 Kingdee.BOS.Orm.DataManager.DataManagerImplement.Delete(Object[] oids, IOrmTransaction ormTransaction, OperateOption option)
在 Kingdee.BOS.Orm.DataManager.DataManagerImplement.AutoBatchExecute(IEnumerable ids, OperateOption option, Func`2 func)
在 Kingdee.BOS.Orm.DataManager.DataManagerImplement.Delete(IEnumerable oids, IOrmTransaction ormTransaction, OperateOption option)
在 Kingdee.BOS.App.Core.Delete.DeleteDataEntitys(Object[] objID, DynamicObjectType dynamicObjectType)
在 Kingdee.BOS.App.Core.Delete.ExecuteOperatinTransaction(DynamicObject[] objs)
在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperation(DynamicObject[]& objs)
在 Kingdee.BOS.App.Core.AbstractOprerationService.CallOperatinTransaction(DynamicObject[] objs)
在 Kingdee.BOS.App.Core.AbstractOprerationService.DoExcete()
在 Kingdee.BOS.App.Core.AbstractOprerationService.Excute(Object[] ids)
在 Kingdee.BOS.App.Core.DeleteService.Delete(Context ctx, BusinessInfo info, Object[] Ids, OperateOption option, String operationNumber)
Exception rethrown at [0]:
在 System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
在 System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
在 Kingdee.BOS.Contracts.IDeleteService.Delete(Context ctx, BusinessInfo info, Object[] Ids, OperateOption option, String operationNumber)
在 Kingdee.BOS.ServiceHelper.BusinessDataServiceHelper.Delete(Context ctx, BusinessInfo businessInfo, Object[] Ids, OperateOption option, String operationNumber)
在 Kingdee.BOS.Business.Bill.Operation.Delete.BatDelete(Int32 loopTimes, Int32 iBat, String[] _idList, IOperationResult fullResult)
在 Kingdee.BOS.Business.Bill.Operation.Delete.DoListDelete(IOperationResult fullResult)
在 Kingdee.BOS.Business.Bill.Operation.Delete.ExecuteOperation()
在 Kingdee.BOS.Core.DynamicForm.AbstractDynamicFormOperation.Operation(CallBackWfAfterOperation callbackwf, IOperationResult resul
推荐阅读