oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99') and op.organization_id(+) = wo.organization_id) QRSLT WHERE (ft_num like upper(?) and nvl(upper(project),'%') like upper(?) and status like ? and nvl(upper(wip_entity_name),'%') like upper(?) and vendor_id = ? and trunc(need_by_date) >= nvl(?,trunc(need_by_date)) and trunc(need_by_date) <= nvl(?,trunc(need_by_date))) ORDER BY HEADER_ID 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 Asmirnov-Oracle, 1 year ago
') and op.organization_id(+) = wo.organization_id) QRSLT WHERE (ft_num like upper(?) and nvl(upper(project),'%') like upper(?) and status like ? and nvl(upper(wip_entity_name),'%') like upper(?) and vendor_id = ? and trunc(need_by_date) >= nvl(?,trunc(need_by_date)) and trunc(need_by_date) <= nvl(?,trunc(need_by_date))) ORDER BY HEADER_ID desc
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
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 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 961553, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT item_number, item_description, inventory_item_id, billing_type, mtl_transactions_enabled_flag, recovered_part_disp_code
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
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT FTHeaderEO.HEADER_ID, FTHeaderEO.SUPPLIER, ………………………………… and NVL(op.operation_seq_num,'-99') = NVL(FTHeaderEO.operation_seq_num,'-99') and op.organization_id(+) = wo.organization_id) QRSLT WHERE (ft_num like upper(?) and nvl(upper(project),'%') like upper(?) and status like ? and nvl(upper(wip_entity_name),'%') like upper(?) and vendor_id = ? and trunc(need_by_date) >= nvl(?,trunc(need_by_date)) and trunc(need_by_date) <= nvl(?,trunc(need_by_date))) ORDER BY HEADER_ID desc
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, 2 years 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, 2 years ago
14 more bugmates

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