oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ExpenseReportLineEO.REPORT_LINE_ID, ExpenseReportLineEO.FLEX_CONCATENATED, ExpenseReportLineEO.START_EXPENSE_DATE, ExpenseReportLineEO.END_EXPENSE_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_AMOUNT, ExpenseReportLineEO.AMOUNT, ExpenseReportLineEO.CURRENCY_CODE, ExpenseReportLineEO.MERCHANT_NAME, ExpenseReportLineEO.LOCATION, ExpenseReportLineEO.ALLOCATION_REASON, ExpenseReportLineEO.JUSTIFICATION, ExpenseReportLineEO.CODE_COMBINATION_ID, ExpenseReportLineEO.REPORT_HEADER_ID, ExpenseReportLineEO.WEB_PARAMETER_ID, ExpenseReportLineEO.ORG_ID, ExpenseReportLineEO.DISTRIBUTION_LINE_NUMBER, ExpenseReportLineEO.PROJECT_ID, ExpenseReportLineEO.TASK_ID, ExpenseReportLineEO.AWARD_ID, ExpenseReportLineEO.EXPENDITURE_ORGANIZATION_ID, ExpenseReportLineEO.PROJECT_NUMBER, ExpenseReportLineEO.TASK_NUMBER, ExpenseReportLineEO.AWARD_NUMBER, ExpenseReportLineEO.CURRENCY_CODE AS CURRENCY_CODE1, ExpenseReportLineEO.CATEGORY_CODE, ExpenseReportLineEO.CREDIT_CARD_TRX_ID, ExpenseReportLineEO.ALLOCATION_SPLIT_CODE, ExpenseReportLineEO.EXPENDITURE_TYPE, ExpenseReportLineEO.EXPENDITURE_ITEM_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_CODE, ExpenseReportLineEO.ITEMIZATION_PARENT_ID, ExpenseReportLineEO.ATTRIBUTE3, ExpenseReportLineEO.LAST_UPDATE_DATE FROM AP_EXPENSE_REPORT_LINES_ALL ExpenseReportLineEO WHERE (itemization_parent_id IS NULL OR itemization_parent_id 0) AND NOT EXISTS (SELECT 1 FROM ap_expense_report_params_all WHERE expense_type_code in ('ROUNDING', 'PERSONAL') AND parameter_id = ExpenseReportLineEO.web_parameter_id) AND :1 = ExpenseReportLineEO.REPORT_HEADER_ID AND ExpenseReportLineEO.FLEX_CONCATENATED='Y' ORDER BY distribution_line_number

