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 freelists.org by Unknown author, 1 year ago
||' - '|| 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
via Oracle Community by 1030500, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT lookup_code fault_code FROM fnd_lookup_values flv WHERE lookup_type = 'XXCC_DR_WRNTY_LINKING_DETS' AND attribute2 = :1 AND
via Oracle Community by 541048, 1 year ago
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
via Oracle Community by bmn, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT CASE WHEN pce.attribute1 = 'Y' THEN 1 ELSE 0 END ) is_yes, FROM per_all_people_f ppf, per_competences pce WHERE ppf.person_id = pce.person_id (+) AND TRUNC(SYSDATE) BETWEEN ppf.effective_start_date AND NVL(ppf.effective_end_date, SYSDATE) AND ppf.person_id = :1
via Oracle Community by 936194, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT EXA.SEGMENT5 ACCOUNT_NAME , EXA.SEGMENT4 ACCOUNT_NUMBER , EXA.SEGMENT3 SORT_CODE , HL.MEANING BANK_NAME , EXA.SEGMENT2 BRANCH
via Oracle Community by 781391, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: ??????? SQL ?????: select column1, column2 from table t where t.id = :1 and t.name = :2
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)