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 | 6 years ago
  1. 0

    JBO-27122 after substituting AllocationsLinesVO

    Oracle Community | 6 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 | 9 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