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, 2 years 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)