oracle.apps.fnd.framework.OAException

oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hp.party_name, hp.party_id as party_id, hp.duns_number_c as duns, pv.vendor_id, pv.vendor_name, decode(pv.organization_type_lookup_code, 'INDIVIDUAL',pv.individual_1099, 'FOREIGN INDIVIDUAL',pv.individual_1099, pv.num_1099) taxpayer_id, pv.vat_registration_num as tax_reg_num, pv.segment1, pv.VENDOR_NAME_ALT as alternate_name, pv.end_date_active as end_date_active, pv.start_date_active as start_date_active, pv.ONE_TIME_FLAG, pv.VENDOR_TYPE_LOOKUP_CODE, pv.PARENT_VENDOR_ID, parent.vendor_name as parent_vendor_name, pv.PAYMENT_PRIORITY, parent.segment1 as parent_Segment1, pv.TAX_REPORTING_NAME, pv.terms_id, terms.name as terms_desc, pv.FEDERAL_REPORTABLE_FLAG, pv.STATE_REPORTABLE_FLAG, pv.PAY_GROUP_LOOKUP_CODE, pay_group.description as pay_group_desc, aptt.description as income_tax_type, hp.organization_name_phonetic, plc.DISPLAYED_FIELD as VENDOR_TYPE_DISPLAY, pv.type_1099 as income_tax_type_code, pv.employee_id as employee_id, pecx.employee_num AS employee_number from hz_parties hp, ap_suppliers pv, ap_suppliers parent, ap_terms_tl terms, fnd_lookup_values pay_group, AP_INCOME_TAX_TYPES aptt, po_lookup_codes plc, per_employees_current_x pecx where pv.party_id = hp.party_id AND pv.party_id = pecx.party_id (+) and parent.vendor_id (+) = pv.parent_vendor_id and pv.terms_id = terms.term_id (+) and terms.language (+) = userenv('LANG') and terms.enabled_flag (+) ='Y' and pv.pay_group_lookup_code = pay_group.lookup_code (+) and pay_group.lookup_type (+)='PAY GROUP' and pay_group.language (+)=userenv('lang') and pv.type_1099 = aptt.income_tax_type (+) and pv.VENDOR_TYPE_LOOKUP_CODE = plc.LOOKUP_CODE (+) and plc.lookup_type (+) = 'VENDOR TYPE') QRSLT WHERE (PAY_GROUP_LOOKUP_CODE like '> 2 MILLION%') ORDER BY VENDOR_NAME ASC

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web1002

  • pv.pay_group_lookup_code = pay_group.lookup_code (+) and pay_group.lookup_type (+)='PAY GROUP' and pay_group.language (+)=userenv('lang') and pv.type_1099 = aptt.income_tax_type (+) and pv.VENDOR_TYPE_LOOKUP_CODE = plc.LOOKUP_CODE (+) and plc.lookup_type (+) = 'VENDOR TYPE') QRSLT WHERE (PAY_GROUP_LOOKUP_CODE like '> 2 MILLION%') ORDER BY VENDOR_NAME ASC
  • oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id , OpportunityEO.last_update_date as LastUpdateDate, OpportunityEO.creation_date , OpportunityEO.lead_number
  • via Oracle Community by 533926, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT OpportunityEO.lead_id , OpportunityEO.last_update_date , OpportunityEO.creation_date , OpportunityEO.lead_number, OpportunityEO.customer_id
  • Stack trace

    • oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hp.party_name, hp.party_id as party_id, hp.duns_number_c as duns, pv.vendor_id, pv.vendor_name, decode(pv.organization_type_lookup_code, 'INDIVIDUAL',pv.individual_1099, 'FOREIGN INDIVIDUAL',pv.individual_1099, pv.num_1099) taxpayer_id, pv.vat_registration_num as tax_reg_num, pv.segment1, pv.VENDOR_NAME_ALT as alternate_name, pv.end_date_active as end_date_active, pv.start_date_active as start_date_active, pv.ONE_TIME_FLAG, pv.VENDOR_TYPE_LOOKUP_CODE, pv.PARENT_VENDOR_ID, parent.vendor_name as parent_vendor_name, pv.PAYMENT_PRIORITY, parent.segment1 as parent_Segment1, pv.TAX_REPORTING_NAME, pv.terms_id, terms.name as terms_desc, pv.FEDERAL_REPORTABLE_FLAG, pv.STATE_REPORTABLE_FLAG, pv.PAY_GROUP_LOOKUP_CODE, pay_group.description as pay_group_desc, aptt.description as income_tax_type, hp.organization_name_phonetic, plc.DISPLAYED_FIELD as VENDOR_TYPE_DISPLAY, pv.type_1099 as income_tax_type_code, pv.employee_id as employee_id, pecx.employee_num AS employee_number from hz_parties hp, ap_suppliers pv, ap_suppliers parent, ap_terms_tl terms, fnd_lookup_values pay_group, AP_INCOME_TAX_TYPES aptt, po_lookup_codes plc, per_employees_current_x pecx where pv.party_id = hp.party_id AND pv.party_id = pecx.party_id (+) and parent.vendor_id (+) = pv.parent_vendor_id and pv.terms_id = terms.term_id (+) and terms.language (+) = userenv('LANG') and terms.enabled_flag (+) ='Y' and pv.pay_group_lookup_code = pay_group.lookup_code (+) and pay_group.lookup_type (+)='PAY GROUP' and pay_group.language (+)=userenv('lang') and pv.type_1099 = aptt.income_tax_type (+) and pv.VENDOR_TYPE_LOOKUP_CODE = plc.LOOKUP_CODE (+) and plc.lookup_type (+) = 'VENDOR TYPE') QRSLT WHERE (PAY_GROUP_LOOKUP_CODE like '> 2 MILLION%') ORDER BY VENDOR_NAME ASC 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.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2972) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1852) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

    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 user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates