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 844181, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT TO_CHAR (b.je_batch_id) JE_BATCH_ID, b.name BATCH_NAME, TO_CHAR (h.je_header_id) JE_HEADER_ID, h.name HEADER_NAME, h.je_source JE_SOURCE_NAME
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 user5425941, 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 667099, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select msi.secondary_inventory_name as SubInventoryName, msi.description as Description, msi.locator_type, msi.organization_id
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 541412, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: /* Formatted on 2008/05/22 13:19 (Formatter Plus v4.8.8) */ SELECT transaction_source, batch_name, expenditure_ending_date, employee_number, organization_name
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT TO_CHAR (b.je_batch_id) JE_BATCH_ID,
b.name BATCH_NAME,
TO_CHAR (h.je_header_id) JE_HEADER_ID,
h.name HEADER_NAME,
h.je_source JE_SOURCE_NAME,
src.user_je_source_name USER_JE_SOURCE_NAME,
h.je_category JE_CATEGORY_NAME,
cat.user_je_category_name USER_JE_CATEGORY_NAME,
h.doc_sequence_value DOC_SEQUENCE_VALUE,
h.default_effective_date HEADER_EFFECTIVE_DATE,
h.currency_code CURRENCY_CODE,
h.budget_version_id BUDGET_VERSION_ID,
h.encumbrance_type_id ENCUMBRANCE_TYPE_ID,
TO_CHAR (h.parent_je_header_id) PARENT_JE_HEADER_ID,
TO_CHAR (lines.je_line_num) LINE_NUM,
lines.effective_date LINE_EFFECTIVE_DATE,
lines.entered_dr LINE_ENTERED_DR,
lines.entered_cr LINE_ENTERED_CR,
lines.accounted_dr LINE_ACCOUNTED_DR,
lines.accounted_cr LINE_ACCOUNTED_CR,
lines.description LINE_DESCRIPTION,
lines.reference_1 LINE_REFERENCE_1,
lines.reference_2 LINE_REFERENCE_2,
lines.reference_3 LINE_REFERENCE_3,
lines.reference_4 LINE_REFERENCE_4,
lines.reference_5 LINE_REFERENCE_5,
lines.reference_6 LINE_REFERENCE_6,
lines.reference_7 LINE_REFERENCE_7,
lines.reference_8 LINE_REFERENCE_8,
lines.reference_9 LINE_REFERENCE_9,
lines.reference_10 LINE_REFERENCE_10,
lines.stat_amount LINE_STAT_AMOUNT,
h.Posted_Date POSTED_DATE,
fsv1.version_name ACCOUNTING_SEQ_VERSION,
h.posting_acct_seq_value ACCOUNTING_SEQ_NUMBER,
fsv1.header_name ACCOUNTING_SEQ_NAME,
fsv2.version_name REPORTING_SEQ_VERSION,
h.close_acct_seq_value REPORTING_SEQ_NUMBER,
fsv2.header_name REPORTING_SEQ_NAME,
h.reference_date REFERENCE_DATE,
h.external_reference JOURNAL_REFERENCE,
fds.name DOC_SEQUENCE_NAME,
lr.jgzz_recon_ref RECONCILIATION_REFERENCE,
lr.jgzz_recon_date RECONCILIATION_DATE
FROM gl_je_batches b,
gl_je_headers h,
gl_je_lines lines,
gl_code_combinations_kfv cc,
gl_je_sources src,
gl_je_categories cat,
fnd_document_sequences fds,
gl_je_lines_recon lr,
fun_seq_versions fsv1,
fun_seq_versions fsv2
WHERE b.average_journal_flag = 'N'
AND b.status || '' = 'P'
AND b.actual_flag = 'A'
AND h.je_batch_id = b.je_batch_id
AND h.ledger_id = :5
AND src.je_source_name = h.je_source
AND cat.je_category_name = h.je_category
AND lines.je_header_id = h.je_header_id
AND lines.period_name IN
(SELECT period_name
FROM gl_periods gp
WHERE (gp.period_year * 10000 + gp.period_num) BETWEEN (SELECT effective_period_num
FROM gl_period_statuses
WHERE period_name =
AND application_id =
101
AND ledger_id =
2021)
AND (SELECT effective_period_num
FROM gl_period_statuses
WHERE period_name =
AND application_id =
101
AND ledger_id =
2021)
AND period_set_name = 'ART_GL_CALENDAR')
AND lines.code_combination_id = cc.code_combination_id
AND cc.concatenated_segments BETWEEN :3 AND :4
AND lr.je_header_id(+) = lines.je_header_id
AND lr.je_line_num(+) = lines.je_line_num
AND lr.ledger_id(+) = lines.ledger_id
AND fds.doc_sequence_id(+) = h.doc_sequence_id
AND fsv1.seq_version_id(+) = h.posting_acct_seq_version_id
AND fsv2.seq_version_id(+) = h.close_acct_seq_version_id	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)