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

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)

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.