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

Oracle Community | Bipin Behari Sethy | 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

    java.sql.SQLException: Missing IN or OUT parameter at index:: 8

    Oracle Community | 7 years ago | Bipin Behari Sethy
    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
  2. 0

    OA Exception: NullPointerException

    Oracle Community | 8 years ago | 610323
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  3. 0

    Getting Error when run the custom page in Jdeveloper 10.1.3

    Oracle Community | 7 years ago | bmn
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.apps.fnd.framework.webui.beans.OARawTextBean
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Controller Extension Problem

    Oracle Community | 7 years ago | bmn
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: oracle.apps.fnd.framework.webui.beans.OARawTextBean
  6. 0

    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at

    Oracle Community | 7 years ago | 779216
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException

    11 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 * 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2850)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1838)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:536)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:424)
      7 frames