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 OCTOBER 27, 2017

Applies to:

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

Symptoms

Using Purchasing, Version 12.2.5


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

Expected:
Quantity being blank should not throw an error.

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(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.CheckoutInfoBaseCO.pushNotes(CheckoutInfoBaseCO.java:2127)
at oracle.apps.icx.por.req.webui.ReqNotesCO.processFormRequest(ReqNotesCO.java:114)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:854)
at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:423)
at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processFormRequest(OAHeaderBean.java:410)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1066)



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




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