Oracle Community | 635290 | 7 years ago
tip
Your exception is missing from the Samebug knowledge base.
Here are the best solutions we found on the Internet.
Click on the to mark the helpful solution and get rewards for you help.
  1. 0

    JBO-27122 after substituting AllocationsLinesVO

    Oracle Community | 7 years ago | 635290
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT ExpenseReportLineEO.REPORT_LINE_ID, ExpenseReportLineEO.FLEX_CONCATENATED, ExpenseReportLineEO.START_EXPENSE_DATE, ExpenseReportLineEO.END_EXPENSE_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_AMOUNT, ExpenseReportLineEO.AMOUNT, ExpenseReportLineEO.CURRENCY_CODE, ExpenseReportLineEO.MERCHANT_NAME, ExpenseReportLineEO.LOCATION, ExpenseReportLineEO.ALLOCATION_REASON, ExpenseReportLineEO.JUSTIFICATION, ExpenseReportLineEO.CODE_COMBINATION_ID, ExpenseReportLineEO.REPORT_HEADER_ID, ExpenseReportLineEO.WEB_PARAMETER_ID, ExpenseReportLineEO.ORG_ID, ExpenseReportLineEO.DISTRIBUTION_LINE_NUMBER, ExpenseReportLineEO.PROJECT_ID, ExpenseReportLineEO.TASK_ID, ExpenseReportLineEO.AWARD_ID, ExpenseReportLineEO.EXPENDITURE_ORGANIZATION_ID, ExpenseReportLineEO.PROJECT_NUMBER, ExpenseReportLineEO.TASK_NUMBER, ExpenseReportLineEO.AWARD_NUMBER, ExpenseReportLineEO.CURRENCY_CODE AS CURRENCY_CODE1, ExpenseReportLineEO.CATEGORY_CODE, ExpenseReportLineEO.CREDIT_CARD_TRX_ID, ExpenseReportLineEO.ALLOCATION_SPLIT_CODE, ExpenseReportLineEO.EXPENDITURE_TYPE, ExpenseReportLineEO.EXPENDITURE_ITEM_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_CODE, ExpenseReportLineEO.ITEMIZATION_PARENT_ID, ExpenseReportLineEO.ATTRIBUTE3, ExpenseReportLineEO.LAST_UPDATE_DATE FROM AP_EXPENSE_REPORT_LINES_ALL ExpenseReportLineEO WHERE (itemization_parent_id IS NULL OR itemization_parent_id 0) AND NOT EXISTS (SELECT 1 FROM ap_expense_report_params_all WHERE expense_type_code in ('ROUNDING', 'PERSONAL') AND parameter_id = ExpenseReportLineEO.web_parameter_id) AND :1 = ExpenseReportLineEO.REPORT_HEADER_ID AND ExpenseReportLineEO.FLEX_CONCATENATED='Y' ORDER BY distribution_line_number
  2. 0

    Error while loading RTF template

    Oracle Community | 10 years ago | user588642
    oracle.apps.fnd.framework.OAException: oracle.apps.xdo.XDOException: String index out of range: 71
  3. 0

    SQL Exception when extending a VO in R12

    Oracle Community | 9 years ago | 501198
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select ppf.employee_number, ppf.npw_number, decode(:1,'G',ppf.global_name,ppf.local_name) full_name, ppf.email_address, bg.name business_group, org.name organization, assignment_number, decode(ppf.current_employee_flag,'Y',1,0) is_employee, decode(ppf.current_npw_flag,'Y',1,0) is_cwk, paf.primary_flag, hr_util_misc_ss.getobjectname('JOB',j.job_id,ppf.business_group_id,j.name) job, hr_util_misc_ss.getobjectname('POSITION',p.position_id,ppf.business_group_id,p.name) position, hr_util_misc_ss.getobjectname('GRADE', g.grade_id,ppf.business_group_id,g.name) grade, ltl.location_code, l.derived_locale, decode(paf.assignment_type, 'C', hr_general.decode_lookup('CWK_ASG_CATEGORY', paf.employment_category), hr_general.decode_lookup('EMP_CAT', paf.employment_category)) assignment_category, ppp.proposed_salary_n * decode(pay_annualization_factor, null, 1, 0, 1, pay_annualization_factor) annual_salary, null currency, pb.name pay_basis, hr_general.decode_lookup('PAY_BASIS',pb.pay_basis) salary_frequency, payroll.payroll_name, decode(:2,'G',sup.global_name,sup.local_name) supervisor, ppf.person_id person_id, paf.assignment_id assignment_id, ppp.pay_proposal_id pay_proposal_id, (select hr_util_misc_ss.get_in_preferred_currency_str(ppp.proposed_salary_n * decode(pay_annualization_factor, null, 1, 0, 1, pay_annualization_factor),currency_code,trunc(sysdate)) from pay_input_values_f ivf, pay_element_types_f petf, fnd_currencies_tl c where pb.input_value_id = ivf.input_value_id and ppp.change_date between ivf.effective_start_date and ivf.effective_end_date and ivf.element_type_id = petf.element_type_id and petf.input_currency_code = c.currency_code and c.language = userenv('LANG') and ppp.change_date between petf.effective_start_date and petf.effective_end_date) multi_currency, ppf.date_of_birth from per_all_people_f ppf, per_all_assignments_f paf, hr_all_organization_units_tl bg, hr_all_organization_units_tl org, per_jobs_tl j, per_grades_tl g, hr_all_positions_f_tl p, hr_locations_all l, hr_locations_all_tl ltl, per_all_people_f sup, per_pay_proposals ppp, per_pay_bases pb, pay_all_payrolls_f payroll where ppf.person_id = :3 and paf.person_id(+) = ppf.person_id and decode(paf.assignment_type(+),'E' ,'T','C','T',null, 'T','F') ='T' and paf.pay_basis_id = pb.pay_basis_id(+) and paf.assignment_id = ppp.assignment_id(+) and ppp.pay_proposal_id(+) = hr_mee_views_gen.getAsgProposalId(paf.assignment_id) and ppp.approved(+) = 'Y' and paf.job_id = j.job_id(+) and j.language(+) = userenv('LANG') and ppf.business_group_id = bg.organization_id and bg.language = userenv('LANG') and paf.organization_id = org.organization_id(+) and org.language(+) = userenv('LANG') and paf.grade_id = g.grade_id(+) and g.language(+) = userenv('LANG') and paf.position_id = p.position_id(+) and p.language(+) = userenv('LANG') and paf.location_id = l.location_id(+) and paf.location_id = ltl.location_id(+) and ltl.language(+) = userenv('LANG') and paf.supervisor_id = sup.person_id(+) and paf.payroll_id = payroll.payroll_id(+) and trunc(sysdate) between payroll.effective_start_date(+) and payroll.effective_end_date(+) and :4 between paf.effective_start_date(+) and paf.effective_end_date(+) and :5 between ppf.effective_start_date and ppf.effective_end_date and :6 between sup.effective_start_date(+) and sup.effective_end_date(+)) QRSLT WHERE (ASSIGNMENT_ID = :7)
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Missing IN or OUT parameter at index...

    Oracle Community | 9 years ago | 533926
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select a.party_id, a.party_name , (select b.party_id from hz_parties a , hz_relationships b, fnd_user c where b.party_id = c.customer_id and b.object_type = 'PERSON' and a.party_id = b.object_id and c.user_id = :1 ) Contact_Party_ID, (select party_name from hz_parties a , hz_relationships b, fnd_user c where b.party_id = c.customer_id and b.object_type = 'PERSON' and a.party_id = b.object_id and c.user_id = :1 ) Contact_Name, b.cust_account_id from hz_parties a, hz_cust_accounts b where b.party_id = a.party_id and b.cust_account_id = :2
  6. 0

    Invalid Index Error....

    Oracle Community | 9 years ago | 619461
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 129 with java object of type java.lang.String due to java.sql.SQLException.

    2 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 ExpenseReportLineEO.REPORT_LINE_ID, ExpenseReportLineEO.FLEX_CONCATENATED, ExpenseReportLineEO.START_EXPENSE_DATE, ExpenseReportLineEO.END_EXPENSE_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_AMOUNT, ExpenseReportLineEO.AMOUNT, ExpenseReportLineEO.CURRENCY_CODE, ExpenseReportLineEO.MERCHANT_NAME, ExpenseReportLineEO.LOCATION, ExpenseReportLineEO.ALLOCATION_REASON, ExpenseReportLineEO.JUSTIFICATION, ExpenseReportLineEO.CODE_COMBINATION_ID, ExpenseReportLineEO.REPORT_HEADER_ID, ExpenseReportLineEO.WEB_PARAMETER_ID, ExpenseReportLineEO.ORG_ID, ExpenseReportLineEO.DISTRIBUTION_LINE_NUMBER, ExpenseReportLineEO.PROJECT_ID, ExpenseReportLineEO.TASK_ID, ExpenseReportLineEO.AWARD_ID, ExpenseReportLineEO.EXPENDITURE_ORGANIZATION_ID, ExpenseReportLineEO.PROJECT_NUMBER, ExpenseReportLineEO.TASK_NUMBER, ExpenseReportLineEO.AWARD_NUMBER, ExpenseReportLineEO.CURRENCY_CODE AS CURRENCY_CODE1, ExpenseReportLineEO.CATEGORY_CODE, ExpenseReportLineEO.CREDIT_CARD_TRX_ID, ExpenseReportLineEO.ALLOCATION_SPLIT_CODE, ExpenseReportLineEO.EXPENDITURE_TYPE, ExpenseReportLineEO.EXPENDITURE_ITEM_DATE, ExpenseReportLineEO.RECEIPT_CURRENCY_CODE, ExpenseReportLineEO.ITEMIZATION_PARENT_ID, ExpenseReportLineEO.ATTRIBUTE3, ExpenseReportLineEO.LAST_UPDATE_DATE FROM AP_EXPENSE_REPORT_LINES_ALL ExpenseReportLineEO WHERE (itemization_parent_id IS NULL OR itemization_parent_id 0) AND NOT EXISTS (SELECT 1 FROM ap_expense_report_params_all WHERE expense_type_code in ('ROUNDING', 'PERSONAL') AND parameter_id = ExpenseReportLineEO.web_parameter_id) AND :1 = ExpenseReportLineEO.REPORT_HEADER_ID AND ExpenseReportLineEO.FLEX_CONCATENATED='Y' ORDER BY distribution_line_number

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAApplicationModuleImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:720)
      5 frames
    3. oracle.apps.ap
      AllocationsHGridCO.processRequest
      1. oracle.apps.ap.oie.entry.accounting.webui.AllocationsHGridCO.processRequest(AllocationsHGridCO.java:187)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596)
      2. oracle.apps.fnd.framework.webui.OAWebBeanTableHelper.processRequest(OAWebBeanTableHelper.java:2136)
      3. oracle.apps.fnd.framework.webui.OAWebBeanHGridHelper.processRequest(OAWebBeanHGridHelper.java:1643)
      4. oracle.apps.fnd.framework.webui.beans.table.OAHGridBean.processRequest(OAHGridBean.java:688)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      9. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:389)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      15. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      16. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      17. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      18. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      19. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      20. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      21. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      22. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      23. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      24. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
      25. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      26. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      27. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      28. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      29. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      30. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)
      31. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      32. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      33. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      34. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      35. oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)
      36. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2491)
      37. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1889)
      38. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:533)
      39. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:421)
      39 frames