oracle.apps.fnd.framework.OAException: 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, inp.notification_preference_id, ppf.person_id, ppf.effective_start_date, ppf.effective_end_date, ROWNUM AS rownumber, pov.vendor_id, pov.vendor_name, inp.creation_date, NULL AS selectflag, (SELECT meaning FROM hr_lookups WHERE lookup_code = ircreferralinfoeo.source_type AND lookup_type = 'REC_TYPE') AS sourcetype, DECODE (ircreferralinfoeo.source_type, 'ER', (SELECT full_name FROM per_all_people_f ppf3 WHERE ppf3.person_id = ircreferralinfoeo.source_person_id AND SYSDATE BETWEEN ppf3.effective_start_date AND ppf3.effective_end_date), ircreferralinfoeo.source_name ) AS sourcename FROM irc_notification_preferences inp, irc_documents doc, per_addresses addr, per_all_people_f ppf, po_vendors pov, irc_referral_info ircreferralinfoeo WHERE trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND doc.person_id = inp.person_id AND inp.person_id = addr.person_id(+) AND NVL (inp.address_id, DECODE (addr.address_type(+), 'REC', addr.address_id(+), -1)) = addr.address_id(+) AND trunc(sysdate) BETWEEN addr.date_from(+) AND NVL (addr.date_to(+), sysdate) AND doc.person_id = ppf.person_id AND doc.TYPE IN ('RESUME', 'AUTO_RESUME') AND doc.end_date IS NULL AND EXISTS (SELECT NULL FROM per_people_f ppfs WHERE ppfs.person_id = doc.person_id) AND contains (doc.character_doc,:1,1) >0 AND ( (inp.agency_id = fnd_profile.VALUE ('IRC_AGENCY_NAME')) OR ( fnd_profile.VALUE ('IRC_AGENCY_NAME') IS NULL AND inp.allow_access = 'Y' ) ) AND inp.agency_id = pov.vendor_id(+) AND ppf.party_id = ircreferralinfoeo.object_id(+) AND SYSDATE BETWEEN ircreferralinfoeo.start_date(+) AND ircreferralinfoeo.end_date(+) ORDER BY score (1) DESC

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 Oracle Community by 877023, 1 year ago
.effective_start_date AND ppf3.effective_end_date), ircreferralinfoeo.source_name ) AS sourcename FROM irc_notification_preferences inp, irc_documents doc, per_addresses addr, per_all_people_f ppf, po_vendors pov, irc_referral_info ircreferralinfoeo WHERE trunc
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 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 839403, 1 year ago
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
via Oracle Community by user10648285, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT PoVendors.VENDOR_ID AS SUPPLIER_ID, PoVendorSitesAll.VENDOR_SITE_ID AS SUPPLIER_SITE_ID, PoVendorContacts.VENDOR_CONTACT_ID AS
via Oracle Community by 807913, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT Vac.VACANCY_ID, Vac.DATE_FROM, Vac.NAME, Vac.DATE_TO, Vac.DESCRIPTION, Vac.NUMBER_OF_OPENINGS, Vac.LAST_UPDATE_DATE, Vac.CREATION_DATE, Job.NAME AS
oracle.apps.fnd.framework.OAException: 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, inp.notification_preference_id, ppf.person_id, ppf.effective_start_date, ppf.effective_end_date, ROWNUM AS rownumber, pov.vendor_id, pov.vendor_name, inp.creation_date, NULL AS selectflag, (SELECT meaning FROM hr_lookups WHERE lookup_code = ircreferralinfoeo.source_type AND lookup_type = 'REC_TYPE') AS sourcetype, DECODE (ircreferralinfoeo.source_type, 'ER', (SELECT full_name FROM per_all_people_f ppf3 WHERE ppf3.person_id = ircreferralinfoeo.source_person_id AND SYSDATE BETWEEN ppf3.effective_start_date AND ppf3.effective_end_date), ircreferralinfoeo.source_name ) AS sourcename FROM irc_notification_preferences inp, irc_documents doc, per_addresses addr, per_all_people_f ppf, po_vendors pov, irc_referral_info ircreferralinfoeo WHERE trunc(sysdate) BETWEEN ppf.effective_start_date AND ppf.effective_end_date AND doc.person_id = inp.person_id AND inp.person_id = addr.person_id(+) AND NVL (inp.address_id, DECODE (addr.address_type(+), 'REC', addr.address_id(+), -1)) = addr.address_id(+) AND trunc(sysdate) BETWEEN addr.date_from(+) AND NVL (addr.date_to(+), sysdate) AND doc.person_id = ppf.person_id AND doc.TYPE IN ('RESUME', 'AUTO_RESUME') AND doc.end_date IS NULL AND EXISTS (SELECT NULL FROM per_people_f ppfs WHERE ppfs.person_id = doc.person_id) AND contains (doc.character_doc,:1,1) >0 AND ( (inp.agency_id = fnd_profile.VALUE ('IRC_AGENCY_NAME')) OR ( fnd_profile.VALUE ('IRC_AGENCY_NAME') IS NULL AND inp.allow_access = 'Y' ) ) AND inp.agency_id = pov.vendor_id(+) AND ppf.party_id = ircreferralinfoeo.object_id(+) AND SYSDATE BETWEEN ircreferralinfoeo.start_date(+) AND ircreferralinfoeo.end_date(+) ORDER BY score (1) DESC
at oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 5 days 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.