Edit Requisition ORA-20000: POR_TAX_PVT.calculate_tax(): ORA-01400: At ZX_TRANSACTION_LINES_GT (Doc ID 2035784.1)

Last updated on AUGUST 02, 2015

Applies to:

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

Symptoms

When editing a requisition via the 'Edit Requisition' link an error occurs.
Due to this issue, users cannot edit the requisition.




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_TRANSACTION_LINES_GT"."LINE_AMT") Error= Progress= 400
ORA-06512: at "APPS.POR_TAX_PVT", line 470
ORA-06512: at line 1



 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_TRANSACTION_LINES_GT"."LINE_AMT") Error= Progress= 400
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 weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
## Detail 0 ##
java.sql.SQLException: ORA-20000: Exception at
POR_TAX_PVT.calculate_tax(): SQLERRM= ORA-01400: cannot insert NULL into
 ("ZX"."ZX_TRANSACTION_LINES_GT"."LINE_AMT") Error= Progress= 400
ORA-06512: at "APPS.POR_TAX_PVT", line 470
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)




Steps To Reproduce
1.  Log in as a buyer and click on the Requisition which is to be approved under the work list, ie ‘Purchase Requisition 100979 for Doe, John (14,400.00 USD).
2.  Click on the ‘Edit Requisition’ link.
3.  Edit any value like quantity, price or description on the requisition and click on the Submit button.
4.  After doing so, reported error is raised.

 


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