기술 문서 - CS261186

Error "ORA-00933:SQL command not properly ended" while selecting all and approving best fit recommendations in Servigistics Parts Planning

수정한 날짜: 25-Apr-2017   


적용 대상

  • Servigistics Service Parts Management 11.0.1.4.1

설명

  • Error ORA-00933:SQL command not properly ended while selecting all and approving best fit recommendations
  • WebUI screen displays the error message as below
    • org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [delete from IPCS_BESTFIT_ACTION from IPCS_BESTFIT_ACTION, IPCS_LOC_TREE where IPCS_BESTFIT_ACTION.LocID=IPCS_LOC_TREE.ChildLocID and IPCS_LOC_TREE.LocID=7419]; nested exception is java.sql.SQLSyntaxErrorException: ORA-00933: SQL command not properly ended
이는 기술 문서 261186의 PDF 버전이며, 구 버전일 수 있습니다. 최신 버전 CS261186