oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE, PAAT.ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID, FCL.MEANING ABSENCE_CATEGORY, PAAT.ABSENCE_CATEGORY ABSENCE_CATEGORY_CODE, NVL(PAA.ABSENCE_HOURS, HR_ABSUTIL_SS.GETABSDURHOURS(PAAT.ABSENCE_ATTENDANCE_TYPE_ID, PAA.BUSINESS_GROUP_ID, PAA.CREATION_DATE, PAA.PERSON_ID, PAA.DATE_PROJECTED_START, PAA.DATE_PROJECTED_END, PAA.TIME_PROJECTED_START, PAA.TIME_PROJECTED_END)) ABSENCE_HOURS, (SELECT MEANING FROM HR_LOOKUPS WHERE 'A' = LOOKUP_CODE(+) AND 'LEAVE_STATUS' = LOOKUP_TYPE(+)) APPROVAL_STATUS, 'A' APPROVAL_STATUS_CODE, DECODE(PAA.DATE_START, NULL, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ABSENCE_STATUS' AND LOOKUP_CODE = 'PLANNED' AND LANGUAGE = USERENV('LANG')), (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ABSENCE_STATUS' AND LOOKUP_CODE = 'CONFIRMED' AND LANGUAGE = USERENV('LANG'))) ABSENCE_STATUS, DECODE(PAA.DATE_START, NULL, 'PLANNED', 'CONFIRMED') ABSENCE_STATUS_CODE, (NVL((SELECT 'Y' FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME = 'PER_ABSENCE_ATTENDANCES' AND PK1_VALUE = TO_CHAR(PAA.ABSENCE_ATTENDANCE_ID)), 'N')) SUPPORTING_DOCUMENTS, DECODE(PAA.DATE_START, NULL, DECODE(SIGN((PAA.DATE_PROJECTED_START + 1) - SYSDATE), 1, 'HrCancelEnabled', 'HrCancelDisabled'), DECODE(SIGN(NVL(PAA.DATE_END, SYSDATE + 1) - SYSDATE), 1, 'HrCancelEnabled', 'HrCancelDisabled')) CANCEL_ICON, DECODE(PAA.DATE_END, NULL, DECODE(PAA.DATE_START, NULL, 'HrConfirmEnabled', 'HrConfirmDisabled'), 'HrConfirmDisabled') CONFIRM_ICON, DECODE(PAA.DATE_START, NULL, 'HrUpdateEnabled', DECODE(SIGN(NVL(PAA.DATE_END, SYSDATE + 1) - SYSDATE), 1, 'HrUpdateEnabled', 'HrUpdateDisabled')) UPDATE_ICON, NULL DETAILS_ICON, PAA.ABSENCE_ATTENDANCE_ID, NULL TRANSACTION_ID, TO_CHAR(PAA.ABSENCE_ATTENDANCE_ID) SUPPORTINGDOCKEY, NVL(PAA.ABSENCE_DAYS, HR_ABSUTIL_SS.GETABSDURDAYS(PAAT.ABSENCE_ATTENDANCE_TYPE_ID, PAA.BUSINESS_GROUP_ID, PAA.CREATION_DATE, PAA.PERSON_ID, PAA.DATE_PROJECTED_START, PAA.DATE_PROJECTED_END, PAA.TIME_PROJECTED_START, PAA.TIME_PROJECTED_END)) ABSENCE_DAYS FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAAT, PER_ABS_ATTENDANCE_TYPES_TL PAATTL, HR_LOOKUPS FCL WHERE PAA.PERSON_ID = :1 AND PAA.BUSINESS_GROUP_ID + 0 = :2 AND PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAAT.ABSENCE_ATTENDANCE_TYPE_ID AND PAAT.ABSENCE_ATTENDANCE_TYPE_ID = PAATTL.ABSENCE_ATTENDANCE_TYPE_ID AND PAATTL.LANGUAGE = USERENV('LANG') AND FCL.LOOKUP_TYPE(+) = 'ABSENCE_CATEGORY' AND PAAT.ABSENCE_CATEGORY = FCL.LOOKUP_CODE(+) AND ((HR_API.RETURN_LEGISLATION_CODE(PAAT.BUSINESS_GROUP_ID) = 'GB' AND NVL(PAAT.ABSENCE_CATEGORY, '#') NOT IN ('M', 'GB_PAT_ADO', 'GB_PAT_BIRTH', 'GB_ADO')) OR (HR_API.RETURN_LEGISLATION_CODE(PAAT.BUSINESS_GROUP_ID) <> 'GB' AND NVL(PAAT.ABSENCE_CATEGORY, '#') NOT IN ('GB_PAT_ADO', 'GB_PAT_BIRTH', 'GB_ADO'))) AND NOT EXISTS (SELECT 'e' FROM HR_API_TRANSACTIONS T WHERE T.SELECTED_PERSON_ID = PAA.PERSON_ID AND T.CREATOR_PERSON_ID = NVL(:3, T.CREATOR_PERSON_ID) AND T.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES' AND T.TRANSACTION_REF_ID = PAA.ABSENCE_ATTENDANCE_ID AND NOT (HR_ABSUTIL_SS.GETABSENCETYPE(T.TRANSACTION_ID, NULL) IS NULL AND T.STATUS = 'W') AND T.STATUS NOT IN ('D', 'E')) AND DECODE(:6,'PLANNED','PLANNED','CONFIRMED_PLANNED') = DECODE(:6,NULL,'CONFIRMED_PLANNED','CONFIRMED','CONFIRMED_PLANNED',DECODE(PAA.DATE_START, NULL, 'PLANNED', 'CONFIRMED')) UNION ALL SELECT HR_ABSUTIL_SS.GETSTARTDATE(HAT.TRANSACTION_ID, NULL) START_DATE, HR_ABSUTIL_SS.GETENDDATE(HAT.TRANSACTION_ID, NULL) END_DATE, HR_ABSUTIL_SS.GETABSENCETYPE(HAT.TRANSACTION_ID, NULL) ABSENCE_TYPE, TO_NUMBER(HATS.INFORMATION5) ABSENCE_ATTENDANCE_TYPE_ID, HR_ABSUTIL_SS.GETABSENCECATEGORY(HAT.TRANSACTION_ID, NULL) ABSENCE_CATEGORY, HATS.INFORMATION6 ABSENCE_CATEGORY_CODE, HR_ABSUTIL_SS.GETABSENCEHOURSDURATION(HAT.TRANSACTION_ID, NULL) ABSENCE_HOURS, HR_ABSUTIL_SS.GETAPPROVALSTATUS(HAT.TRANSACTION_ID, NULL) APPROVAL_STATUS, HR_ABSUTIL_SS.GETAPPROVALSTATUSCODE(HAT.TRANSACTION_ID, NULL) APPROVAL_STATUS_CODE, HR_ABSUTIL_SS.GETABSENCESTATUS(HAT.TRANSACTION_ID, NULL) ABSENCE_STATUS, HATS.INFORMATION9 ABSENCE_STATUS_CODE, HR_ABSUTIL_SS.HASSUPPORTINGDOCUMENTS(HAT.TRANSACTION_ID, HAT.TRANSACTION_REF_ID) SUPPORTING_DOCUMENTS, HR_ABSUTIL_SS.ISCANCELALLOWED(HAT.TRANSACTION_ID, NULL, HAT.STATUS) CANCEL_ICON, HR_ABSUTIL_SS.ISCONFIRMALLOWED(HAT.TRANSACTION_ID, NULL) CONFIRM_ICON, HR_ABSUTIL_SS.ISUPDATEALLOWED(HAT.TRANSACTION_ID, NULL, HAT.STATUS) UPDATE_ICON, NULL DETAILS_ICON, HAT.TRANSACTION_REF_ID ABSENCE_ATTENDANCE_ID, HAT.TRANSACTION_ID TRANSACTION_ID, TO_CHAR(HAT.TRANSACTION_REF_ID || '_' || HAT.TRANSACTION_ID) SUPPORTINGDOCKEY, HR_ABSUTIL_SS.GETABSENCEDAYSDURATION(HAT.TRANSACTION_ID, NULL) ABSENCE_DAYS FROM HR_API_TRANSACTIONS HAT, HR_API_TRANSACTION_STEPS HATS WHERE HAT.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES' AND HAT.TRANSACTION_GROUP = 'ABSENCE_MGMT' AND HAT.TRANSACTION_IDENTIFIER = 'ABSENCES' AND HAT.TRANSACTION_REF_ID IS NOT NULL AND HAT.SELECTED_PERSON_ID = :4 AND HAT.CREATOR_PERSON_ID = NVL(:5, HAT.CREATOR_PERSON_ID) AND HAT.TRANSACTION_ID = HATS.TRANSACTION_ID(+) AND HAT.STATUS NOT IN ('D', 'E') AND NOT (HR_ABSUTIL_SS.GETABSENCETYPE(HAT.TRANSACTION_ID, NULL) IS NULL AND HAT.STATUS = 'W') AND DECODE(:6,'PLANNED','PLANNED','CONFIRMED_PLANNED') = DECODE(:6,NULL,'CONFIRMED_PLANNED','CONFIRMED','CONFIRMED_PLANNED',HATS.INFORMATION9) ORDER BY START_DATE DESC) QRSLT WHERE (( ABSENCE_ATTENDANCE_TYPE_ID = :7 )) ORDER BY START_DATE DESC

