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

Samebug tips0

We couldn't find tips for this exception.

Don't give up yet. Paste your full stack trace to get a solution.

Solutions on the web1658

  • via Unknown by user609291,
  • via Unknown by 2973180,
  • Stack trace

    • 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)

    Write tip

    You have a different solution? A short tip here would help you and many other users who saw this issue last week.

    Users with the same issue

    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    Unknown visitor
    Unknown visitorOnce,
    14 more bugmates