oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select fu.user_name, ppf.full_name, HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID) POSITION_NAME, ppf.email_address from fnd_user fu, per_people_f ppf, per_assignments_f paf where ppf.person_id = fu.employee_id and ppf.person_id=paf.person_id and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date and fu.user_name :1 and employee_id in (select paf2.person_id from per_assignments_f paf1, per_assignments_f paf2 where paf1.person_id = (select distinct employee_id from fnd_user where user_name =:1 ) AND (paf2.position_id = paf1.position_id OR (paf2.position_id IN ( SELECT parent_position_id FROM PER_POS_STRUCTURE_ELEMENTS START WITH subordinate_position_id = paf1.position_id CONNECT BY subordinate_position_id = PRIOR parent_position_id and rownum <2 )))) order by HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID)) QRSLT WHERE (( UPPER(FNAME) like UPPER(:2) AND (FNAME like :3 OR FNAME like :4 OR FNAME like :5 OR FNAME like :6)))

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

Samebug tips

Do you know how to solve this issue? Write a tip to help other users and build your expert profile.

Solutions on the web

via Oracle Community by 839403, 1 year ago
.position_id OR (paf2.position_id IN ( SELECT parent_position_id FROM PER_POS_STRUCTURE_ELEMENTS START WITH subordinate_position_id = paf1.position_id CONNECT BY subordinate_position_id = PRIOR parent_position_id and rownum <2 )))) order by
via Oracle Community by user621385, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT paf1.full_name, paf1.last_name, paf1.first_name, paf1.email_address, nvl(paf1.employee_number,paf1.npw_number) AS employee_num
via Oracle Community by Renu Gupta, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /*+ FIRST_ROWS */ NULL AS SelectFlag, PPF.FULL_NAME AS PERSON_NAME, ADDR.DERIVED_LOCALE, ADDR.ADDRESS_ID, PHN.PHONE_NUMBER, PHN.PHONE_ID
via Oracle Community by 877023, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT score (1) AS score, doc.document_id, doc.file_name, doc.last_update_date, ppf.email_address, addr.derived_locale, addr.address_id, ppf.full_name
via Oracle Community by 646534, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select to_char(ppf.payroll_id) Payroll_id, ppf.payroll_name Payroll_name, pbg.name Business_group, pbg.business_group_id from pay_all_payrolls_f ppf
via Oracle Community by 882688, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT /* $Header: KeyFlexfield.java 120.8.12010000.3 2008/11/14 21:37:18 hgeorgi ship $ */ OTA_RESOURCE_DEFINITIONS.RESOURCE_DEFINITION_ID FLEX_CCID
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select fu.user_name, ppf.full_name, HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID) POSITION_NAME, ppf.email_address from fnd_user fu, per_people_f ppf, per_assignments_f paf where ppf.person_id = fu.employee_id and ppf.person_id=paf.person_id and trunc(sysdate) between ppf.effective_start_date and ppf.effective_end_date and trunc(sysdate) between paf.effective_start_date and paf.effective_end_date and fu.user_name :1 and employee_id in (select paf2.person_id from per_assignments_f paf1, per_assignments_f paf2 where paf1.person_id = (select distinct employee_id from fnd_user where user_name =:1 ) AND (paf2.position_id = paf1.position_id OR (paf2.position_id IN ( SELECT parent_position_id FROM PER_POS_STRUCTURE_ELEMENTS START WITH subordinate_position_id = paf1.position_id CONNECT BY subordinate_position_id = PRIOR parent_position_id and rownum <2 )))) order by HR_GENERAL.DECODE_POSITION_LATEST_NAME (paf.POSITION_ID)) QRSLT WHERE (( UPPER(FNAME) like UPPER(:2) AND (FNAME like :3 OR FNAME like :4 OR FNAME like :5 OR FNAME like :6)))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2978)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1875)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago
Samebug visitor profile picture
Unknown user
Once, 1 year ago

Write tip

Know the solutions? Share your knowledge to help other developers to debug faster.