SAP Knowledge Base Article - Preview

2582643 - Issue Item Search with catalogue filter

Symptom

Item search does not occur if catalogue filter is on.

Error received:

Please report the following error to your system administrator:

java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207)
at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:884)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3584)

at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3628)
at oracle.jdbc.driver.T4CPreparedStatement.executeQuery(T4CPreparedStatement.java)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1493)
at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.ucp.jdbc.proxy.PreparedStatementProxyFactory.invoke(PreparedStatementProxyFactory.java:111)
at com.sun.proxy.$Proxy726.executeQuery(Unknown Source)
at com.plateau.common.db.api.AbstractPreparedStatementWrapper.executeQuery(AbstractPreparedStatementWrapper.java:66)
at com.plateau.common.db.oracle.impl.AbstractOraclePreparedStatementWrapper.executeQuery(AbstractOraclePreparedStatementWrapper.java)
at com.plateau.common.db.oracle.impl.PlateauOraclePreparedStatement.executeQuery(PlateauOraclePreparedStatement.java)
at sun.reflect.GeneratedMethodAccessor72.invoke(Unknown Source)


Read more...

Environment

  • SAP HCM suite
  • Learning Management System (LMS)
  • Learning Administration
  • Items
  • Search selectors

Keywords

SAP, SuccessFactors, learning, LMS, search, java.sql.SQLSyntaxErrorException: ORA-00918: column ambiguously defined, search selector , KBA , LOD-SF-LMS-ADM , System Admin, Global Variables, References , LOD-SF-LMS , Learning Management System , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.