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

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by 797277, 1 year ago
,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
via Oracle Community by Veejay, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT StructureEO.ID, StructureEO.NAME, StructureEO.PARENT_ID, StructureEO.PARENT_OBJ_TYPE, StructureEO.ARTICLE_ID
via Oracle Community by 775215, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name
via Oracle Community by user539616, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select decode(fnd_profile.value('BEN_DISPLAY_EMPLOYEE_NAME'),'FN',ppf.full_name, ppf.first_name||' '|| ppf.last_name) full_name
via Oracle Community by AlkaT., 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT quotelineeo.quote_line_id ,quotelineeo.quote_header_id ,quotelineeo.org_id ,quotelineeo.item_type_code
via Oracle Community by sreese, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select fdfc.descriptive_flex_context_code, ffvv.flex_value, ffvv.descriptionfrom fnd_flex_values_vl ffvv, fnd_descr_flex_col_usage_vl fdfc where
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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 5 days ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.