My Oracle Support Banner

Error: ORA-20002: 3103 When Attempting To Cancel RFQ (Doc ID 2566992.1)

Last updated on JULY 23, 2019

Applies to:

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

Symptoms


When attempting to cancel RFQ, the following error occurs.

ERROR

You have encountered an unexpected error.

Exception Details:

java.sql.SQLException: ORA-20002: 3103: Attribute 'AUCTION_ID' does not exist for item 'PONAUCT/60721-653126'.
ORA-06512: at "APPS.WF_CORE", line 316
ORA-06512: at "APPS.WF_ENGINE", line 1749
ORA-06512: at "APPS.PON_AUCTION_PKG", line 5590
ORA-06512: at "APPS.PON_NEG_UPDATE_PKG", line 129
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.pon.negotiation.update.server.CancelNegAMImpl.cancel(CancelNegAMImpl.java:84)
at oracle.apps.pon.negotiation.update.server.CancelNegAMImpl.cancel(CancelNegAMImpl.java:59)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
..

STEPS

1.Navigate to Sourcing Super User Responsibility -> Sourcing Home Page -> Negotiations
2.Search by RFQ Number
3.Click on RFQ Number link from Search Results
4.Select 'Cancel RFQ' from Actions dropdown
5.Click on Apply from Cancel RFQ page
6.The following error occurs:

You have encountered an unexpected error.

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


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