oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, paa.date_start, paa.date_end, paa.absence_days, paat.name, paat.absence_attendance_type_id, paa.absence_attendance_id abs_attd_id, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),AbsAdjHeaderEO.status,'Actioned') Disp_Status, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),decode( AbsAdjHeaderEO.status,'Awaiting Manager Approval',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0),'Submitted',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0), 0),1) Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCES paa, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE paa.absence_attendance_type_id=paat.absence_attendance_type_id and AbsAdjHeaderEO.CUR_ABS_ATTD_ID(+) = paa.absence_attendance_id and ((paa.person_id=:1 and paa.date_start between :2 and nvl(:3,sysdate) and paa.date_end between :4 and nvl(:5,sysdate) and paa.ABSENCE_ATTENDANCE_TYPE_ID=nvl(:6,paa.ABSENCE_ATTENDANCE_TYPE_ID)) or paa.absence_attendance_id=:7) and nvl(paa.date_end,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) union SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, AbsAdjHeaderEO.CUR_ABS_START_DATE date_start, AbsAdjHeaderEO.CUR_ABS_END_DATE date_end, AbsAdjHeaderEO.CUR_ABS_DURATION absence_days, paat.name name, null absence_attendance_type_id, null abs_attd_id, 'Actioned' Disp_Status, 1 Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE AbsAdjHeaderEO.CUR_ABS_TYPE_ID=paat.absence_attendance_type_id and ((AbsAdjHeaderEO.EMP_ID=:1 and AbsAdjHeaderEO.CUR_ABS_START_DATE between :2 and nvl(:3,sysdate) and AbsAdjHeaderEO.CUR_ABS_END_DATE between :4 and nvl(:5,sysdate) and AbsAdjHeaderEO.CUR_ABS_TYPE_ID=nvl(:6,AbsAdjHeaderEO.CUR_ABS_TYPE_ID)) or AbsAdjHeaderEO.CUR_ABS_ATTD_ID=:7) and nvl(AbsAdjHeaderEO.CUR_ABS_END_DATE,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) and not exists (select 1 from PER_ABSENCE_ATTENDANCES where absence_attendance_id=AbsAdjHeaderEO.CUR_ABS_ATTD_ID)) QRSLT ORDER BY CUR_ABS_START_DATE,CUR_ABS_END_DATE

