oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select pq.qualification_id, pq.qualification_type_id, pq.object_version_number, pq.title, pq.start_date, pq.end_date, pq.status, pq.grade_attained, pq.tuition_method, pq.fee, pq.fee_currency, pq.reimbursement_arrangements, pq.training_completed_amount, pq.training_completed_units, pq.total_training_amount, pq.comments, pq.attendance_id, pq.awarding_body, pq.group_ranking, pq.awarded_date, pq.license_number, pq.expiry_date, pq.license_restrictions, pq.attribute_category, pq.attribute1, pq.attribute2, pq.attribute3, pq.attribute4, pq.attribute5, pq.attribute6, pq.attribute7, pq.attribute8, pq.attribute9, pq.attribute10, pq.attribute11, pq.attribute12, pq.attribute13, pq.attribute14, pq.attribute15, pq.attribute16, pq.attribute17, pq.attribute18, pq.attribute19, pq.attribute20, pq.business_group_id, pq.person_id, pq.party_id, 'N' IS_DELETED, pqt.name qualification_type, pq.qua_information_category, pq.qua_information1, pq.qua_information2, pq.qua_information3, pq.qua_information4, pq.qua_information5, pq.qua_information6, pq.qua_information7, pq.qua_information8, pq.qua_information9, pq.qua_information10, pq.qua_information11, pq.qua_information12, pq.qua_information13, pq.qua_information14, pq.qua_information15, pq.qua_information16, pq.qua_information17, pq.qua_information18, pq.qua_information19, pq.qua_information20, null status_meaning, null tuition_method_meaning, to_number(null) transaction_step_id, null pending_establishment from per_qualifications_vl pq, per_qualification_types_tl pqt where pq.qualification_id = :1 and pq.qualification_type_id = pqt.qualification_type_id(+) and pqt.LANGUAGE = userenv('LANG')

Oracle Community | 563297 | 6 years ago
  1. 0

    Automatically Setting a Status following an Action in SSHR - Qualifications

    Oracle Community | 6 years ago | 563297
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: Select pq.qualification_id, pq.qualification_type_id, pq.object_version_number, pq.title, pq.start_date, pq.end_date, pq.status, pq.grade_attained, pq.tuition_method, pq.fee, pq.fee_currency, pq.reimbursement_arrangements, pq.training_completed_amount, pq.training_completed_units, pq.total_training_amount, pq.comments, pq.attendance_id, pq.awarding_body, pq.group_ranking, pq.awarded_date, pq.license_number, pq.expiry_date, pq.license_restrictions, pq.attribute_category, pq.attribute1, pq.attribute2, pq.attribute3, pq.attribute4, pq.attribute5, pq.attribute6, pq.attribute7, pq.attribute8, pq.attribute9, pq.attribute10, pq.attribute11, pq.attribute12, pq.attribute13, pq.attribute14, pq.attribute15, pq.attribute16, pq.attribute17, pq.attribute18, pq.attribute19, pq.attribute20, pq.business_group_id, pq.person_id, pq.party_id, 'N' IS_DELETED, pqt.name qualification_type, pq.qua_information_category, pq.qua_information1, pq.qua_information2, pq.qua_information3, pq.qua_information4, pq.qua_information5, pq.qua_information6, pq.qua_information7, pq.qua_information8, pq.qua_information9, pq.qua_information10, pq.qua_information11, pq.qua_information12, pq.qua_information13, pq.qua_information14, pq.qua_information15, pq.qua_information16, pq.qua_information17, pq.qua_information18, pq.qua_information19, pq.qua_information20, null status_meaning, null tuition_method_meaning, to_number(null) transaction_step_id, null pending_establishment from per_qualifications_vl pq, per_qualification_types_tl pqt where pq.qualification_id = :1 and pq.qualification_type_id = pqt.qualification_type_id(+) and pqt.LANGUAGE = userenv('LANG')
  2. 0

    Problem after Extending a VO

    Oracle Community | 7 years ago | 729849
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidObjNameException: JBO-25005: Object name 4 for type Variable is invalid
  3. 0

    How to extend CompetenceElementsVO

    Oracle Community | 7 years ago | 748660
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. . .
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Error Trying to extend CreditCardsVO in iExpense

    Oracle Community | 5 years ago | user11997242
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  6. 0

    Open Account Balances Listing Definition- Update error

    Oracle Community | 11 months ago | Karthik Appsys
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    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 pq.qualification_id, pq.qualification_type_id, pq.object_version_number, pq.title, pq.start_date, pq.end_date, pq.status, pq.grade_attained, pq.tuition_method, pq.fee, pq.fee_currency, pq.reimbursement_arrangements, pq.training_completed_amount, pq.training_completed_units, pq.total_training_amount, pq.comments, pq.attendance_id, pq.awarding_body, pq.group_ranking, pq.awarded_date, pq.license_number, pq.expiry_date, pq.license_restrictions, pq.attribute_category, pq.attribute1, pq.attribute2, pq.attribute3, pq.attribute4, pq.attribute5, pq.attribute6, pq.attribute7, pq.attribute8, pq.attribute9, pq.attribute10, pq.attribute11, pq.attribute12, pq.attribute13, pq.attribute14, pq.attribute15, pq.attribute16, pq.attribute17, pq.attribute18, pq.attribute19, pq.attribute20, pq.business_group_id, pq.person_id, pq.party_id, 'N' IS_DELETED, pqt.name qualification_type, pq.qua_information_category, pq.qua_information1, pq.qua_information2, pq.qua_information3, pq.qua_information4, pq.qua_information5, pq.qua_information6, pq.qua_information7, pq.qua_information8, pq.qua_information9, pq.qua_information10, pq.qua_information11, pq.qua_information12, pq.qua_information13, pq.qua_information14, pq.qua_information15, pq.qua_information16, pq.qua_information17, pq.qua_information18, pq.qua_information19, pq.qua_information20, null status_meaning, null tuition_method_meaning, to_number(null) transaction_step_id, null pending_establishment from per_qualifications_vl pq, per_qualification_types_tl pqt where pq.qualification_id = :1 and pq.qualification_type_id = pqt.qualification_type_id(+) and pqt.LANGUAGE = userenv('LANG')

      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.OAUtility.invokeMethod(OAUtility.java:133)
      6. oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797)
      6 frames
    3. oracle.apps.per
      XXextendedAddQualificationsCO.processRequest
      1. oracle.apps.per.selfservice.qualifications.webui.AddQualificationCO.processRequest(AddQualificationCO.java:73)
      2. oracle.apps.per.selfservice.qualifications.webui.XXextendedAddQualificationsCO.processRequest(XXextendedAddQualificationsCO.java:28)
      2 frames
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      3. oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391)
      4. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      7. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      8. oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350)
      9. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655)
      12. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251)
      13. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166)
      14. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)
      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.form.OAFormBean.processRequest(OAFormBean.java:385)
      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.beans.OABodyBean.processRequest(OABodyBean.java:353)
      25. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513)
      26. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894)
      27. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538)
      28. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)
      28 frames