Searched on Google with the first line of a JAVA stack trace?

We can recommend more relevant solutions and speed up debugging when you paste your entire stack trace with the exception message. Try a sample exception.

Recommended solutions based on your search

Solutions on the web

via Oracle Community by Bipin Behari Sethy, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE
via Oracle Community by 882688, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID
via Oracle Community by 877023, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT score (1) AS score, doc.document_id, doc.file_name, doc.last_update_date, ppf.email_address, addr.derived_locale, addr.address_id, ppf.full_name
via Oracle Community by Renu Gupta, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID
via Oracle Community by 27091988, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT VAC.NAME vname, meaning xxstatus FROM XX_VACANCY_VIEW VAC, xx_fnd_lookups st) QRSLT WHERE (VAC.STATUS=xx_fnd_lookups.LOOKUP_CODE and vac.name like xxGL AND meaning in ('Waiting For Approval'))
via Oracle Community by Asmirnov-Oracle, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE, PAAT.ABSENCE_ATTENDANCE_TYPE_ID ABSENCE_ATTENDANCE_TYPE_ID, FCL.MEANING ABSENCE_CATEGORY, PAAT.ABSENCE_CATEGORY ABSENCE_CATEGORY_CODE, NVL(PAA.ABSENCE_HOURS, HR_ABSUTIL_SS.GETABSDURHOURS(PAAT.ABSENCE_ATTENDANCE_TYPE_ID, PAA.BUSINESS_GROUP_ID, PAA.CREATION_DATE, PAA.PERSON_ID, PAA.DATE_PROJECTED_START, PAA.DATE_PROJECTED_END, PAA.TIME_PROJECTED_START, PAA.TIME_PROJECTED_END)) ABSENCE_HOURS, (SELECT MEANING FROM HR_LOOKUPS WHERE 'A' = LOOKUP_CODE(+) AND 'LEAVE_STATUS' = LOOKUP_TYPE(+)) APPROVAL_STATUS, 'A' APPROVAL_STATUS_CODE, DECODE(PAA.DATE_START, NULL, (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ABSENCE_STATUS' AND LOOKUP_CODE = 'PLANNED' AND LANGUAGE = USERENV('LANG')), (SELECT MEANING FROM FND_LOOKUP_VALUES WHERE LOOKUP_TYPE = 'ABSENCE_STATUS' AND LOOKUP_CODE = 'CONFIRMED' AND LANGUAGE = USERENV('LANG'))) ABSENCE_STATUS, DECODE(PAA.DATE_START, NULL, 'PLANNED', 'CONFIRMED') ABSENCE_STATUS_CODE, (NVL((SELECT 'Y' FROM FND_ATTACHED_DOCUMENTS WHERE ENTITY_NAME = 'PER_ABSENCE_ATTENDANCES' AND PK1_VALUE = TO_CHAR(PAA.ABSENCE_ATTENDANCE_ID)), 'N')) SUPPORTING_DOCUMENTS, DECODE(PAA.DATE_START, NULL, DECODE(SIGN((PAA.DATE_PROJECTED_START + 1) - SYSDATE), 1, 'HrCancelEnabled', 'HrCancelDisabled'), DECODE(SIGN(NVL(PAA.DATE_END, SYSDATE + 1) - SYSDATE), 1, 'HrCancelEnabled', 'HrCancelDisabled')) CANCEL_ICON, DECODE(PAA.DATE_END, NULL, DECODE(PAA.DATE_START, NULL, 'HrConfirmEnabled', 'HrConfirmDisabled'), 'HrConfirmDisabled') CONFIRM_ICON, DECODE(PAA.DATE_START, NULL, 'HrUpdateEnabled', DECODE(SIGN(NVL(PAA.DATE_END, SYSDATE + 1) - SYSDATE), 1, 'HrUpdateEnabled', 'HrUpdateDisabled')) UPDATE_ICON, NULL DETAILS_ICON, PAA.ABSENCE_ATTENDANCE_ID, NULL TRANSACTION_ID, TO_CHAR(PAA.ABSENCE_ATTENDANCE_ID) SUPPORTINGDOCKEY, NVL(PAA.ABSENCE_DAYS, HR_ABSUTIL_SS.GETABSDURDAYS(PAAT.ABSENCE_ATTENDANCE_TYPE_ID, PAA.BUSINESS_GROUP_ID, PAA.CREATION_DATE, PAA.PERSON_ID, PAA.DATE_PROJECTED_START, PAA.DATE_PROJECTED_END, PAA.TIME_PROJECTED_START, PAA.TIME_PROJECTED_END)) ABSENCE_DAYS FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAAT, PER_ABS_ATTENDANCE_TYPES_TL PAATTL, HR_LOOKUPS FCL WHERE PAA.PERSON_ID = :1 AND PAA.BUSINESS_GROUP_ID + 0 = :2 AND PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAAT.ABSENCE_ATTENDANCE_TYPE_ID AND PAAT.ABSENCE_ATTENDANCE_TYPE_ID = PAATTL.ABSENCE_ATTENDANCE_TYPE_ID AND PAATTL.LANGUAGE = USERENV('LANG') AND FCL.LOOKUP_TYPE(+) = 'ABSENCE_CATEGORY' AND PAAT.ABSENCE_CATEGORY = FCL.LOOKUP_CODE(+) AND ((HR_API.RETURN_LEGISLATION_CODE(PAAT.BUSINESS_GROUP_ID) = 'GB' AND NVL(PAAT.ABSENCE_CATEGORY, '#') NOT IN ('M', 'GB_PAT_ADO', 'GB_PAT_BIRTH', 'GB_ADO')) OR (HR_API.RETURN_LEGISLATION_CODE(PAAT.BUSINESS_GROUP_ID) <> 'GB' AND NVL(PAAT.ABSENCE_CATEGORY, '#') NOT IN ('GB_PAT_ADO', 'GB_PAT_BIRTH', 'GB_ADO'))) AND NOT EXISTS (SELECT 'e' FROM HR_API_TRANSACTIONS T WHERE T.SELECTED_PERSON_ID = PAA.PERSON_ID AND T.CREATOR_PERSON_ID = NVL(:3, T.CREATOR_PERSON_ID) AND T.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES' AND T.TRANSACTION_REF_ID = PAA.ABSENCE_ATTENDANCE_ID AND NOT (HR_ABSUTIL_SS.GETABSENCETYPE(T.TRANSACTION_ID, NULL) IS NULL AND T.STATUS = 'W') AND T.STATUS NOT IN ('D', 'E')) AND DECODE(:6,'PLANNED','PLANNED','CONFIRMED_PLANNED') = DECODE(:6,NULL,'CONFIRMED_PLANNED','CONFIRMED','CONFIRMED_PLANNED',DECODE(PAA.DATE_START, NULL, 'PLANNED', 'CONFIRMED')) UNION ALL SELECT HR_ABSUTIL_SS.GETSTARTDATE(HAT.TRANSACTION_ID, NULL) START_DATE, HR_ABSUTIL_SS.GETENDDATE(HAT.TRANSACTION_ID, NULL) END_DATE, HR_ABSUTIL_SS.GETABSENCETYPE(HAT.TRANSACTION_ID, NULL) ABSENCE_TYPE, TO_NUMBER(HATS.INFORMATION5) ABSENCE_ATTENDANCE_TYPE_ID, HR_ABSUTIL_SS.GETABSENCECATEGORY(HAT.TRANSACTION_ID, NULL) ABSENCE_CATEGORY, HATS.INFORMATION6 ABSENCE_CATEGORY_CODE, HR_ABSUTIL_SS.GETABSENCEHOURSDURATION(HAT.TRANSACTION_ID, NULL) ABSENCE_HOURS, HR_ABSUTIL_SS.GETAPPROVALSTATUS(HAT.TRANSACTION_ID, NULL) APPROVAL_STATUS, HR_ABSUTIL_SS.GETAPPROVALSTATUSCODE(HAT.TRANSACTION_ID, NULL) APPROVAL_STATUS_CODE, HR_ABSUTIL_SS.GETABSENCESTATUS(HAT.TRANSACTION_ID, NULL) ABSENCE_STATUS, HATS.INFORMATION9 ABSENCE_STATUS_CODE, HR_ABSUTIL_SS.HASSUPPORTINGDOCUMENTS(HAT.TRANSACTION_ID, HAT.TRANSACTION_REF_ID) SUPPORTING_DOCUMENTS, HR_ABSUTIL_SS.ISCANCELALLOWED(HAT.TRANSACTION_ID, NULL, HAT.STATUS) CANCEL_ICON, HR_ABSUTIL_SS.ISCONFIRMALLOWED(HAT.TRANSACTION_ID, NULL) CONFIRM_ICON, HR_ABSUTIL_SS.ISUPDATEALLOWED(HAT.TRANSACTION_ID, NULL, HAT.STATUS) UPDATE_ICON, NULL DETAILS_ICON, HAT.TRANSACTION_REF_ID ABSENCE_ATTENDANCE_ID, HAT.TRANSACTION_ID TRANSACTION_ID, TO_CHAR(HAT.TRANSACTION_REF_ID || '_' || HAT.TRANSACTION_ID) SUPPORTINGDOCKEY, HR_ABSUTIL_SS.GETABSENCEDAYSDURATION(HAT.TRANSACTION_ID, NULL) ABSENCE_DAYS FROM HR_API_TRANSACTIONS HAT, HR_API_TRANSACTION_STEPS HATS WHERE HAT.TRANSACTION_REF_TABLE = 'PER_ABSENCE_ATTENDANCES' AND HAT.TRANSACTION_GROUP = 'ABSENCE_MGMT' AND HAT.TRANSACTION_IDENTIFIER = 'ABSENCES' AND HAT.TRANSACTION_REF_ID IS NOT NULL AND HAT.SELECTED_PERSON_ID = :4 AND HAT.CREATOR_PERSON_ID = NVL(:5, HAT.CREATOR_PERSON_ID) AND HAT.TRANSACTION_ID = HATS.TRANSACTION_ID(+) AND HAT.STATUS NOT IN ('D', 'E') AND NOT (HR_ABSUTIL_SS.GETABSENCETYPE(HAT.TRANSACTION_ID, NULL) IS NULL AND HAT.STATUS = 'W') AND DECODE(:6,'PLANNED','PLANNED','CONFIRMED_PLANNED') = DECODE(:6,NULL,'CONFIRMED_PLANNED','CONFIRMED','CONFIRMED_PLANNED',HATS.INFORMATION9) ORDER BY START_DATE DESC) QRSLT WHERE (( ABSENCE_ATTENDANCE_TYPE_ID = :7 )) ORDER BY START_DATE DESC
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
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:2850)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1838)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
14 more bugmates

Know the solutions? Share your knowledge to help other developers to debug faster.