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
  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 | 12 months 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 | 8 months 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 | 8 months 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 | 8 months 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