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

Oracle Community | 844181 | 5 years ago
  1. 0

    Export functionality for exporting table data in excel not working

    Oracle Community | 5 years ago | 844181
    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
  2. 0

    Getting Error when setting the default value in LOV

    Oracle Community | 1 year ago | 2973180
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select oos.name, oos.description, mcv.segment3 "DefaultSourceFlag" from oe_order_sources oos , mtl_categories_v mcv , fnd_responsibility_tl frt WHERE (mcv.structure_name LIKE 'XXG_ORM_ORD_SOURCE_RESTRICT') AND mcv.segment2 = to_char(frt.RESPONSIBILITY_ID) AND mcv.ENABLED_FLAG = 'Y' AND mcv.segment1 = oos.name And frt.responsibility_name = :1
  3. 0

    Export data from advancedTable of Query Bean

    Oracle Community | 9 years ago | 574833
    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Export from Advanced Table

    Oracle Community | 9 years ago | 574833
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: select null node_id ,null version_id ,null status_name ,rs.SALESREP_ID ,rse.source_name ,rse.source_email SRP_EMAIL_ID ,rse.source_number SRP_EMPLOYEE_NUMBER ,comp.name ,comp.comp_plan_id ,Xxg2cGoalSheetHeaderEO.srp_goal_header_id ,XL.MEANING ,Xxg2cGoalSheetHeaderEO.status_code ,Xxg2cGoalSheetHeaderEO.start_date GS_START_DATE ,Xxg2cGoalSheetHeaderEO.end_date GS_END_DATE ,Xxg2cGoalSheetHeaderEO.PERIOD_YEAR ,Xxg2cGoalSheetHeaderEO.LAST_UPDATED_BY ,Xxg2cGoalSheetHeaderEO.LAST_UPDATE_DATE ,Xxg2cGoalSheetHeaderEO.LAST_UPDATE_LOGIN ,DECODE(Xxg2cGoalSheetHeaderEO.PERIOD_YEAR,(SELECT PERIOD_YEAR FROM GL_PERIODS WHERE PERIOD_SET_NAME = 'Fiscal Year' AND trunc(SYSDATE) BETWEEN START_DATE AND END_DATE),DECODE(Xxg2cGoalSheetHeaderEO.STATUS_CODE,'AUTH','copy_enabled','copy_disabled'),'copy_disabled') COPY_FLAG ,DECODE(Xxg2cGoalSheetHeaderEO.SRP_GOAL_HEADER_ID,null,'create_enabled',DECODE(Xxg2cGoalSheetHeaderEO.status_code,'AUTH','create_enabled','create_disabled')) CREATE_FLAG ,'N' CHECKED from xxg2c_srp_goal_headers_all Xxg2cGoalSheetHeaderEO ,cn_comp_plans_all comp ,jtf_rs_salesreps rs ,jtf_rs_resource_extns rse ,xxg2c_lookups xl where rs.resource_id = rse.resource_id and Xxg2cGoalSheetHeaderEO.STATUS_CODE = XL.LOOKUP_CODE and XL.LOOKUP_TYPE ='XXG2CG_GS_STATUS' and rs.salesrep_id = Xxg2cGoalSheetHeaderEO.salesrep_id and Xxg2cGoalSheetHeaderEO.comp_plan_id = comp.comp_plan_id and Xxg2cGoalSheetHeaderEO.org_id = comp.org_id and Xxg2cGoalSheetHeaderEO.status_code != 'DEL' and Xxg2cGoalSheetHeaderEO.org_id =:1 AND PERIOD_YEAR = :2
  6. 0

    urgent urgent: date in a view

    Oracle Community | 9 years ago | 607060
    oracle.apps.fnd.framework.OAException: java.lang.ClassCastException: java.sql.Timestamp

    11 unregistered visitors
    Not finding the right solution?
    Take a tour to get the most out of Samebug.

    Tired of useless tips?

    Automated exception search integrated into your IDE

    Root Cause Analysis

    1. 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()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(Unknown Source)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(Unknown Source)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(Unknown Source)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processFormRequest(Unknown Source)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(Unknown Source)
      7 frames