My Oracle Support Banner

"JBO-27122: SQL error during statement preparation" and "ORA-01417: a table may be outer joined to at most one other table" Error When Searching a RFQ by Description (Doc ID 2499525.1)

Last updated on DECEMBER 03, 2019

Applies to:

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


On : 12.2.6 version, Auction/RFx creation

When attempting to search a RFQ by Line Description, the following error occurs:

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select distinct ah.auction_header_id auction_auction_header_id,
ah.auction_title auction_title,
fl1.meaning auction_type,
PON_AUCTION_PKG.TIME_REMAINING(ah.auction_header_id) timeleft,
to_char(nvl(decode(nvl(ah.two_part_flag, 'N' ), 'N' ,nvl(ah.number_of_bids, 0),'Y',
  SELECT count(pbd.bid_number)
  FROM pon_bid_headers pbd,pon_auction_headers_all paha
  WHERE pbd.auction_header_id=ah.auction_header_id
  AND pbd.auction_header_id = paha.auction_header_id
  AND nvl2(pbd.submit_stage,decode(paha.technical_evaluation_status, null, 'TECHNICAL','NOT_COMPLETED','TECHNICAL','COMPLETED',decode(paha.sealed_auction_status,'LOCKED','TECHNICAL','COMMERCIAL')),'-9999') = nvl(pbd.submit_stage,'-9999')

## Detail 0 ##
java.sql.SQLException: ORA-01417: a table may be outer joined to at most one other table

at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(
at oracle.jdbc.driver.T4CTTIfun.doRPC(
at oracle.jdbc.driver.T4C8Oall.doOALL(
at oracle.jdbc.driver.T4CPreparedStatement.doOall8(

The issue can be reproduced at will with the following steps:
1. Go to Sourcing Home Page
2. Search by Line Description
3. Enter Line Description and click Go
4. Error appears:
Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance.


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

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