oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select effective_date||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '|| action_information14||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:2||'','CHECK')||' '|| check_count payslip_choice, action_context_id, person_id, effective_date from pay_emp_payslip_action_info_v where person_id = :3 and effective_date >= to_date(:4 ,'YYYY/MM/DD')) QRSLT WHERE (pay_us_employee_payslip_web.get_term_info( 0,person_id,action_context_id) = 'Y') ORDER BY effective_date desc

freelists.org | 5 months ago
  1. 0

    RE: ORA-1801 Intermittently in OA Pages - ora-apps-dba - FreeLists

    freelists.org | 5 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select effective_date||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '|| action_information14||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:2||'','CHECK')||' '|| check_count payslip_choice, action_context_id, person_id, effective_date from pay_emp_payslip_action_info_v where person_id = :3 and effective_date >= to_date(:4 ,'YYYY/MM/DD')) QRSLT WHERE (pay_us_employee_payslip_web.get_term_info( 0,person_id,action_context_id) = 'Y') ORDER BY effective_date desc
  2. 0

    Migrating OA framework on Test Instance

    Oracle Community | 1 decade ago | 523315
    oracle.apps.fnd.framework.OAException: oracle.adf.mds.exception.MDSRuntimeException: Unable to find component with absolute reference = /avz/oracle/apps/sta/lov/webui/ServicePeriodLovRN, XML Path = null. Please verify that the reference is valid and the definition of the component exists either on the File System or in the MDS Repository.
  3. Speed up your debug routine!

    Automated exception search integrated into your IDE

  4. 0

    URGENT! ArrayIndexOutOfBoundsException in Extended "EO based" VO

    Oracle Community | 9 years ago | 596029
    oracle.apps.fnd.framework.OAException: Application: FND, Message Name: FND_GENERIC_MESSAGE. Tokens: MESSAGE = java.lang.ArrayIndexOutOfBoundsException: 12;
  5. 0

    Searching on Transient Field of Extended LOV VO

    Oracle Community | 9 years ago | 541048
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT full_name, email_address,employee_num, to_char(employee_id), organization_name, business_group_name, hr_general.get_work_phone(employee_id) AS phone, hr_general.get_phone_number(employee_id, 'WF') AS fax from por_approver_lov_v p) QRSLT WHERE (( UPPER(XXAPPROVEREMPNUM) like :1 AND (XXAPPROVEREMPNUM like :2 OR XXAPPROVEREMPNUM like :3 OR XXAPPROVEREMPNUM like :4 OR XXAPPROVEREMPNUM like :5)))

    5 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 effective_date||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:1||'', 'JOB')||' '|| action_information14||' - '|| pay_us_employee_payslip_web.get_meaning_payslip_label(:2||'','CHECK')||' '|| check_count payslip_choice, action_context_id, person_id, effective_date from pay_emp_payslip_action_info_v where person_id = :3 and effective_date >= to_date(:4 ,'YYYY/MM/DD')) QRSLT WHERE (pay_us_employee_payslip_web.get_term_info( 0,person_id,action_context_id) = 'Y') ORDER BY effective_date desc

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAException.wrapperException
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)
      1 frame