ORA-01422 Error Occurs When Supplier User Attempts To Create Quote Against RFQ (Doc ID 2085492.1)

Last updated on JUNE 29, 2017

Applies to:

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

Symptoms

In Oracle Sourcing, Release 12.1.3

When supplier user attempts to create a quote against an RFQ with Earnest Money Deposit (EMD) has been made twice (once with status Received and once as Not Paid),
the following error appears :

ERROR

You have encountered an unexpected error. Please contact the System Administrator for assistance.

Exception Details.

 oracle.apps.fnd.framework.OAException: java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PON_BID_DEFAULTING_PKG", line 2819
ORA-06512: at "APPS.PON_BID_DEFAULTING_PKG", line 4832
ORA-06512: at line 1
..
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.pon.response.creation.server.ResponseAMImpl.loadResponse(ResponseAMImpl.java:1535)
at oracle.apps.pon.response.creation.server.ResponseAMImpl.loadResponse(ResponseAMImpl.java:1285)
at oracle.apps.pon.response.creation.server.ResponseAMImpl.loadResponse(ResponseAMImpl.java:1191)
..
## Detail 0 ##
java.sql.SQLException: ORA-01422: exact fetch returns more than requested number of rows
ORA-06512: at "APPS.PON_BID_DEFAULTING_PKG", line 2819
ORA-06512: at "APPS.PON_BID_DEFAULTING_PKG", line 4832
ORA-06512: at line 1


STEPS TO REPRODUCE

The issue can be reproduced at will with the following steps:

As the internal Sourcing EMD Administrator:
1. Log in to Oracle Applications, using a Sourcing EMD Administration responsibility.
2. On the EMD Home Page, in the Published Negotiations region, see the desired RFQ number and click the "EMD Transactions" link/icon.
3. On the EMD Information page, in the "EMD Transactions for Suppliers" region, there are two lines showing for a particular supplier. One of the lines shows EMD Status = Received, and the other line shows EMD Status = Not Paid.
Now, as supplier user:
4. Log in to Oracle Applications, using a Sourcing Supplier responsibility.
5. On the Negotiations home page, in the Your Company's Open Invitations region, click on the link for the desired RFQ number.
6. On the RFQ details page, select Actions = Create Quote and click the Go button. The issue occurs at this point.
 


Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms