Error on Shopping Cart and checkout pages after applying Payments patches: ORA-01722: invalid number (Doc ID 1331031.1)

Last updated on SEPTEMBER 21, 2015

Applies to:

Oracle iStore - Version 12.0.6 and later
Information in this document applies to any platform.
ibyextt.odf
ibyfcpv.odf


Symptoms

Release 12.0.6
After recent patching which including Oracle Payments patch  (ie 11811748:R12.IBY.A), 'Application Error' error message are returned for adding an item to the iStore shopping cart or choosing the Checkout button when payment method is credit card number.


ERROR
---------
Application Error

The application is currently not available or an unexpected error has occurred. Please try again later.<br>
If this message persists, please contact the system administrator.



Errorstack Details -

For the Add To Cart (Shopping Cart page)

- 13:3:23:522 [ibeCZzdError.jsp] Message: Timestamp format must be yyyy-mm-dd
hh:mm:ss.fffffffff
13:3:23:522 [ibeCZzdError.jsp] Stack:

java.lang.IllegalArgumentException: Timestamp format must be yyyy-mm-dd
hh:mm:ss.fffffffff
at java.sql.Timestamp.valueOf(Timestamp.java:161)
at oracle.jdbc.driver.CharCommonAccessor.getTimestamp(CharCommonAccessor.java:462)
at oracle.jdbc.driver.OracleResultSetImpl.getTimestamp(OracleResultSetImpl.java:796)
at oracle.apps.ibe.shoppingcart.quote.Quote.loadHeaderPayment(Quote.java:9746)
at oracle.apps.ibe.shoppingcart.quote.ShoppingCart.load(ShoppingCart.java:11874)
at _ibeCCkdCHdrShipBillPay._jspService(_ibeCCkdCHdrShipBillPay.java:1810)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:702)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:359)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_forward(ServletRequestDispatcher.java:252)
at com.evermind.server.http.ServletRequestDispatcher.access$100(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$2.oc4jRun(ServletRequestDispatcher.java:186)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.forward(ServletRequestDispatcher.java:191)
at com.evermind.server.http.EvermindPageContext.forward(EvermindPageContext.java: 322)
at _ibeCCkdHdrShip._jspService(_ibeCCkdHdrShip.java:1275)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
at oracle.apps.ibe.util.IBEReleaseResFilter.doFilter(IBEReleaseResFilter.java:43)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:17)
at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:610)
at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:359)
at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:870)
at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:451)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:299)
at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:187)
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:595)



Checkout: Shipping and Billing (B2C) Errors:

CCPayment.loadCreditCards(RequestCtx.getAccountId(), RequestCtx.getPartyId(),RequestCtx.getOrgId(), orderTotal);

java.sql.SQLException: ORA-01722: invalid numberMessage: ORA-01722: invalid number

Stack:

java.sql.SQLException: ORA-01722: invalid number

at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:745)
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:966)
at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1062)
at oracle.jdbc.driver.T4CPreparedStatement.executeMaybeDescribe(T4CPreparedStatement.java:850)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1134)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3339)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)
at oracle.apps.ibe.customer.CCPayment.loadCreditCards(CCPayment.java:359)
at _ibeCPmdPmtOptions._jspService(_ibeCPmdPmtOptions.java:585)
at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:335)
at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:478)
at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:401)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:702)
at com.evermind.server.http.ServletRequestDispatcher.unprivileged_include(ServletRequestDispatcher.java:153)
at com.evermind.server.http.ServletRequestDispatcher.access$000(ServletRequestDispatcher.java:42)
at com.evermind.server.http.ServletRequestDispatcher$1.oc4jRun(ServletRequestDispatcher.java:90)
at oracle.oc4j.security.OC4JSecurity.doPrivileged(OC4JSecurity.java:283)
at com.evermind.server.http.ServletRequestDispatcher.include(ServletRequestDispatcher.java:95)
at com.evermind.server.http.EvermindPageContext.include(EvermindPageContext.java:383)
at _ibeCCkdCHdrBillPay._jspService(_ibeCCkdCHdrBillPay.java:1059)

Changes

Recent IBY patches which included changes to the views IBY_TRXN_EXTENSIONS_V and IBY_FNDCPT_PAYER_ASSGN_INSTR_V

File versions -
$Header: ibyextv.odf 120.0.12000000.2 2009/10/14 13:58:19 lmallick noship $

$Header: ibyfcpv.odf 120.38.12000000.23 2010/02/03 16:47:29 lmallick ship $

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms