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 Asmirnov-Oracle, 1 year ago
cchist ,AP_CARD_PROGRAMS_ALL cp WHERE pafe.job_id = jbt.job_id(+) ... AND (cchist.record_status = 'ACTIVE' OR cchist.record_status = 'APPROVED' OR cchist.record_status = 'PENDING') ORDER BY 2) QRSLT WHERE (PERSONID = :1 AND ( UPPER(EmployeeName) like
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM (SELECT 'Y' SelectFlag,
pere.full_name EmployeeName,
pafe.assignment_number EmployeeNumber,
jbt.name Jobtitle,
pers.full_name SupervisorName,
pafs.assignment_number SupervisorNumber,
hou.name Department,
pere.person_id PersonId
FROM PER_JOBS_TL jbt
,PER_PEOPLE_F pere
,PER_PEOPLE_F pers
,HR_ORGANIZATION_UNITS hou
,PER_ASSIGNMENTS_F pafe
,PER_ASSIGNMENTS_F pafs
,tvap.TVAP_OIE_CARD_MANAGE_HIST cchist
,AP_CARD_PROGRAMS_ALL cp
WHERE pafe.job_id = jbt.job_id(+)
...
AND (cchist.record_status = 'ACTIVE' OR cchist.record_status = 'APPROVED' OR cchist.record_status = 'PENDING')
ORDER BY 2) QRSLT WHERE (PERSONID = :1 AND ( UPPER(EmployeeName) like UPPER(:1) AND (EmployeeName like :2 OR EmployeeName like :3 OR EmployeeName like :4 OR EmployeeName like :5))) ORDER BY EmployeeName ASC
...     at TVA.oracle.apps.tvap.ccw.webui.CheckOwnerSearchCO.processFormRequest(CheckOwnerSearchCO.java:83)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processFormRequest(Unknown Source)