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')

Samebug tips0

We couldn't find tips for this exception.

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

Solutions on the web1357

  • via Unknown by 729849,
  • via Unknown by 748660,
  • Stack trace

    • 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(OAException.java:896) at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870) at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:993) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211) at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:133) at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:797) at oracle.apps.per.selfservice.qualifications.webui.AddQualificationCO.processRequest(AddQualificationCO.java:73) at oracle.apps.per.selfservice.qualifications.webui.XXextendedAddQualificationsCO.processRequest(XXextendedAddQualificationsCO.java:28) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:596) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAHeaderBean.processRequest(OAHeaderBean.java:391) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.layout.OAStackLayoutBean.processRequest(OAStackLayoutBean.java:350) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1166) at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:964) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:931) at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:655) at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:251) at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2513) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1894) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:538) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:426)

    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 visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    10 more bugmates