JBO-27122 Error While Performing RFQ Award Summary Action (Doc ID 2161037.1)

Last updated on MAY 13, 2024

Applies to:

Symptoms

On : 12.2.4 version, Awards

When attempting to award a negotiation, performing the action 'Award Summary'
shows the following error.


ERROR
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select BidHeadersEO.BID_NUMBER
, BidHeadersEO.AUCTION_HEADER_ID
, BidHeadersEO.TRADING_PARTNER_NAME
, BidHeadersEO.TRADING_PARTNER_ID
, BidHeadersEO.TRADING_PARTNER_CONTACT_ID
, BidHeadersEO.EMAIL
, 'N' AS HIDE_SHOW
, (SELECT sum(bl.price * nvl(bl.quantity, 1))
  FROM pon_bid_item_prices bl, pon_auction_item_prices_all ai
  WHERE bl.bid_number = BidHeadersEO.bid_number and ai.auction_header_id = bl.auction_header_id and ai.line_number = bl.line_number and ai.group_type in ('LINE', 'LOT', 'GROUP_LINE')
  ) as QUOTE_TOTAL
, BidHeadersEO.total_award_amount as AWARD_TOTAL
, BidHeadersEO.INTERNAL_NOTE
.
.
.
## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row.
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)
.
.


STEPS
The issue can be reproduced at will with the following steps:
1. Navigate to Sourcing responsibility.
2. Create a 2 stage RFQ.
3. Create Award.
4. Perform action 'Award Summary'.
5. Error is shown.

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.