oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Approval_status FROM APPS.HXC_TIMECARD_SUMMARY WHERE RESOURCE_ID like NVL(:1,RESOURCE_ID) and start_time = NVL(:2,start_time) and stop_time =NVL(:3,stop_time)

Oracle Community | Sukanya C U | 2 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    Error in OAF page: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation

    Oracle Community | 2 years ago | Sukanya C U
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Approval_status FROM APPS.HXC_TIMECARD_SUMMARY WHERE RESOURCE_ID like NVL(:1,RESOURCE_ID) and start_time = NVL(:2,start_time) and stop_time =NVL(:3,stop_time)
  2. 0

    Mukul's Oracle Technology Blog: Implementing Export Button Functionality Programatically

    blogspot.com | 1 year ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.RowNotFoundException: JBO-25060: Unexpected error encountered while trying to retrieve the next row from JDBC ResultSet for collection OAExportHelper_SecondRowSet
  3. 0

    OAF开发时报的ERROR - ERP二次开发-ITPUB论坛-it168旗下专业技术社区

    itpub.net | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/ak/employee/server/webui /EmpSearchPG;  (Could not lookup message because there is no database connection)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    OAF¿ª·¢Ê±±¨µÄERROR_Oracle¼¼Êõ

    zwcoom.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_NO_REGION_DATA. Tokens: REGIONCODE = /oracle/apps/ak/employee/server/webui /EmpSearchPG;(Could not lookup message because there is no connection)
  6. 0

    OA Framework

    apps2fusion.com | 1 year ago
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND-INVALID APPLICATION. Tokens: APPL = search; (Could not lookup message because there is no database connection)

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. oracle.apps.fnd.framework.OAException

      oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Approval_status FROM APPS.HXC_TIMECARD_SUMMARY WHERE RESOURCE_ID like NVL(:1,RESOURCE_ID) and start_time = NVL(:2,start_time) and stop_time =NVL(:3,stop_time)

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2704)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1707)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:511)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:432)
      7 frames
    3. Unknown
      _OA._jspService
      1. _OA._jspService(OA.jsp:33)
      1 frame
    4. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:56)
      1 frame
    5. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:317)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:465)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:379)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      1 frame
    7. com.evermind.server
      HttpRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:727)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:306)
      3. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:767)
      4. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:259)
      5. com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:106)
      5 frames
    8. Dough Lea's util.concurrent package
      PooledExecutor$Worker.run
      1. EDU.oswego.cs.dl.util.concurrent.PooledExecutor$Worker.run(PooledExecutor.java:803)
      1 frame
    9. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:534)
      1 frame