HR中薪金计算选择员工出现莫名错误

marco

在薪金计算中选择组织时出错，检查了N多遍也没搞明白为什么。
错误代码如下：
编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT HR_SA_EMPScheme.*, HR_SA_Scheme.fSchemeTypeName AS fSchemeTypeName , HR_SA_Scheme.fName AS fSchemeName , HR_EP_Employee.fSex AS fSex , HR_EP_Employee.fIDCard AS fIDCard , HR_EP_Employee.fCode AS fCode , HR_EP_Employee.fEmpStatus AS fEmpStatus, HR_EP_Employee.fEmpStatusName AS fEmpStatusName FROM HR_SA_EMPScheme HR_SA_EMPScheme join HR_SA_Scheme HR_SA_Scheme on HR_SA_EMPScheme.fSchemeID=HR_SA_Scheme OPTIONAL JOIN HR_EP_Employee HR_EP_Employee on HR_SA_EMPScheme.fEmployeeID=HR_EP_Employee WHERE (HR_EP_Employee.fName is not null) AND (((HR_SA_EMPScheme.fEndDate is null or HR_SA_EMPScheme.fEndDate>=stringToDate('2015-03-01')) and (HR_SA_EMPScheme.fBeginDate is null or HR_SA_EMPScheme.fBeginDate<= stringToDate('2015-04-30'))) AND (HR_SA_Scheme.fSchemeTypeID='salary_schemetype_zs' and HR_SA_EMPScheme.fState<>'0') AND ( fFID like '%929BAAE5CF3C43468E8D0512616D2636%')) LIMIT 0, 20
编码: JUSTEP150039; 提示: 执行sql: (SELECT HR_SA_EMPScheme.VERSION AS version, HR_SA_EMPScheme.FEMPLOYEEID AS fEmployeeID, HR_SA_EMPScheme.FEMPLOYEENAME AS fEmployeeName, HR_SA_EMPScheme.FORGANID AS fOrganID, HR_SA_EMPScheme.FORGANNAME AS fOrganName, HR_SA_EMPScheme.FDEPTID AS fDeptID, HR_SA_EMPScheme.FDEPTNAME AS fDeptName, HR_SA_EMPScheme.FPOSITIONID AS fPositionID, HR_SA_EMPScheme.FPOSITIONNAME AS fPositionName, HR_SA_EMPScheme.FFID AS fFID, HR_SA_EMPScheme.FFNAME AS fFName, HR_SA_EMPScheme.FSCHEMETYPEID AS fSchemeTypeID, HR_SA_EMPScheme.FSCHEMEID AS fSchemeID, HR_SA_EMPScheme.FCASHSCALE AS fCashScale, HR_SA_EMPScheme.FCHECKSCALE AS fCheckScale, HR_SA_EMPScheme.FBANKSCALE AS fBankScale, HR_SA_EMPScheme.FBEGINDATE AS fBeginDate, HR_SA_EMPScheme.FENDDATE AS fEndDate, HR_SA_EMPScheme.FCHANGEREASON AS fChangeReason, HR_SA_EMPScheme.FOLDEMPSCHEMEID AS fOldEmpSchemeID, HR_SA_EMPScheme.FSTATE AS fState, HR_SA_EMPScheme.FSTATENAME AS fStateName, HR_SA_EMPScheme.FCREATEPERID AS fCreatePerID, HR_SA_EMPScheme.FCREATEPERNAME AS fCreatePerName, HR_SA_EMPScheme.FCREATETIME AS fCreateTime, HR_SA_EMPScheme.FINVALIDPERID AS fInValidPerID, HR_SA_EMPScheme.FINVALIDPERNAME AS fInValidPerName, HR_SA_EMPScheme.FINVALIDTIME AS fInValidTime, HR_SA_EMPScheme.FINVALIDREASON AS fInValidReason, HR_SA_EMPScheme.FFINISHPERID AS fFinishPerID, HR_SA_EMPScheme.FFINISHPERNAME AS fFinishPerName, HR_SA_EMPScheme.FFINISHTIME AS fFinishTime, HR_SA_EMPScheme.FFINISHREASON AS fFinishReason, HR_SA_Scheme.FSCHEMETYPENAME AS fSchemeTypeName, HR_SA_Scheme.FNAME AS fSchemeName, HR_EP_Employee.FSEX AS fSex, HR_EP_Employee.FIDCARD AS fIDCard, HR_EP_Employee.FCODE AS fCode, HR_EP_Employee.FEMPSTATUS AS fEmpStatus, HR_EP_Employee.FEMPSTATUSNAME AS fEmpStatusName, HR_SA_EMPScheme.fID AS HR_SA_EMPScheme FROM HR_SA_EMPSCHEME HR_SA_EMPScheme JOIN HR_SA_SCHEME HR_SA_Scheme ON HR_SA_EMPScheme.FSCHEMEID = HR_SA_Scheme.fID LEFT JOIN HR_EP_EMPLOYEE HR_EP_Employee ON HR_SA_EMPScheme.FEMPLOYEEID = HR_EP_Employee.fID WHERE (HR_EP_Employee.FNAME IS NOT NULL) AND ( ( ( (HR_SA_EMPScheme.FENDDATE IS NULL) OR (HR_SA_EMPScheme.FENDDATE >= to_date(?, 'yyyy-mm-dd')) ) AND ( (HR_SA_EMPScheme.FBEGINDATE IS NULL) OR (HR_SA_EMPScheme.FBEGINDATE <= to_date(?, 'yyyy-mm-dd')) ) ) AND ( (HR_SA_Scheme.FSCHEMETYPEID = ?) AND (HR_SA_EMPScheme.FSTATE <> ?) ) AND (fFID LIKE ?) ) ), binds: [2015-03-01, 2015-04-30, salary_schemetype_zs, 0, %929BAAE5CF3C43468E8D0512616D2636%]出错
ORA-00918: 未明确定义列

marco

java.lang.reflect.InvocationTargetException
at sun.reflect.GeneratedMethodAccessor156.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:592)
at com.justep.system.action.Engine.invokeActions(Native Method)
at com.justep.system.action.Engine.invokeActions(Unknown Source)
at com.justep.business.server.BusinessServer.doAction(Unknown Source)
at com.justep.business.server.BusinessServer.doExcute(Unknown Source)
at com.justep.business.server.BusinessServer.excute(Unknown Source)
at com.justep.business.server.BusinessServerServlet.execService(Unknown Source)
at com.justep.business.server.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at com.justep.x.bs.BusinessServerServlet.service(Unknown Source)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:861)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:606)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
at java.lang.Thread.run(Thread.java:595)
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150210; 提示: 执行KSQL出错, KSQL: SELECT HR_SA_EMPScheme.*, HR_SA_Scheme.fSchemeTypeName AS fSchemeTypeName , HR_SA_Scheme.fName AS fSchemeName , HR_EP_Employee.fSex AS fSex , HR_EP_Employee.fIDCard AS fIDCard , HR_EP_Employee.fCode AS fCode , HR_EP_Employee.fEmpStatus AS fEmpStatus, HR_EP_Employee.fEmpStatusName AS fEmpStatusName FROM HR_SA_EMPScheme HR_SA_EMPScheme join HR_SA_Scheme HR_SA_Scheme on HR_SA_EMPScheme.fSchemeID=HR_SA_Scheme OPTIONAL JOIN HR_EP_Employee HR_EP_Employee on HR_SA_EMPScheme.fEmployeeID=HR_EP_Employee WHERE (HR_EP_Employee.fName is not null) AND (((HR_SA_EMPScheme.fEndDate is null or HR_SA_EMPScheme.fEndDate>=stringToDate('2015-03-01')) and (HR_SA_EMPScheme.fBeginDate is null or HR_SA_EMPScheme.fBeginDate<= stringToDate('2015-04-30'))) AND (HR_SA_Scheme.fSchemeTypeID='salary_schemetype_zs' and HR_SA_EMPScheme.fState<>'0') AND ( fFID like '%929BAAE5CF3C43468E8D0512616D2636%')) LIMIT 0, 20
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.impl.TableUtilsImplement.ksqlSelect(Unknown Source)
at com.justep.system.data.BizData.query(Unknown Source)
at BizProcedure.query(BizProcedure.java:12)
... 25 more
Caused by: com.justep.exception.BusinessException: 编码: JUSTEP150039; 提示: 执行sql: (SELECT HR_SA_EMPScheme.VERSION AS version, HR_SA_EMPScheme.FEMPLOYEEID AS fEmployeeID, HR_SA_EMPScheme.FEMPLOYEENAME AS fEmployeeName, HR_SA_EMPScheme.FORGANID AS fOrganID, HR_SA_EMPScheme.FORGANNAME AS fOrganName, HR_SA_EMPScheme.FDEPTID AS fDeptID, HR_SA_EMPScheme.FDEPTNAME AS fDeptName, HR_SA_EMPScheme.FPOSITIONID AS fPositionID, HR_SA_EMPScheme.FPOSITIONNAME AS fPositionName, HR_SA_EMPScheme.FFID AS fFID, HR_SA_EMPScheme.FFNAME AS fFName, HR_SA_EMPScheme.FSCHEMETYPEID AS fSchemeTypeID, HR_SA_EMPScheme.FSCHEMEID AS fSchemeID, HR_SA_EMPScheme.FCASHSCALE AS fCashScale, HR_SA_EMPScheme.FCHECKSCALE AS fCheckScale, HR_SA_EMPScheme.FBANKSCALE AS fBankScale, HR_SA_EMPScheme.FBEGINDATE AS fBeginDate, HR_SA_EMPScheme.FENDDATE AS fEndDate, HR_SA_EMPScheme.FCHANGEREASON AS fChangeReason, HR_SA_EMPScheme.FOLDEMPSCHEMEID AS fOldEmpSchemeID, HR_SA_EMPScheme.FSTATE AS fState, HR_SA_EMPScheme.FSTATENAME AS fStateName, HR_SA_EMPScheme.FCREATEPERID AS fCreatePerID, HR_SA_EMPScheme.FCREATEPERNAME AS fCreatePerName, HR_SA_EMPScheme.FCREATETIME AS fCreateTime, HR_SA_EMPScheme.FINVALIDPERID AS fInValidPerID, HR_SA_EMPScheme.FINVALIDPERNAME AS fInValidPerName, HR_SA_EMPScheme.FINVALIDTIME AS fInValidTime, HR_SA_EMPScheme.FINVALIDREASON AS fInValidReason, HR_SA_EMPScheme.FFINISHPERID AS fFinishPerID, HR_SA_EMPScheme.FFINISHPERNAME AS fFinishPerName, HR_SA_EMPScheme.FFINISHTIME AS fFinishTime, HR_SA_EMPScheme.FFINISHREASON AS fFinishReason, HR_SA_Scheme.FSCHEMETYPENAME AS fSchemeTypeName, HR_SA_Scheme.FNAME AS fSchemeName, HR_EP_Employee.FSEX AS fSex, HR_EP_Employee.FIDCARD AS fIDCard, HR_EP_Employee.FCODE AS fCode, HR_EP_Employee.FEMPSTATUS AS fEmpStatus, HR_EP_Employee.FEMPSTATUSNAME AS fEmpStatusName, HR_SA_EMPScheme.fID AS HR_SA_EMPScheme FROM HR_SA_EMPSCHEME HR_SA_EMPScheme JOIN HR_SA_SCHEME HR_SA_Scheme ON HR_SA_EMPScheme.FSCHEMEID = HR_SA_Scheme.fID LEFT JOIN HR_EP_EMPLOYEE HR_EP_Employee ON HR_SA_EMPScheme.FEMPLOYEEID = HR_EP_Employee.fID WHERE (HR_EP_Employee.FNAME IS NOT NULL) AND ( ( ( (HR_SA_EMPScheme.FENDDATE IS NULL) OR (HR_SA_EMPScheme.FENDDATE >= to_date(?, 'yyyy-mm-dd')) ) AND ( (HR_SA_EMPScheme.FBEGINDATE IS NULL) OR (HR_SA_EMPScheme.FBEGINDATE <= to_date(?, 'yyyy-mm-dd')) ) ) AND ( (HR_SA_Scheme.FSCHEMETYPEID = ?) AND (HR_SA_EMPScheme.FSTATE <> ?) ) AND (fFID LIKE ?) ) ), binds: [2015-03-01, 2015-04-30, salary_schemetype_zs, 0, %929BAAE5CF3C43468E8D0512616D2636%]出错
at com.justep.exception.BusinessException.create(Unknown Source)
at com.justep.system.ksql.KSQLUtils.execSqlSelect(Unknown Source)
... 30 more
Caused by: java.sql.SQLException: ORA-00918: 未明确定义列

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:213)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:796)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1031)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:836)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1124)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3329)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
at org.apache.tomcat.dbcp.dbcp.DelegatingPreparedStatement.executeQuery(DelegatingPreparedStatement.java:96)
... 31 more

url:/UI/system/service/common/bizAction.j
param:=stringToDate('2015-03-01')) and (HR_SA_EMPScheme.fBeginDate is null or HR_SA_EMPScheme.fBeginDate<= stringToDate('2015-04-30'))) AND (HR_SA_Scheme.fSchemeTypeID='salary_schemetype_zs' and HR_SA_EMPScheme.fState<>'0') AND ( fFID like '%929BAAE5CF3C43468E8D0512616D2636%')]]>020
at (http://192.168.1.160:8080/x5/$v2653/base/base.js?language=zh_CN:1)69

marco

我debug 时分析是下面函数中
function refreshEmpScheme(){//刷新数据
//         debugger;
         var checked = justep.xbl('cdSelected');
         var schemes = checked.getValue("shemeId").split(" ");
         var dScheme =  justep.xbl('dEmpScheme');
         var orgId = checked.getValue("orgId");

         if(orgId){                                                                       
                 dScheme.setFilter("orgFilter"," fFID like '%" + orgId + "%'");
         }
出问题，但搞不明白是什么问题，觉得没有错。

marco

盼回复

marco

没有回复啊。
已解决

Shinchan

请问你的人力资源用的是下载的吗？数据库用什么？oracle？