My Oracle Support Banner

When We Make The Quantity Blank And Save The Cart Exception Occurs POR_TAX_PVT.calculate_tax(): SQLERRM= ORA-01400: cannot insert NULL (Doc ID 2322036.1)

Last updated on FEBRUARY 22, 2019

Applies to:

Oracle iProcurement - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.


Using Purchasing, Version 12.2.5

Making the quantity blank and saving the cart causes an error.

Quantity being blank should not throw an error.

Error Page
Exception Details.
 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-20000: Exception at POR_TAX_PVT.calculate_tax(): SQLERRM= ORA-01400: cannot insert NULL into ("ZX"."ZX_ITM_DISTRIBUTIONS_GT"."TRX_LINE_DIST_AMT") Error= Progress= 600
ORA-06512: at "APPS.POR_TAX_PVT", line 470
ORA-06512: at line 1

at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(
at oracle.apps.icx.por.common.webui.ClientUtil.invokeMethod(
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.invokeMethod(
at oracle.apps.icx.por.common.webui.PorBaseCOImpl.executeServerCommand(
at oracle.apps.icx.por.req.webui.CheckoutInfoBaseCO.pushNotes(
at oracle.apps.icx.por.req.webui.ReqNotesCO.processFormRequest(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(
at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processFormRequest(
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(

Replication Steps:
1. iProcurement - item is selected - leave quantity null.
2. Save and find that an exception occurs.


To view full details, sign in with your My Oracle Support account.

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

In this Document

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