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

Samebug tips0

We couldn't find tips for this exception.

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

Stack trace

  • 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(OAException.java:891)

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,
9 more bugmates