Edit Requisition ORA-20000: POR_TAX_PVT.calculate_tax(): ORA-01400: At ZX_TRANSACTION_LINES_GT
(Doc ID 2035784.1)
Last updated on MARCH 15, 2022
Applies to:
Oracle iProcurement - Version 12.2.4 and laterInformation 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
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)
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 <USER NAME> (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.
Changes
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |