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

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

The Exception Details section.


 
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)