My Oracle Support Banner

Get Unexpected Error When Clear Unit Price And Tab Out Of The Field On Edit Page Screen (Doc ID 1953126.1)

Last updated on FEBRUARY 24, 2019

Applies to:

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

Symptoms

On : 12.1.3 version, Requisition Creation

When attempting to Edit lines during creation of requisition
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 886
ORA-06512: at line 1

......,
....
...


## 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 886
ORA-06512: at line 1

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:439)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:395)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:802)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:436)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:186)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:521)
at oracle.jdbc.driver.T4CCallableStatement.doOall8(T4CCallableStatement.java:202)
at oracle.jdbc.driver.T4CCallableStatement.executeForRows(T4CCallableStatement.java:1005)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1307)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3449)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login into iProcurement
2. Create non-catalog requisition
3. Click on Edit lines
4. Remove the price and tab out get the below error

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
Cause
Solution
References


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