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

Oracle Community | 797277 | 6 years ago
  1. 0

    Standard Class code fails if we extend the Class

    Oracle Community | 6 years ago | 797277
    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
  2. 0

    db:: 5.87::oracle.jbo.NoDefException JBO-25058 1k

    hivmr.com | 5 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition DESCRIPTION of type Attribute not found in PreviousEmployment
  3. 0

    "Unknown Source" Errors

    wpthm.com | 1 year ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 16
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    db:: 3.71::I have an issue with an unknown User Account on the computer. 3d

    hivmr.com | 5 months ago
    oracle.apps.fnd.framework.OAException: java.lang.ArrayIndexOutOfBoundsException: 16

    1 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.renderDocument
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3247)
      4. oracle.apps.fnd.framework.webui.OAPageBean.renderDocument(OAPageBean.java:3042)
      4 frames