My Oracle Support Banner

Error When Try To Delete Draft Negotiation (Doc ID 1458469.1)

Last updated on MARCH 10, 2019

Applies to:

Oracle Sourcing - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

While trying to delete Draft Negotiation users get an error.    Due to this issue, users cannot delete unwanted draft


 
Error

Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT LOOKUP_CODE, MEANING
FROM FND_LOOKUP_VALUES
WHERE LOOKUP_TYPE = :1
AND LANGUAGE = USERENV('LANG')
AND VIEW_APPLICATION_ID = 0
AND SECURITY_GROUP_ID = 0
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3117)
...
...
## Detail 0 ##
java.sql.SQLException: Missing IN or OUT parameter at index:: 1
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:146)
at oracle.jdbc.driver.OraclePreparedStatement.processCompletedBindRow(OraclePreparedStatement.java:1719)
at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3334)
at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:3384)




Steps To Reproduce

1. Log in and access Sourcing.
2. Create an RFQ.
3. Save it as a draft.
4. Go to manage draft and try to delete it

 

Changes

<Patch 8663791> applied; users were able to delete RFQ before this patch.

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


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