oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT bp.vendor_site_id, (bp.vendor_site_code || ' - ' || ps.ADDRESS_LINE1 || DECODE (ps.ADDRESS_LINE1,NULL,NULL,', ') || ps.ADDRESS_LINE2 || DECODE (ps.ADDRESS_LINE2,NULL,NULL,', ') || ps.ADDRESS_LINE3 || DECODE (ps.ADDRESS_LINE3,NULL,NULL,', ') || ps.ADDRESS_LINE4 || DECODE (ps.ADDRESS_LINE4,NULL,NULL,', ') || ps.CITY || DECODE (ps.CITY,NULL,NULL,', ') || ps.STATE || ' ' || ps.ZIP || DECODE (ps.ZIP,NULL,NULL,DECODE (ps.STATE,NULL,NULL,', ')) || DECODE(ps.COUNTRY, NULL, ps.PROVINCE, ps.COUNTRY)) vendor_site_code FROM pon_bidding_parties bp , pon_auction_headers_all ah, po_vendor_sites_all ps WHERE bp.auction_header_id = :1 AND ah.auction_header_id = bp.auction_header_id AND bp.trading_partner_id = :2 AND ps.vendor_site_id = bp.vendor_site_id AND ( ( ah.bid_frequency_code='SINGLE_BID_ONLY' AND bp.vendor_site_id NOT IN ( NVL( (SELECT bh.vendor_site_id FROM pon_bid_headers bh WHERE bh.auction_header_id = :3 AND bh.trading_partner_id = :4 AND bh.bid_status ='ACTIVE' ) , -1) , -1) ) OR ( ah.bid_frequency_code!='SINGLE_BID_ONLY' AND bp.vendor_site_id NOT IN (-1) ) ) ORDER BY bp.vendor_site_code

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1298

  • via Unknown by 797277,
  • via Unknown by Unknown author,
  • via Unknown by Unknown author,
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT bp.vendor_site_id, (bp.vendor_site_code || ' - ' || ps.ADDRESS_LINE1 || DECODE (ps.ADDRESS_LINE1,NULL,NULL,', ') || ps.ADDRESS_LINE2 || DECODE (ps.ADDRESS_LINE2,NULL,NULL,', ') || ps.ADDRESS_LINE3 || DECODE (ps.ADDRESS_LINE3,NULL,NULL,', ') || ps.ADDRESS_LINE4 || DECODE (ps.ADDRESS_LINE4,NULL,NULL,', ') || ps.CITY || DECODE (ps.CITY,NULL,NULL,', ') || ps.STATE || ' ' || ps.ZIP || DECODE (ps.ZIP,NULL,NULL,DECODE (ps.STATE,NULL,NULL,', ')) || DECODE(ps.COUNTRY, NULL, ps.PROVINCE, ps.COUNTRY)) vendor_site_code FROM pon_bidding_parties bp , pon_auction_headers_all ah, po_vendor_sites_all ps WHERE bp.auction_header_id = :1 AND ah.auction_header_id = bp.auction_header_id AND bp.trading_partner_id = :2 AND ps.vendor_site_id = bp.vendor_site_id AND ( ( ah.bid_frequency_code='SINGLE_BID_ONLY' AND bp.vendor_site_id NOT IN ( NVL( (SELECT bh.vendor_site_id FROM pon_bid_headers bh WHERE bh.auction_header_id = :3 AND bh.trading_partner_id = :4 AND bh.bid_status ='ACTIVE' ) , -1) , -1) ) OR ( ah.bid_frequency_code!='SINGLE_BID_ONLY' AND bp.vendor_site_id NOT IN (-1) ) ) ORDER BY bp.vendor_site_code at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3247) at oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    9 more bugmates