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

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)

Users with the same issue

Samebug visitor profile picture
Unknown user
Once, 1 week 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, 1 year ago

Write tip

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