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 528560, 1 year ago
(nfexceldataloadheadereo.file_status, 'NEW', 'ProcessEnabled', 'ProcessDisabled' ) AS process_switcher, CASE WHEN (nfexceldataloadheadereo.file_status = 'PROCESSED' ) AND (nfexceldataloadheadereo.error_count <> 0) THEN 'ErrorEnabled' ELSE 'ErrorDisabled' END
via Oracle Community by 868733, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select customer_id from XXCUR_TRADE_CONSOL_SUMMARY
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 584085, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT feb.entity_id, rel.parent_entity_id, fetl.entity_name, pfetl.entity_name parent_entity_name, ccytl.currency_code, ccytl.name AS
via Oracle Community by 881169, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select 'Select_flag', poh.po_num, poh.comments, poh.creation_date, poh.po_release_id, to_char(null) agent_name, poh.currency_code, to_char(0
via Oracle Community by 1010599, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select hp.party_name, hp.party_id as party_id, hp.duns_number_c as duns, pv.vendor_id, pv.vendor_name, decode(pv.organization_type_lookup_code
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT nfexceldataloadheadereo.batch_number,
nfexceldataloadheadereo.file_name,
nfexceldataloadheadereo.program_name,
nfexceldataloadheadereo.row_count,
nfexceldataloadheadereo.column_count,
nfexceldataloadheadereo.error_count,
nfexceldataloadheadereo.file_status,
nfexceldataloadheadereo.file_load_date,
nfexceldataloadheadereo.created_by,
nfexceldataloadheadereo.creation_date,
nfexceldataloadheadereo.last_updated_by,
nfexceldataloadheadereo.last_update_date,
nfexceldataloadheadereo.last_update_login,
DECODE (nfexceldataloadheadereo.file_status,
'NEW', 'DeleteEnabled',
'DeleteDisabled'
) AS delete_switcher,
DECODE (nfexceldataloadheadereo.file_status,
'NEW', 'ProcessEnabled',
'ProcessDisabled'
) AS process_switcher,
CASE
WHEN (nfexceldataloadheadereo.file_status = 'PROCESSED'
)
AND (nfexceldataloadheadereo.error_count <> 0)
THEN 'ErrorEnabled'
ELSE 'ErrorDisabled'
END error_switcher,
(CASE
WHEN ( nfexceldataloadheadereo.file_status = 'PROCESSED'
AND ((SELECT COUNT (1)
FROM po_headers_all
WHERE NVL (attribute3, '@@@') =
nfexceldataloadheadereo.batch_number) <> 0)
)
THEN 'TransactionsEnabled'
ELSE 'TransactionsDisabled'
END
) transaction_switcher,
(SELECT user_name
FROM fnd_user
WHERE user_id = nfexceldataloadheadereo.created_by) user_name
FROM nf_excel_data_load_header nfexceldataloadheadereo) QRSLT WHERE (( BATCH_NUMBER like :1 ))	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:891)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1145)	at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1408)	at oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(OAPageBean.java:2679)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1682)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:508)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:429)