Error When Clicking On View Cart And Checkout After Adding Non-Catalog Items

(Doc ID 2143690.1)

Last updated on DECEMBER 12, 2016

Applies to:

Oracle iProcurement - Version 12.2 and later
Information in this document applies to any platform.

Symptoms

In Oracle iProcurement, Release 12.2.5, when creating a non-catalog request, an error occurs when clicking the View Cart and Checkout button.
Due to this issue, users are unable to complete requests for non-catalog items in iProcurement.


Error

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.
Click here for exception details.


Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20000: Exception at POR_TAX_PVT.get_default_tax_attributes(): SQLERRM= ORA-01400: cannot insert NULL into ("ZX"."ZX_TRANSACTION_LINES_GT"."LINE_AMT") Error= Progress= 300
ORA-06512: at "APPS.POR_TAX_PVT", line 913
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:1050)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:257)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:175)
at oracle.apps.icx.por.req.webui.ShoppingCartPopupCO.executePrepareForDisplay(ShoppingCartPopupCO.java:582)
at oracle.apps.icx.por.req.webui.ShoppingCartPopupCO.processRequest(ShoppingCartPopupCO.java:353)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2883)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2060)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:582)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:470)
at _pages.__oa._jspService(__oa.java:233)
..
..
## Detail 0 ##
java.sql.SQLException: ORA-20000: Exception at POR_TAX_PVT.get_default_tax_attributes(): SQLERRM= ORA-01400: cannot insert NULL into ("ZX"."ZX_TRANSACTION_LINES_GT"."LINE_AMT") Error= Progress= 300
ORA-06512: at "APPS.POR_TAX_PVT", line 913
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:205)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:548)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:213)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1111)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1488)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3769)
at oracle.jdbc.driver.OraclePreparedStatement.execute(OraclePreparedStatement.java:3954)
at oracle.jdbc.driver.OracleCallableStatement.execute(OracleCallableStatement.java:9353)
at oracle.jdbc.driver.OraclePreparedStatementWrapper.execute(OraclePreparedStatementWrapper.java:1539)
at weblogic.jdbc.wrapper.PreparedStatement.execute(PreparedStatement.java:99)
at oracle.apps.icx.por.schema.server.TaxHelper.getDefaultTaxAttributes(TaxHelper.java:741)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.prepareReqSummaryVOForDisplay(CheckoutSummarySvrCmd.java:456)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.prepareForDisplay(CheckoutSummarySvrCmd.java:285)
at oracle.apps.icx.por.req.server.CheckoutSummarySvrCmd.executeMethodByName(CheckoutSummarySvrCmd.java:156)
at oracle.apps.icx.por.req.server.CheckoutInfoBaseSvrCmd.execute(CheckoutInfoBaseSvrCmd.java:159)
at oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122)
at sun.reflect.GeneratedMethodAccessor17496.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(ClientUtil.java:1050)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(PorBaseCOImpl.java:257)
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(PorBaseCOImpl.java:175)
at oracle.apps.icx.por.req.webui.ShoppingCartPopupCO.executePrepareForDisplay(ShoppingCartPopupCO.java:582)
at oracle.apps.icx.por.req.webui.ShoppingCartPopupCO.processRequest(ShoppingCartPopupCO.java:353)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:1003)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:970)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:690)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:283)
at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2883)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:2060)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:582)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:470)
at _pages.__oa._jspService(__oa.java:233)
..
..



Steps To Reproduce

The issue can be reproduced at will with the following steps:
1. Log in to Oracle Applications, using an iProcurement responsibility.
2. Click the Shop tab.
3. Click the Non-Catalog Request subtab.
4. On the Non-Catalog Request page, add some items to the shopping cart.
5. Click the View Cart and Checkout button. The error occurs at this point.



Changes

 

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