oracle.apps.bne.exception.BneInvalidException: Program Error: Unable to create sql for table validation type, the column does not have a validation type of: TABLE!, Column Name; P_EMPLOYEE_NUMBER

Oracle Community | User639232-Oracle | 2 years ago
tip
Click on the to mark the solution that helps you, Samebug will learn from it.
As a community member, you’ll be rewarded for you help.
  1. 0

    WebADI upload of the transaction control import errors

    Oracle Community | 2 years ago | User639232-Oracle
    oracle.apps.bne.exception.BneInvalidException: Program Error: Unable to create sql for table validation type, the column does not have a validation type of: TABLE!, Column Name; P_EMPLOYEE_NUMBER

    Root Cause Analysis

    1. oracle.apps.bne.exception.BneInvalidException

      Program Error: Unable to create sql for table validation type, the column does not have a validation type of: TABLE!, Column Name; P_EMPLOYEE_NUMBER

      at oracle.apps.bne.repository.BneInterfaceCol.buildTableValidationQuery()
    2. oracle.apps.bne
      BneBaseServlet.doPost
      1. oracle.apps.bne.repository.BneInterfaceCol.buildTableValidationQuery(BneInterfaceCol.java:688)
      2. oracle.apps.bne.repository.BneInterfaceCol.getTableLovQuery(BneInterfaceCol.java:578)
      3. oracle.apps.bne.repository.BneInterface.getTableLovQuery(BneInterface.java:771)
      4. oracle.apps.bne.repository.BneIntegrator.getTableLovQuery(BneIntegrator.java:927)
      5. oracle.apps.bne.integrator.component.BneOAValueSetComponent.handleListOfValues(BneOAValueSetComponent.java:151)
      6. oracle.apps.bne.integrator.component.BneAbstractListOfValues.handleComponent(BneAbstractListOfValues.java:579)
      7. oracle.apps.bne.integrator.component.BneComponentService.executeComponent(BneComponentService.java:425)
      8. oracle.apps.bne.integrator.component.BneComponentService.handleRequest(BneComponentService.java:264)
      9. oracle.apps.bne.framework.BneBajaServlet.doRequest(BneBajaServlet.java:262)
      10. oracle.apps.bne.framework.BneBaseServlet.doPost(BneBaseServlet.java:95)
      10 frames
    3. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:521)
      2. javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
      2 frames
    4. org.apache.jserv
      JServConnection.run
      1. org.apache.jserv.JServConnection.processRequest(JServConnection.java:456)
      2. org.apache.jserv.JServConnection.run(JServConnection.java:294)
      2 frames
    5. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame