费用报销单分录选择费用类型报错
EAS Cloud-财务
金蝶云社区-蓝飞鹏
蓝飞鹏
0人赞赏了该文章 966次浏览 未经作者许可，禁止转载编辑于2015年12月30日 10:50:30

[table]
[tr][td]EAS8.0费用报销单选择分录中的费用类型时报错，请大神们帮忙看一下，报错信息如下：

错误信息：select data error.ORA-00942: table or view does not exist
Caused exception message is: ORA-00942: table or view does not exist
错误详细堆栈信息：com.kingdee.bos.dao.ormapping.SQLAccessException: select data error.ORA-00942: table or view does not exist
Caused exception message is: ORA-00942: table or view does not exist
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:822)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.getCollection(ORMappingDAO.java:683)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetCollection(AbstractEntityControllerBean.java:580)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetCollection(AbstractEntityControllerBean.java:596)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean._getCollection(AbstractCoreBaseControllerBean.java:362)
at com.kingdee.eas.framework.app.AbstractObjectBaseControllerBean._getCollection(AbstractObjectBaseControllerBean.java:187)
at com.kingdee.eas.framework.app.AbstractDataBaseControllerBean._getCollection(AbstractDataBaseControllerBean.java:264)
at com.kingdee.eas.cp.bc.app.AbstractOperationTypeCostCenterEntryControllerBean._getCollection(AbstractOperationTypeCostCenterEntryControllerBean.java:488)
at com.kingdee.eas.cp.bc.app.AbstractOperationTypeCostCenterEntryControllerBean.getOperationTypeCostCenterEntryCollection(AbstractOperationTypeCostCenterEntryControllerBean.java:474)
at sun.reflect.GeneratedMethodAccessor1651.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy748.getOperationTypeCostCenterEntryCollection(Unknown Source)
at com.kingdee.eas.cp.bc.OperationTypeCostCenterEntry.getOperationTypeCostCenterEntryCollection(OperationTypeCostCenterEntry.java:293)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_cp_1_bc_1_IOperationTypeCostCenterEntry.pi59(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_cp_1_bc_1_IOperationTypeCostCenterEntry.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)
Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:879)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Unknown Source)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Unknown Source)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3652)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1207)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:307)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.execQuerySQL(EntityAccess.java:483)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.select(EntityAccess.java:365)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:241)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.select(ObjectReader.java:139)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:785)
... 26 more
Caused by: java.sql.SQLException
java.sql.SQLException: ORA-00942: table or view does not exist
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:447)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:951)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:513)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:227)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:208)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:879)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(Unknown Source)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(Unknown Source)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3608)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3652)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1207)
at com.kingdee.bos.sql.shell.KDPreparedStatement.executeQuery(KDPreparedStatement.java:307)
at com.apusic.jdbc.adapter.PreparedStatementHandle.executeQuery(Unknown Source)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.execQuerySQL(EntityAccess.java:483)
at com.kingdee.bos.dao.ormapping.impl.EntityAccess.select(EntityAccess.java:365)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.innerSelect(ObjectReader.java:241)
at com.kingdee.bos.dao.ormapping.impl.ObjectReader.select(ObjectReader.java:139)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.innerGetCollection(ORMappingDAO.java:785)
at com.kingdee.bos.dao.ormapping.ORMappingDAO.getCollection(ORMappingDAO.java:683)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetCollection(AbstractEntityControllerBean.java:580)
at com.kingdee.bos.framework.ejb.AbstractEntityControllerBean.innerGetCollection(AbstractEntityControllerBean.java:596)
at com.kingdee.eas.framework.app.AbstractCoreBaseControllerBean._getCollection(AbstractCoreBaseControllerBean.java:362)
at com.kingdee.eas.framework.app.AbstractObjectBaseControllerBean._getCollection(AbstractObjectBaseControllerBean.java:187)
at com.kingdee.eas.framework.app.AbstractDataBaseControllerBean._getCollection(AbstractDataBaseControllerBean.java:264)
at com.kingdee.eas.cp.bc.app.AbstractOperationTypeCostCenterEntryControllerBean._getCollection(AbstractOperationTypeCostCenterEntryControllerBean.java:488)
at com.kingdee.eas.cp.bc.app.AbstractOperationTypeCostCenterEntryControllerBean.getOperationTypeCostCenterEntryCollection(AbstractOperationTypeCostCenterEntryControllerBean.java:474)
at sun.reflect.GeneratedMethodAccessor1651.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:37)
at java.lang.reflect.Method.invoke(Method.java:611)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.invoke(TxInvokerBean.java:125)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean.INVOKE_SUPPORTS(TxInvokerBean.java:64)
at com.kingdee.bos.transaction.EJBTxFacade.TxInvokerBean_LocalObjectImpl_2.INVOKE_SUPPORTS(Unknown Source)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:179)
at com.kingdee.bos.transaction.EJBTransactionProxy.invoke(EJBTransactionProxy.java:324)
at com.sun.proxy.$Proxy748.getOperationTypeCostCenterEntryCollection(Unknown Source)
at com.kingdee.eas.cp.bc.OperationTypeCostCenterEntry.getOperationTypeCostCenterEntryCollection(OperationTypeCostCenterEntry.java:293)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_cp_1_bc_1_IOperationTypeCostCenterEntry.pi59(Unknown Source)
at rpc_generate._PROXY_com_1_kingdee_1_eas_1_cp_1_bc_1_IOperationTypeCostCenterEntry.processInvoke(Unknown Source)
at com.kingdee.bos.rpc.impl.ObjectProxy.processInvoke(ObjectProxy.java:177)
at com.kingdee.bos.rpc.impl.RPCService.serviceInvoke(RPCService.java:780)
at com.kingdee.bos.rpc.impl.RPCService.service(RPCService.java:139)
at com.kingdee.bos.rpc.impl.ServiceDispatcher.run(ServiceDispatcher.java:153)
at com.kingdee.bos.rpc.impl.ThreadJob.run(ThreadJob.java:27)
at com.kingdee.bos.rpc.impl.ThreadPool2$Worker.run(ThreadPool2.java:140)


[tr][td]
~BWJI9Z6FV87FIB8B~CES]K.png (101.47 KB, 下载次数: 0) 6 天前 上传下载次数: 0


推荐阅读

费用报销单选择费用类型时报错

EAS8.0费用报销单选择分录中的费用类型时报错，请大神们帮忙看一下，报错信息如下： 错误信息：select data error.ORA-00942: tab …

    文章

    1358

费用报销单分录行的费用类型选择不了

费用报销单分录行的费用类型选择不了，在费用类型处按F7，系统没反应，没弹出选择窗口，但WEB界面的可以，这是什么原因？ 你好，这种问题建议提单处理。

    文章

    706

费用报销单无法选择费用类型

费用报销单填制的时候业务类型选择了之后无法选择费用类型 兄弟你可能是没有在费用类型里面关联单据吧。 ,你好，请在费用管理-基础设置-费用类型里选中费用类型关联单 …

    文章

    1645