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 929077, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT aerl.REPORT_HEADER_ID, aerl.LAST_UPDATE_DATE, aerl.LAST_UPDATED_BY, aerl.ITEM_DESCRIPTION, aerl.SET_OF_BOOKS_ID, aerl.AMOUNT
via Oracle Community by sjain26, 1 year ago
oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=null
via Oracle Community by LMartin, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT aerh.REPORT_HEADER_ID, aerh.EMPLOYEE_ID, aerh.WEEK_END_DATE, aerh.CREATION_DATE, aerh.CREATED_BY, aerh.LAST_UPDATE_DATE
via Oracle Community by 2906075, 1 year ago
oracle.jbo.AttributeLoadException: JBO-27021: Failed to load CustomDatum value at index 113 with java object of type oracle.jbo.domain.Date due to java.sql.SQLException.
via Oracle Community by 610323, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT pen.prtt_enrt_rslt_id, pcs.enrt_ctfn_typ_cd, hl1.meaning certification_type, pen.sspndd_flag suspended_flag, pcs.enrt_ctfn_rqd_flag required_flag
via hivmr.com by Unknown author, 1 year ago
oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: /* Formatted on 2009/07/24 10:39 (Formatter Plus v4.8.0) */ SELECT pen.prtt_enrt_rslt_id, pcs.enrt_ctfn_typ_cd, hl1.meaning certification_type
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT aerl.REPORT_HEADER_ID,
aerl.LAST_UPDATE_DATE,
aerl.LAST_UPDATED_BY,
aerl.ITEM_DESCRIPTION,
aerl.SET_OF_BOOKS_ID,
aerl.AMOUNT,
aerl.CURRENCY_CODE,
aerl.VAT_CODE,
aerl.LINE_TYPE_LOOKUP_CODE,
aerl.LAST_UPDATE_LOGIN,
aerl.CREATION_DATE,
aerl.CREATED_BY,
aerl.DISTRIBUTION_LINE_NUMBER,
aerl.REFERENCE_1,
aerl.REFERENCE_2,
aerl.AWT_GROUP_ID,
aerl.ORG_ID,
aerl.RECEIPT_VERIFIED_FLAG,
aerl.JUSTIFICATION_REQUIRED_FLAG,
aerl.REPORT_LINE_ID,
aerl.RECEIPT_REQUIRED_FLAG,
aerl.RECEIPT_MISSING_FLAG,
aerl.JUSTIFICATION,
aerl.START_EXPENSE_DATE,
aerl.END_EXPENSE_DATE,
aerl.RECEIPT_CURRENCY_CODE,
aerl.RECEIPT_CONVERSION_RATE,
aerl.DAILY_AMOUNT,
aerl.RECEIPT_CURRENCY_AMOUNT,
aerl.WEB_PARAMETER_ID,
aerl.AMOUNT_INCLUDES_TAX_FLAG,
aerl.ADJUSTMENT_REASON,
aerl.POLICY_SHORTPAY_FLAG,
aerl.TAX_CODE_ID,
aerl.MERCHANT_DOCUMENT_NUMBER,
aerl.MERCHANT_NAME,
aerl.MERCHANT_REFERENCE,
aerl.MERCHANT_TAX_REG_NUMBER,
aerl.MERCHANT_TAXPAYER_ID,
aerl.CREDIT_CARD_TRX_ID,
aerl.COMPANY_PREPAID_INVOICE_ID,
aerl.NUMBER_PEOPLE,
aerl.LOCATION_ID,
aerl.ATTENDEES,
aerl.NUMBER_ATTENDEES,
aerl.LOCATION_TO_ID,
aerl.ADJUSTMENT_REASON_CODE,
aerl.EXPENDITURE_TYPE,
aerl.itemization_parent_id,
aerl.SUBMITTED_AMOUNT,
aerl.allocation_split_code,
decode(aerl.itemization_parent_id, -1, null, AP_WEB_AUDIT_UTILS.get_line_status(aerl.REPORT_HEADER_ID,
aerl.DISTRIBUTION_LINE_NUMBER)) line_status,
decode(aerl.itemization_parent_id, -1, to_number(null), AP_WEB_AUDIT_UTILS.get_allowable_amount(aerl.report_header_id, aerl.distribution_line_number)) allowable_amount,
decode(aerl.itemization_parent_id, -1, to_number(null), AP_WEB_AUDIT_UTILS.get_allowable_rate(aerl.report_header_id, aerl.distribution_line_number)) allowable_exchange_rate,
AP_WEB_AUDIT_UTILS.get_awt_group_info(aerl.AWT_GROUP_ID,
'name','VARCHAR2') awt_group_disp,
aerl.AMOUNT orig_amount,
aerl.RECEIPT_CONVERSION_RATE orig_receipt_conversion_rate,
decode(aerl.itemization_parent_id,
null, decode(AP_WEB_AUDIT_UTILS.is_personal_expense(aerl.web_parameter_id),
'Y', (select DECODE(trx.CATEGORY,
'BUSINESS',trx.transaction_amount,
to_number(null))
from AP_CREDIT_CARD_TRXNS_all trx
where trx.trx_id = aerl.credit_card_trx_id
)
),
aerl.receipt_currency_amount) itemized_receipt_amount,
DECODE(aerl.CREDIT_CARD_TRX_ID,
null,'N',
'Y') cc_trx,
AP_WEB_AUDIT_UTILS.get_expense_item_info(aerl.web_parameter_id,'category_code','VARCHAR2') category_code,
AP_WEB_AUDIT_UTILS.get_concat_desc_flex(aerl.report_header_id, aerl.distribution_line_number) concat_desc_flex,
DECODE(category_code,
'PER_DIEM', to_char(start_expense_date, 'HH24:MI:SS'),
to_char(null)) start_time,
DECODE(category_code,
'PER_DIEM', to_char(end_expense_date, 'HH24:MI:SS'),
to_char(null)) end_time,
DECODE(category_code,
'PER_DIEM', NVL(num_pdm_days1,0) + NVL(num_pdm_days2,0) + NVL(num_pdm_days3,0),
NVL(end_expense_date - start_expense_date,0)+1) number_of_days,
DECODE(category_code,
'PER_DIEM', AP_WEB_AUDIT_UTILS.get_average_pdm_rate(aerl.report_header_id, aerl.distribution_line_number),
to_number(null)) avg_daily_rate,
DECODE(category_code,
'PER_DIEM', NVL(deduction_addition_amt1,0) + NVL(deduction_addition_amt2,0) + NVL(deduction_addition_amt3,0),
to_number(null)) deductions_and_additions,
aerl.location location_expense_incurred,
AP_WEB_POLICY_UTILS.get_location(location_to_id) destination_location,
AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_MILEAGE_RATE_ADJUSTED',
aerl.MILEAGE_RATE_ADJUSTED_FLAG) mileage_rate_adjusted,
AP_WEB_AUDIT_UTILS.get_allowable_daily_sum(aerl.report_header_id, aerl.distribution_line_number) allowable_daily_sum,
AP_WEB_AUDIT_UTILS.is_personal_expense(aerl.web_parameter_id) personal_expense,
AP_WEB_AUDIT_UTILS.is_rounding_line(aerl.web_parameter_id) rounding_line,
AP_WEB_AUDIT_UTILS.get_expense_type(aerl.web_parameter_id) expense_type_name,
aerl.WEB_PARAMETER_ID orig_web_parameter_id,
decode(aerl.itemization_parent_id, -1, to_number(null), AP_WEB_AUDIT_UTILS.get_allowable_cc_amount(aerl.report_header_id, aerl.distribution_line_number)) allowable_cc_amount,
DECODE(aerl.itemization_parent_id, null, 'N', -1,
DECODE(aerl.credit_card_trx_id,
null,
'N',
AP_WEB_AUDIT_UTILS.has_default_cc_itemization(aerl.credit_card_trx_id)), 'N') provider_itemization,
aerl.VAT_CODE vat_code_disp,
decode(AP_WEB_AUDIT_UTILS.isAttendeeAvailable(aerl.report_line_id), 'Y', 'A', 'B') attendee_info,
proj.segment1 project_number, proj.name project_name,
task.task_number, task.task_name,
award.award_number, award.award_short_name as award_name,
hr.name as expend_org_name,
'Allocations' as allocation_switcher,
'CodeCombinationId' as accounting_switcher,
'Details' as detail_switcher,
aerl.IMAGE_RECEIPT_REQUIRED_FLAG,
aerl.RECEIPTS_ISSUE,
aerl.attribute1,
aerl.attribute2,
aerl.attribute3,
aerl.attribute4,
aerl.attribute5,
aerl.attribute6,
aerl.attribute7,
aerl.attribute8,
aerl.attribute9,
aerl.attribute10,
aerl.attribute11,
aerl.attribute12,
aerl.attribute13,
aerl.attribute14,
aerl.attribute15
FROM AP_EXPENSE_REPORT_LINES_ALL aerl,
ap_exp_report_dists_all ApExpReportDistEO,
PA_PROJECTS_ALL proj,
PA_TASKS task,
GMS_AWARDS award,
hr_organization_units hr
WHERE ApExpReportDistEO.report_line_id(+) = aerl.report_line_id
AND proj.project_id(+) = ApExpReportDistEO.project_id
AND task.task_id(+) = ApExpReportDistEO.task_id
AND award.award_id(+) = ApExpReportDistEO.award_id
AND hr.organization_id(+) = ApExpReportDistEO.expenditure_organization_id
AND allocation_split_code is null
UNION ALL
SELECT aerl.REPORT_HEADER_ID,
aerl.LAST_UPDATE_DATE,
aerl.LAST_UPDATED_BY,
aerl.ITEM_DESCRIPTION,
aerl.SET_OF_BOOKS_ID,
aerl.AMOUNT,
aerl.CURRENCY_CODE,
aerl.VAT_CODE,
aerl.LINE_TYPE_LOOKUP_CODE,
aerl.LAST_UPDATE_LOGIN,
aerl.CREATION_DATE,
aerl.CREATED_BY,
aerl.DISTRIBUTION_LINE_NUMBER,
aerl.REFERENCE_1,
aerl.REFERENCE_2,
aerl.AWT_GROUP_ID,
aerl.ORG_ID,
aerl.RECEIPT_VERIFIED_FLAG,
aerl.JUSTIFICATION_REQUIRED_FLAG,
aerl.REPORT_LINE_ID,
aerl.RECEIPT_REQUIRED_FLAG,
aerl.RECEIPT_MISSING_FLAG,
aerl.JUSTIFICATION,
aerl.START_EXPENSE_DATE,
aerl.END_EXPENSE_DATE,
aerl.RECEIPT_CURRENCY_CODE,
aerl.RECEIPT_CONVERSION_RATE,
aerl.DAILY_AMOUNT,
aerl.RECEIPT_CURRENCY_AMOUNT,
aerl.WEB_PARAMETER_ID,
aerl.AMOUNT_INCLUDES_TAX_FLAG,
aerl.ADJUSTMENT_REASON,
aerl.POLICY_SHORTPAY_FLAG,
aerl.TAX_CODE_ID,
aerl.MERCHANT_DOCUMENT_NUMBER,
aerl.MERCHANT_NAME,
aerl.MERCHANT_REFERENCE,
aerl.MERCHANT_TAX_REG_NUMBER,
aerl.MERCHANT_TAXPAYER_ID,
aerl.CREDIT_CARD_TRX_ID,
aerl.COMPANY_PREPAID_INVOICE_ID,
aerl.NUMBER_PEOPLE,
aerl.LOCATION_ID,
aerl.ATTENDEES,
aerl.NUMBER_ATTENDEES,
aerl.LOCATION_TO_ID,
aerl.ADJUSTMENT_REASON_CODE,
aerl.EXPENDITURE_TYPE,
aerl.itemization_parent_id,
aerl.SUBMITTED_AMOUNT,
aerl.allocation_split_code,
decode(aerl.itemization_parent_id, -1, null, AP_WEB_AUDIT_UTILS.get_line_status(aerl.REPORT_HEADER_ID,
aerl.DISTRIBUTION_LINE_NUMBER)) line_status,
decode(aerl.itemization_parent_id, -1, to_number(null), AP_WEB_AUDIT_UTILS.get_allowable_amount(aerl.report_header_id, aerl.distribution_line_number)) allowable_amount,
decode(aerl.itemization_parent_id, -1, to_number(null), AP_WEB_AUDIT_UTILS.get_allowable_rate(aerl.report_header_id, aerl.distribution_line_number)) allowable_exchange_rate,
AP_WEB_AUDIT_UTILS.get_awt_group_info(aerl.AWT_GROUP_ID,
'name','VARCHAR2') awt_group_disp,
aerl.AMOUNT orig_amount,
aerl.RECEIPT_CONVERSION_RATE orig_receipt_conversion_rate,
decode(aerl.itemization_parent_id,
null, decode(AP_WEB_AUDIT_UTILS.is_personal_expense(aerl.web_parameter_id),
'Y', (select DECODE(trx.CATEGORY,
'BUSINESS',trx.transaction_amount,
to_number(null))
from AP_CREDIT_CARD_TRXNS_all trx
where trx.trx_id = aerl.credit_card_trx_id
)
),
aerl.receipt_currency_amount) itemized_receipt_amount,
DECODE(aerl.CREDIT_CARD_TRX_ID,
null,'N',
'Y') cc_trx,
AP_WEB_AUDIT_UTILS.get_expense_item_info(aerl.web_parameter_id,'category_code','VARCHAR2') category_code,
AP_WEB_AUDIT_UTILS.get_concat_desc_flex(aerl.report_header_id, aerl.distribution_line_number) concat_desc_flex,
DECODE(category_code,
'PER_DIEM', to_char(start_expense_date, 'HH24:MI:SS'),
to_char(null)) start_time,
DECODE(category_code,
'PER_DIEM', to_char(end_expense_date, 'HH24:MI:SS'),
to_char(null)) end_time,
DECODE(category_code,
'PER_DIEM', NVL(num_pdm_days1,0) + NVL(num_pdm_days2,0) + NVL(num_pdm_days3,0),
NVL(end_expense_date - start_expense_date,0)+1) number_of_days,
DECODE(category_code,
'PER_DIEM', AP_WEB_AUDIT_UTILS.get_average_pdm_rate(aerl.report_header_id, aerl.distribution_line_number),
to_number(null)) avg_daily_rate,
DECODE(category_code,
'PER_DIEM', NVL(deduction_addition_amt1,0) + NVL(deduction_addition_amt2,0) + NVL(deduction_addition_amt3,0),
to_number(null)) deductions_and_additions,
aerl.location location_expense_incurred,
AP_WEB_POLICY_UTILS.get_location(location_to_id) destination_location,
AP_WEB_POLICY_UTILS.get_lookup_meaning('OIE_MILEAGE_RATE_ADJUSTED',
aerl.MILEAGE_RATE_ADJUSTED_FLAG) mileage_rate_adjusted,
AP_WEB_AUDIT_UTILS.get_allowable_daily_sum(aerl.report_header_id, aerl.distribution_line_number) allowable_daily_sum,
AP_WEB_AUDIT_UTILS.is_personal_expense(aerl.web_parameter_id) personal_expense,
AP_WEB_AUDIT_UTILS.is_rounding_line(aerl.web_parameter_id) rounding_line,
AP_WEB_AUDIT_UTILS.get_expense_type(aerl.web_parameter_id) expense_type_name,
aerl.WEB_PARAMETER_ID orig_web_parameter_id,
decode(aerl.itemization_parent_id, -1, to_number(null), AP_WEB_AUDIT_UTILS.get_allowable_cc_amount(aerl.report_header_id, aerl.distribution_line_number)) allowable_cc_amount,
DECODE(aerl.itemization_parent_id, null, 'N', -1,
DECODE(aerl.credit_card_trx_id,
null,
'N', AP_WEB_AUDIT_UTILS.has_default_cc_itemization(aerl.credit_card_trx_id)), 'N') provider_itemization,
aerl.VAT_CODE vat_code_disp,
decode(AP_WEB_AUDIT_UTILS.isAttendeeAvailable(aerl.report_line_id), 'Y', 'A', 'B') attendee_info,
null, null, null, null, null, null, null,
'Allocations' as allocation_switcher,
'CodeCombinationId' as accounting_switcher,
'Details' as detail_switcher,
aerl.IMAGE_RECEIPT_REQUIRED_FLAG,
aerl.RECEIPTS_ISSUE,
aerl.attribute1,
aerl.attribute2,
aerl.attribute3,
aerl.attribute4,
aerl.attribute5,
aerl.attribute6,
aerl.attribute7,
aerl.attribute8,
aerl.attribute9,
aerl.attribute10,
aerl.attribute11,
aerl.attribute12,
aerl.attribute13,
aerl.attribute14,
aerl.attribute15
FROM AP_EXPENSE_REPORT_LINES_ALL aerl
WHERE allocation_split_code is not null) QRSLT WHERE :1 = REPORT_HEADER_ID AND (itemization_parent_id is null OR itemization_parent_id = -1) ORDER BY distribution_line_number	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)	at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)	at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:211)	at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(OAUtility.java:153)	at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:762)	at oracle.apps.ap.oie.audit.webui.AuditPageCO.processRequest(AuditPageCO.java:156)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:600)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.OAPageLayoutHelper.processRequest(OAPageLayoutHelper.java:1182)	at oracle.apps.fnd.framework.webui.beans.layout.OAPageLayoutBean.processRequest(OAPageLayoutBean.java:1569)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.form.OAFormBean.processRequest(OAFormBean.java:385)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:968)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequestChildren(OAWebBeanHelper.java:935)	at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:659)	at oracle.apps.fnd.framework.webui.OAWebBeanContainerHelper.processRequest(OAWebBeanContainerHelper.java:252)	at oracle.apps.fnd.framework.webui.beans.OABodyBean.processRequest(OABodyBean.java:353)	at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2607)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1940)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:543)	at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:431)