JBO-27122: SQL error during statement preparation.
Locked
 
|
Hello,
one AP user is having an Exception error. I have checked the alert log file. No error. The application log file contains some warnings. Please check the error in the log below: 16/09/09 11:16:07.204 10.1.3.5.0 Started 16/09/09 11:16:38.805 html: 10.1.3.5.0 Started 16/09/09 11:41:04.810 html: oracle.apps.fnd.security.LeakDetectionFilter.initialized:1473403264810 16/09/09 11:41:04.810 html: LeakSetting: global:true,session:false,aggressive:false,stderr:false,appslog:false,corelog:false ignoring:null 16/09/12 09:28:51.806 html: Servlet error java.lang.NullPointerException at _OAErrorPage._jspService(_OAErrorPage.java:356) at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:734) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageThrowable(EvermindPageContext.java:871) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindPageContext.handlePageException(EvermindPageContext.java:816) at _OA._jspService(_OA.java:256) at com.orionserver[Oracle Containers for J2EE 10g (10.1.3.5.0) ].http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at oracle.oc4j.network.ServerSocketAcceptHandler.procClientSocket(ServerSocketAcceptHandler.java:234) at oracle.oc4j.network.ServerSocketAcceptHandler.access$700(ServerSocketAcceptHandler.java:29) at oracle.oc4j.network.ServerSocketAcceptHandler$AcceptHandlerHorse.run(ServerSocketAcceptHandler.java:879) at com.evermind[Oracle Containers for J2EE 10g (10.1.3.5.0) ].util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:735) Exception Details. oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT HeaderSum_urEO.AMOUNT, HeaderSum_urEO.BANK_ACCOUNT_ID, HeaderSum_urEO.BANK_ACCOUNT_NAME, HeaderSum_urEO.CHECK_DATE, HeaderSum_urEO.CHECK_ID, HeaderSum_urEO.CHECK_NUMBER, HeaderSum_urEO.CURRENCY_CODE, HeaderSum_urEO.LAST_UPDATED_BY, HeaderSum_urEO.LAST_UPDATE_DATE, HeaderSum_urEO.PAYMENT_METHOD_LOOKUP_CODE, HeaderSum_urEO.PAYMENT_TYPE_FLAG, HeaderSum_urEO.ADDRESS_LINE1, HeaderSum_urEO.ADDRESS_LINE2, HeaderSum_urEO.ADDRESS_LINE3, HeaderSum_urEO.CHECKRUN_NAME, HeaderSum_urEO.CHECK_FORMAT_ID, HeaderSum_urEO.CHECK_STOCK_ID, HeaderSum_urEO.CITY, HeaderSum_urEO.COUNTRY, HeaderSum_urEO.CREATED_BY, HeaderSum_urEO.CREATION_DATE, HeaderSum_urEO.LAST_UPDATE_LOGIN, HeaderSum_urEO.STATUS_LOOKUP_CODE, HeaderSum_urEO.VENDOR_NAME, HeaderSum_urEO.VENDOR_SITE_CODE, HeaderSum_urEO.ZIP, HeaderSum_urEO.BANK_ACCOUNT_NUM, HeaderSum_urEO.BANK_ACCOUNT_TYPE, HeaderSum_urEO.BANK_NUM, HeaderSum_urEO.CHECK_VOUCHER_NUM, HeaderSum_urEO.CLEARED_AMOUNT, HeaderSum_urEO.CLEARED_DATE, HeaderSum_urEO.DOC_CATEGORY_CODE, HeaderSum_urEO.DOC_SEQUENCE_ID, HeaderSum_urEO.DOC_SEQUENCE_VALUE, HeaderSum_urEO.PROVINCE, HeaderSum_urEO.RELEASED_AT, HeaderSum_urEO.RELEASED_BY, HeaderSum_urEO.STATE, HeaderSum_urEO.STOPPED_AT, HeaderSum_urEO.STOPPED_BY, HeaderSum_urEO.VOID_DATE, HeaderSum_urEO.ATTRIBUTE1, HeaderSum_urEO.ATTRIBUTE10, HeaderSum_urEO.ATTRIBUTE11, HeaderSum_urEO.ATTRIBUTE12, HeaderSum_urEO.ATTRIBUTE13, HeaderSum_urEO.ATTRIBUTE14, HeaderSum_urEO.ATTRIBUTE15, HeaderSum_urEO.ATTRIBUTE2, HeaderSum_urEO.ATTRIBUTE3, HeaderSum_urEO.ATTRIBUTE4, HeaderSum_urEO.ATTRIBUTE5, HeaderSum_urEO.ATTRIBUTE6, HeaderSum_urEO.ATTRIBUTE7, HeaderSum_urEO.ATTRIBUTE8, HeaderSum_urEO.ATTRIBUTE9, HeaderSum_urEO.ATTRIBUTE_CATEGORY, HeaderSum_urEO.FUTURE_PAY_DUE_DATE, HeaderSum_urEO.TREASURY_PAY_DATE, HeaderSum_urEO.TREASURY_PAY_NUMBER, HeaderSum_urEO.USSGL_TRANSACTION_CODE, HeaderSum_urEO.USSGL_TRX_CODE_CONTEXT, HeaderSum_urEO.WITHHOLDING_STATUS_LOOKUP_CODE, HeaderSum_urEO.RECONCILIATION_BATCH_ID, HeaderSum_urEO.CLEARED_BASE_AMOUNT, HeaderSum_urEO.CLEARED_EXCHANGE_RATE, HeaderSum_urEO.CLEARED_EXCHANGE_DATE, HeaderSum_urEO.CLEARED_EXCHANGE_RATE_TYPE, HeaderSum_urEO.ADDRESS_LINE4, HeaderSum_urEO.COUNTY, HeaderSum_urEO.ADDRESS_STYLE, HeaderSum_urEO.ORG_ID, HeaderSum_urEO.VENDOR_ID, HeaderSum_urEO.VENDOR_SITE_ID, HeaderSum_urEO.EXCHANGE_RATE, HeaderSum_urEO.EXCHANGE_DATE, HeaderSum_urEO.EXCHANGE_RATE_TYPE, HeaderSum_urEO.BASE_AMOUNT, HeaderSum_urEO.CHECKRUN_ID, HeaderSum_urEO.REQUEST_ID, HeaderSum_urEO.CLEARED_ERROR_AMOUNT, HeaderSum_urEO.CLEARED_CHARGES_AMOUNT, HeaderSum_urEO.CLEARED_ERROR_BASE_AMOUNT, HeaderSum_urEO.CLEARED_CHARGES_BASE_AMOUNT, HeaderSum_urEO.POSITIVE_PAY_STATUS_CODE, HeaderSum_urEO.GLOBAL_ATTRIBUTE_CATEGORY, HeaderSum_urEO.GLOBAL_ATTRIBUTE1, HeaderSum_urEO.GLOBAL_ATTRIBUTE2, HeaderSum_urEO.GLOBAL_ATTRIBUTE3, HeaderSum_urEO.GLOBAL_ATTRIBUTE4, HeaderSum_urEO.GLOBAL_ATTRIBUTE5, HeaderSum_urEO.GLOBAL_ATTRIBUTE6, HeaderSum_urEO.GLOBAL_ATTRIBUTE7, HeaderSum_urEO.GLOBAL_ATTRIBUTE8, HeaderSum_urEO.GLOBAL_ATTRIBUTE9, HeaderSum_urEO.GLOBAL_ATTRIBUTE10, HeaderSum_urEO.GLOBAL_ATTRIBUTE11, HeaderSum_urEO.GLOBAL_ATTRIBUTE12, HeaderSum_urEO.GLOBAL_ATTRIBUTE13, HeaderSum_urEO.GLOBAL_ATTRIBUTE14, HeaderSum_urEO.GLOBAL_ATTRIBUTE15, HeaderSum_urEO.GLOBAL_ATTRIBUTE16, HeaderSum_urEO.GLOBAL_ATTRIBUTE17, HeaderSum_urEO.GLOBAL_ATTRIBUTE18, HeaderSum_urEO.GLOBAL_ATTRIBUTE19, HeaderSum_urEO.GLOBAL_ATTRIBUTE20, HeaderSum_urEO.TRANSFER_PRIORITY, HeaderSum_urEO.EXTERNAL_BANK_ACCOUNT_ID, HeaderSum_urEO.STAMP_DUTY_AMT, HeaderSum_urEO.STAMP_DUTY_BASE_AMT, HeaderSum_urEO.MRC_CLEARED_BASE_AMOUNT, HeaderSum_urEO.MRC_CLEARED_EXCHANGE_RATE, HeaderSum_urEO.MRC_CLEARED_EXCHANGE_DATE, HeaderSum_urEO.MRC_CLEARED_EXCHANGE_RATE_TYPE, HeaderSum_urEO.MRC_EXCHANGE_RATE, HeaderSum_urEO.MRC_EXCHANGE_DATE, HeaderSum_urEO.MRC_EXCHANGE_RATE_TYPE, HeaderSum_urEO.MRC_BASE_AMOUNT, HeaderSum_urEO.MRC_CLEARED_ERROR_BASE_AMOUNT, HeaderSum_urEO.MRC_CLEARED_CHARGES_BASE_AMT, HeaderSum_urEO.MRC_STAMP_DUTY_BASE_AMT, HeaderSum_urEO.MATURITY_EXCHANGE_DATE, HeaderSum_urEO.MATURITY_EXCHANGE_RATE_TYPE, HeaderSum_urEO.MATURITY_EXCHANGE_RATE, HeaderSum_urEO.DESCRIPTION, HeaderSum_urEO.ACTUAL_VALUE_DATE, HeaderSum_urEO.ANTICIPATED_VALUE_DATE, HeaderSum_urEO.RELEASED_DATE, HeaderSum_urEO.STOPPED_DATE, HeaderSum_urEO.MRC_MATURITY_EXG_DATE, HeaderSum_urEO.MRC_MATURITY_EXG_RATE, HeaderSum_urEO.MRC_MATURITY_EXG_RATE_TYPE, HeaderSum_urEO.IBAN_NUMBER, HeaderSum_urEO.CE_BANK_ACCT_USE_ID, HeaderSum_urEO.PAYMENT_METHOD_CODE, HeaderSum_urEO.PARTY_ID, HeaderSum_urEO.PARTY_SITE_ID, HeaderSum_urEO.PAYMENT_PROFILE_ID, HeaderSum_urEO.SETTLEMENT_PRIORITY, HeaderSum_urEO.BANK_CHARGE_BEARER, HeaderSum_urEO.LEGAL_ENTITY_ID, HeaderSum_urEO.PAYMENT_DOCUMENT_ID, HeaderSum_urEO.COMPLETED_PMTS_GROUP_ID, HeaderSum_urEO.PAYMENT_ID, HeaderSum_urEO.PAYMENT_INSTRUCTION_ID, HeaderSum_urEO.VOID_CHECK_NUMBER, HeaderSum_urEO.VOID_CHECK_ID, HeaderSum_urEO.REMIT_TO_SUPPLIER_NAME, HeaderSum_urEO.REMIT_TO_SUPPLIER_ID, HeaderSum_urEO.REMIT_TO_SUPPLIER_SITE, HeaderSum_urEO.REMIT_TO_SUPPLIER_SITE_ID, HeaderSum_urEO.RELATIONSHIP_ID, HeaderSum_urEO.PAYCARD_AUTHORIZATION_NUMBER, HeaderSum_urEO.PAYCARD_REFERENCE_ID, HeaderSum_urEO.ACKNOWLEDGED_FLAG, apps.mt_online_process_java.get_tr_reject_amt(HeaderSum_urEO.BANK_ACCOUNT_NAME, HeaderSum_urEO.CHECK_DATE,HeaderSum_urEO.Attribute5,HeaderSum_urEO.CURRENCY_CODE) Reject_amt ,apps.mt_online_process_java.get_tr_approve_line(HeaderSum_urEO.BANK_ACCOUNT_NAME, HeaderSum_urEO.CHECK_DATE, HeaderSum_urEO.Attribute5,HeaderSum_urEO.CURRENCY_CODE) Approve_line ,apps.mt_online_process_java.get_tr_reject_line(HeaderSum_urEO.BANK_ACCOUNT_NAME, HeaderSum_urEO.CHECK_DATE, HeaderSum_urEO.Attribute5,HeaderSum_urEO.CURRENCY_CODE) Reject_line ,apps.mt_online_process_java.get_line_status(HeaderSum_urEO.BANK_ACCOUNT_NAME, HeaderSum_urEO.CHECK_DATE, HeaderSum_urEO.Attribute5,HeaderSum_urEO.CURRENCY_CODE) Line_status, apps.mt_online_process_java.get_tr_approve_amt(HeaderSum_urEO.BANK_ACCOUNT_NAME, HeaderSum_urEO.CHECK_DATE, HeaderSum_urEO.Attribute5,HeaderSum_urEO.CURRENCY_CODE) Approve_amt FROM XXMT_OP_AP_CHECKS_ALL_UR_SUM HeaderSum_urEO WHERE nvl(HeaderSum_urEO.ATTRIBUTE4, '0') != '1' Order by HeaderSum_urEO.CHECK_DATE DESC at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:616) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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:734) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _RF._jspService(_RF.java:225) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:735) ## Detail 0 ## java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_TR_APPROVE_AMT' at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439) at oracle.apps.sqlap.OP_Payment_Approve.webui.HeaderSum_urCO.processRequest(HeaderSum_urCO.java:50) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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:734) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _RF._jspService(_RF.java:225) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:735) java.sql.SQLException: ORA-06553: PLS-306: wrong number or types of arguments in call to 'GET_TR_APPROVE_AMT' at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:205) at oracle.jdbc.driver.T4CPreparedStatement.executeForDescribe(T4CPreparedStatement.java:861) at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1145) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1267) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449) at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3493) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeQuery(OraclePreparedStatementWrapper.java:1491) at oracle.jbo.server.QueryCollection.buildResultSet(QueryCollection.java:860) at oracle.jbo.server.QueryCollection.executeQuery(QueryCollection.java:669) at oracle.jbo.server.ViewObjectImpl.executeQueryForCollection(ViewObjectImpl.java:3723) at oracle.jbo.server.OAJboViewObjectImpl.executeQueryForCollection(Unknown Source) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQueryForCollection(OAViewObjectImpl.java:4560) at oracle.jbo.server.ViewRowSetImpl.execute(ViewRowSetImpl.java:743) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMasters(ViewRowSetImpl.java:892) at oracle.jbo.server.ViewRowSetImpl.executeQueryForMode(ViewRowSetImpl.java:806) at oracle.jbo.server.ViewRowSetImpl.executeQuery(ViewRowSetImpl.java:800) at oracle.jbo.server.ViewObjectImpl.executeQuery(ViewObjectImpl.java:3643) at oracle.apps.fnd.framework.server.OAViewObjectImpl.executeQuery(OAViewObjectImpl.java:439) at oracle.apps.sqlap.OP_Payment_Approve.webui.HeaderSum_urCO.processRequest(HeaderSum_urCO.java:50) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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:734) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:280) at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:68) at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:214) at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:284) at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:219) at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java:395) at _RF._jspService(_RF.java:225) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:473) 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.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:735) I have compiled invalid objects but some still remain. SQL> select owner,object_type,count(*) from dba_objects where status='INVALID' group by owner,object_type; OWNER OBJECT_TYPE COUNT(*) ------------------------------ ------------------- ---------- APPS VIEW 1 MARIECLO SYNONYM 6 APPS PACKAGE BODY 18 SHANNONMU SYNONYM 6 XXMT PROCEDURE 2 APPS PROCEDURE 1 Thanks, Roshan |
Re: JBO-27122: SQL error during statement preparation.
Administrator
|
What is the error that the Ap user is getting? Please attach a screenshot of the error. Also, are you sure that these log lines produced when the user got the error? plesae check the dates of the log lines and ensure. alternatively, you can make the Ap user reproduce the error while you are tailing (tail -f) the error log to be ensure about it. 2016-09-12 9:37 GMT+03:00 Roshan [via Erman Arslan's Oracle Forum] <[hidden email]>: Hello, |