Oracle Community | 802240 | 5 years ago
  1. 0

    : Missing IN or OUT parameter at index:: 8 at

    Oracle Community | 5 years ago | 802240
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, paa.date_start, paa.date_end, paa.absence_days, paat.name, paat.absence_attendance_type_id, paa.absence_attendance_id abs_attd_id, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),AbsAdjHeaderEO.status,'Actioned') Disp_Status, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),decode( AbsAdjHeaderEO.status,'Awaiting Manager Approval',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0),'Submitted',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0), 0),1) Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCES paa, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE paa.absence_attendance_type_id=paat.absence_attendance_type_id and AbsAdjHeaderEO.CUR_ABS_ATTD_ID(+) = paa.absence_attendance_id and ((paa.person_id=:1 and paa.date_start between :2 and nvl(:3,sysdate) and paa.date_end between :4 and nvl(:5,sysdate) and paa.ABSENCE_ATTENDANCE_TYPE_ID=nvl(:6,paa.ABSENCE_ATTENDANCE_TYPE_ID)) or paa.absence_attendance_id=:7) and nvl(paa.date_end,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) union SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, AbsAdjHeaderEO.CUR_ABS_START_DATE date_start, AbsAdjHeaderEO.CUR_ABS_END_DATE date_end, AbsAdjHeaderEO.CUR_ABS_DURATION absence_days, paat.name name, null absence_attendance_type_id, null abs_attd_id, 'Actioned' Disp_Status, 1 Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE AbsAdjHeaderEO.CUR_ABS_TYPE_ID=paat.absence_attendance_type_id and ((AbsAdjHeaderEO.EMP_ID=:1 and AbsAdjHeaderEO.CUR_ABS_START_DATE between :2 and nvl(:3,sysdate) and AbsAdjHeaderEO.CUR_ABS_END_DATE between :4 and nvl(:5,sysdate) and AbsAdjHeaderEO.CUR_ABS_TYPE_ID=nvl(:6,AbsAdjHeaderEO.CUR_ABS_TYPE_ID)) or AbsAdjHeaderEO.CUR_ABS_ATTD_ID=:7) and nvl(AbsAdjHeaderEO.CUR_ABS_END_DATE,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) and not exists (select 1 from PER_ABSENCE_ATTENDANCES where absence_attendance_id=AbsAdjHeaderEO.CUR_ABS_ATTD_ID)) QRSLT ORDER BY CUR_ABS_START_DATE,CUR_ABS_END_DATE
  2. 0

    Extended VO errors after upgrading to 12.1.3

    Oracle Community | 3 years ago | elcaro
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27022: Failed to load value at index 23 with java object of type java.lang.String due to java.sql.SQLException.
  3. 0

    SQLStmtException: JBO-27122: SQL error during statement preparation

    Oracle Community | 5 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num, msi.segment1 item_num, pol.vendor_product_num, pol.item_description, pol.unit_meas_lookup_code, pol.quantity, pol.unit_price, pol.quantity * pol.unit_price total, poh.segment1 po_num, poh.currency_code, pol.item_id, fsp.inventory_organization_id, msi.segment1 segment1, pol.from_header_id, pola.closed_code, pola.cancel_flag, pola.closed_flag, pola.user_hold_flag, pol.attribute1, pol.attribute2, pol.attribute3, pol.attribute4, pol.attribute5, pol.attribute6, pol.attribute7, pol.attribute8, pol.attribute9, pol.attribute10, pol.attribute11, pol.attribute12, pol.attribute13, pol.attribute14, pol.attribute15, pol.attribute_category, pol.note_to_vendor, poh2.segment1 contract_num, pol.item_revision, pol.ussgl_transaction_code, NULL un_number, NULL hazard_class, pol.quantity_committed, pol.committed_amount, pol.expiration_date, NVL (pocr.new_price, pol.unit_price) new_price, NVL (pocr.new_supplier_part_number, pol.vendor_product_num ) new_supplier_part_number, pocr.request_status, 0 viewshipments, 'SItemType', 'PriceType', 'LineStatus', NVL (pos_get.get_item_config (pol.item_id, fsp.inventory_organization_id ), 'F' ) conf_flag, NULL ga_number, pocr.request_reason, DECODE (pocr.request_status, NULL, polc.displayed_field, fnd_message.get_string ('POS', 'POS_PENDING_CHANGE') ) line_display, pol.hazard_class_id, pol.un_number_id, NULL conf_details, 'REASON_TYPE', pol.job_id, pol.contractor_first_name, pol.contractor_last_name, 'LINE_PRICE_DIFF_TYPE', polt.order_type_lookup_code line_type, pj.NAME job_title, poh.global_agreement_flag, poh.type_lookup_code, 'ENTITY_TYPE', polt.line_type line_type_dsp, pa.job_description, NULL contractor_name, pol.amount line_amount, pol.supplier_ref_number, FROM po_lines_archive_all pol, po_lines_all pola, po_headers_all poh, mtl_system_items_kfv msi, financials_system_params_all fsp, po_lookup_codes polc, po_change_requests pocr, po_line_types polt, per_jobs pj, po_job_associations pa, po_headers_all poh2 WHERE poh.po_header_id = pol.po_header_id AND poh.po_header_id = pola.po_header_id AND poh.po_header_id = poh.po_header_id + 0 AND pol.contract_id = poh2.po_header_id(+) AND pol.latest_external_flag = 'Y' AND pol.po_line_id = pola.po_line_id AND pol.line_type_id = polt.line_type_id AND pol.job_id = pj.job_id(+) AND pol.job_id = pa.job_id(+) AND pol.item_id = msi.inventory_item_id(+) AND fsp.inventory_organization_id = NVL (msi.organization_id, fsp.inventory_organization_id) AND fsp.org_id(+) = poh.org_id AND polc.lookup_code = NVL (pola.closed_code, 'OPEN') AND polc.lookup_type = 'DOCUMENT STATE' AND pol.po_header_id = pocr.document_header_id(+) AND pol.po_line_id = pocr.document_line_id(+) AND pocr.request_level(+) = 'LINE' AND pocr.change_active_flag(+) = 'Y') QRSLT WHERE (PO_LINE_ID in (select PO_LINE_ID from po_line_locations_all where PO_HEADER_ID = :1 and PO_RELEASE_ID = :2)) ORDER BY LINE_NUM
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    ORA-00604: error occurred at recursive SQL level 2;

    Oracle Community | 5 years ago | 884536
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT pol.po_header_id, pol.po_line_id, pol.line_num, msi.segment1 item_num, pol.vendor_product_num, pol.item_description, pol.unit_meas_lookup_code, pol.quantity, pol.unit_price, pol.quantity * pol.unit_price total, poh.segment1 po_num, poh.currency_code, pol.item_id, fsp.inventory_organization_id, msi.segment1 segment1, pol.from_header_id, pola.closed_code, pola.cancel_flag, pola.closed_flag, pola.user_hold_flag, pol.attribute1, pol.attribute2, pol.attribute3, pol.attribute4, pol.attribute5, pol.attribute6, pol.attribute7, pol.attribute8, pol.attribute9, pol.attribute10, pol.attribute11, pol.attribute12, pol.attribute13, pol.attribute14, pol.attribute15, pol.attribute_category, pol.note_to_vendor, poh2.segment1 contract_num, pol.item_revision, pol.ussgl_transaction_code, NULL un_number, NULL hazard_class, pol.quantity_committed, pol.committed_amount, pol.expiration_date, NVL (pocr.new_price, pol.unit_price) new_price, NVL (pocr.new_supplier_part_number, pol.vendor_product_num ) new_supplier_part_number, pocr.request_status, 0 viewshipments, 'SItemType', 'PriceType', 'LineStatus', NVL (pos_get.get_item_config (pol.item_id, fsp.inventory_organization_id ), 'F' ) conf_flag, NULL ga_number, pocr.request_reason, DECODE (pocr.request_status, NULL, polc.displayed_field, fnd_message.get_string ('POS', 'POS_PENDING_CHANGE') ) line_display, pol.hazard_class_id, pol.un_number_id, NULL conf_details, 'REASON_TYPE', pol.job_id, pol.contractor_first_name, pol.contractor_last_name, 'LINE_PRICE_DIFF_TYPE', polt.order_type_lookup_code line_type, pj.NAME job_title, poh.global_agreement_flag, poh.type_lookup_code, 'ENTITY_TYPE', polt.line_type line_type_dsp, pa.job_description, NULL contractor_name, pol.amount line_amount, pol.supplier_ref_number, DECODE (pol.po_line_id, pol.line_num), 0, NULL, '@' ) archived_attachment FROM po_lines_archive_all pol, po_lines_all pola, po_headers_all poh, mtl_system_items_kfv msi, financials_system_params_all fsp, po_lookup_codes polc, po_change_requests pocr, po_line_types polt, per_jobs pj, po_job_associations pa, po_headers_all poh2 WHERE poh.po_header_id = pol.po_header_id AND poh.po_header_id = pola.po_header_id AND poh.po_header_id = poh.po_header_id + 0 AND pol.contract_id = poh2.po_header_id(+) AND pol.latest_external_flag = 'Y' AND pol.po_line_id = pola.po_line_id AND pol.line_type_id = polt.line_type_id AND pol.job_id = pj.job_id(+) AND pol.job_id = pa.job_id(+) AND pol.item_id = msi.inventory_item_id(+) AND fsp.inventory_organization_id = NVL (msi.organization_id, fsp.inventory_organization_id) AND fsp.org_id(+) = poh.org_id AND polc.lookup_code = NVL (pola.closed_code, 'OPEN') AND polc.lookup_type = 'DOCUMENT STATE' AND pol.po_header_id = pocr.document_header_id(+) AND pol.po_line_id = pocr.document_line_id(+) AND pocr.request_level(+) = 'LINE' AND pocr.change_active_flag(+) = 'Y') QRSLT WHERE (PO_HEADER_ID = :1) ORDER BY LINE_NUM
  6. 0

    EO Substitution

    Oracle Community | 1 decade ago | 542163
    oracle.apps.fnd.framework.OAException: oracle.jbo.PersistenceException: JBO-26038: Cannot find an entity usage for entity Perc2382PerQualificationsEOEx in view link definition IrcCandidateEduQualVL, view link end IrcCandidateEduQualVO.

    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 AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, paa.date_start, paa.date_end, paa.absence_days, paat.name, paat.absence_attendance_type_id, paa.absence_attendance_id abs_attd_id, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),AbsAdjHeaderEO.status,'Actioned') Disp_Status, decode((nvl(to_char(AbsAdjHeaderEO.CUR_ABS_START_DATE,'DD-MON-YYYY'),to_char(paa.DATE_START,'DD-MON-YYYY'))||nvl(to_char(AbsAdjHeaderEO.CUR_ABS_END_DATE,'DD-MON-YYYY'),to_char(paa.DATE_END,'DD-MON-YYYY')) ||nvl(AbsAdjHeaderEO.CUR_ABS_DURATION,paa.ABSENCE_DAYS)||nvl(AbsAdjHeaderEO.CUR_ABS_TYPE_ID,paa.ABSENCE_ATTENDANCE_TYPE_ID)),(to_char(paa.DATE_START,'DD-MON-YYYY')||to_char(paa.DATE_END,'DD-MON-YYYY') ||paa.ABSENCE_DAYS||paa.ABSENCE_ATTENDANCE_TYPE_ID),decode( AbsAdjHeaderEO.status,'Awaiting Manager Approval',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0),'Submitted',decode(fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO'),'Y',1,0), 0),1) Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCES paa, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE paa.absence_attendance_type_id=paat.absence_attendance_type_id and AbsAdjHeaderEO.CUR_ABS_ATTD_ID(+) = paa.absence_attendance_id and ((paa.person_id=:1 and paa.date_start between :2 and nvl(:3,sysdate) and paa.date_end between :4 and nvl(:5,sysdate) and paa.ABSENCE_ATTENDANCE_TYPE_ID=nvl(:6,paa.ABSENCE_ATTENDANCE_TYPE_ID)) or paa.absence_attendance_id=:7) and nvl(paa.date_end,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) union SELECT AbsAdjHeaderEO.SUBMISSION_ID, AbsAdjHeaderEO.MGR_ASSGN_ID, AbsAdjHeaderEO.MGR_POS_ID, AbsAdjHeaderEO.EMP_ID, AbsAdjHeaderEO.EMP_ASSGN_ID, AbsAdjHeaderEO.CUR_ABS_START_DATE, AbsAdjHeaderEO.CUR_ABS_END_DATE, AbsAdjHeaderEO.CUR_ABS_ATTD_ID, AbsAdjHeaderEO.CUR_ABS_TYPE_ID, AbsAdjHeaderEO.CUR_ABS_DURATION, AbsAdjHeaderEO.REASON_FOR_CHANGE, AbsAdjHeaderEO.STATUS, AbsAdjHeaderEO.CREATED_BY, AbsAdjHeaderEO.CREATION_DATE, AbsAdjHeaderEO.LAST_UPDATED_BY, AbsAdjHeaderEO.LAST_UPDATED_DATE, AbsAdjHeaderEO.CUR_ABS_START_DATE date_start, AbsAdjHeaderEO.CUR_ABS_END_DATE date_end, AbsAdjHeaderEO.CUR_ABS_DURATION absence_days, paat.name name, null absence_attendance_type_id, null abs_attd_id, 'Actioned' Disp_Status, 1 Disable_Reason_Flag, 1 Disable_Adj_Cha_Reason FROM NRHR.XXNR_ABS_ADJ_HEADER AbsAdjHeaderEO, PER_ABSENCE_ATTENDANCE_TYPES paat WHERE AbsAdjHeaderEO.CUR_ABS_TYPE_ID=paat.absence_attendance_type_id and ((AbsAdjHeaderEO.EMP_ID=:1 and AbsAdjHeaderEO.CUR_ABS_START_DATE between :2 and nvl(:3,sysdate) and AbsAdjHeaderEO.CUR_ABS_END_DATE between :4 and nvl(:5,sysdate) and AbsAdjHeaderEO.CUR_ABS_TYPE_ID=nvl(:6,AbsAdjHeaderEO.CUR_ABS_TYPE_ID)) or AbsAdjHeaderEO.CUR_ABS_ATTD_ID=:7) and nvl(AbsAdjHeaderEO.CUR_ABS_END_DATE,to_date('31-DEC-4712','DD-MON-YYYY'))< SYSDATE and ( (fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_TO') ='Y' and nvl(AbsAdjHeaderEO.status,'Dummy') <>'Deleted by TO') or fnd_profile.value('XXNR_USE_ABSENCE_MANAGEMENT_MANAGER')='Y' ) and not exists (select 1 from PER_ABSENCE_ATTENDANCES where absence_attendance_id=AbsAdjHeaderEO.CUR_ABS_ATTD_ID)) QRSLT ORDER BY CUR_ABS_START_DATE,CUR_ABS_END_DATE

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAViewObjectImpl.invokeMethod
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
      2. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
      3. oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
      4. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)
      5. oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)
      6. oracle.apps.fnd.framework.server.OAViewObjectImpl.invokeMethod(OAViewObjectImpl.java:1136)
      6 frames
    3. networkrail.oracle.apps
      AbsAdjustmentsCO.processFormRequest
      1. networkrail.oracle.apps.absadj.webui.AbsAdjustmentsCO.processFormRequest(AbsAdjustmentsCO.java:257)
      1 frame
    4. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:819)
      2. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      3. oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processFormRequest(OAPageLayoutHelper.java:1205)
      4. oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processFormRequest(OAPageLayoutBean.java:1579)
      5. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
      6. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
      7. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
      8. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      9. oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processFormRequest(OAFormBean.java:395)
      10. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:1031)
      11. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequestChildren(OAWebBeanHelper.java:997)
      12. oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(OAWebBeanHelper.java:852)
      13. oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processFormRequest(OAWebBeanContainerHelper.java:385)
      14. oracle.apps.fnd.framework.webui.beans.OABodyBean.processFormRequest(OABodyBean.java:363)
      15. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2974)
      16. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
      17. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
      18. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)
      18 frames