oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT * FROM (SELECT lookup_code lookup_code, meaning description FROM fnd_lookup_values_vl WHERE lookup_type = 'HOME_OFFICE' AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(:1) = 'N' UNION SELECT TO_CHAR(vendor_site_id) lookup_code, vendor_site_code description FROM ap_supplier_sites WHERE SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1) AND NVL(pay_site_flag,'N')='Y' and vendor_id is not null AND vendor_id = (SELECT paaf.vendor_id FROM per_all_assignments_f paaf WHERE paaf.person_id = :2 AND paaf.primary_flag = 'Y' AND trunc(fnd_date.canonical_to_date((:3))) BETWEEN trunc(paaf.effective_start_date ) AND trunc(paaf.effective_end_date ) AND paaf.vendor_id IS NOT NULL )) QRSLT ORDER BY description

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1658

  • via Unknown by dbad4b8b-e757-4b8c-a3d5-bf6416532f7b,
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: Error SQL durante la preparación de la sentencia. Sentencia: SELECT * FROM (SELECT lookup_code lookup_code, meaning description FROM fnd_lookup_values_vl WHERE lookup_type = 'HOME_OFFICE' AND AP_WEB_DB_HR_INT_PKG.isPersonCwk(:1) = 'N' UNION SELECT TO_CHAR(vendor_site_id) lookup_code, vendor_site_code description FROM ap_supplier_sites WHERE SYSDATE < NVL(INACTIVE_DATE, SYSDATE + 1) AND NVL(pay_site_flag,'N')='Y' and vendor_id is not null AND vendor_id = (SELECT paaf.vendor_id FROM per_all_assignments_f paaf WHERE paaf.person_id = :2 AND paaf.primary_flag = 'Y' AND trunc(fnd_date.canonical_to_date((:3))) BETWEEN trunc(paaf.effective_start_date ) AND trunc(paaf.effective_end_date ) AND paaf.vendor_id IS NOT NULL )) QRSLT ORDER BY description at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source) at _OA._jspService(_OA.java:71) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:259) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:51) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:193) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:198) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:392) at _OA._jspService(_OA.java:80) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:462) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:713) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:370) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:871) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:453) at com.evermind.server.http.HttpRequestHandler.serveOneRequest(HttpRequestHandler.java:221) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:122) at com.evermind.server.http.HttpRequestHandler.run(HttpRequestHandler.java:111) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:239) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:34) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:880) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:595)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    14 more bugmates