Re: JBO-27122: SQL error during statement preparation.

Posted by ErmanArslansOracleBlog on
URL: http://erman-arslan-s-oracle-forum.114.s1.nabble.com/JBO-27122-SQL-error-during-statement-preparation-tp1288p1289.html

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,

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

---

If you reply to this email, your message will be added to the discussion below:

http://erman-arslan-s-oracle-forum.2340467.n4.nabble.com/JBO-27122-SQL-error-during-statement-preparation-tp1288.html

To start a new topic under EBS 12.1/12.0, email [hidden email]
To unsubscribe from Erman Arslan's Oracle Forum, click here.
NAML

--