Error When Clicking On View Cart And Checkout After Adding Non-Catalog Items (Doc ID 2143690.1)

Last updated on SEPTEMBER 23, 2024

Applies to:

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.

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.