Non-Catalog Request Checkout In Exception At POR_TAX_PVT.Get_Default_Tax_Attributes() (Doc ID 2192842.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version,


When attempting to create Non Catalog request and checkout
the following error occurs.

ERROR
-----------------------
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:733)
  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:579)
  at oracle.apps.icx.por.req.webui.ShoppingCartPopupCO.processRequest(ShoppingCartPopupCO.java:350)

## 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:156)
  at oracle.apps.icx.por.common.server.PorBaseAMImpl.executeServerCommand(PorBaseAMImpl.java:122)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. iProcurement -> Home Page
2. Non catalog request -> Enter Details
3. Checkout -> Error occurs

This is happening to only one user.

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