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

Last updated on JULY 18, 2024

Applies to:

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

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