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

Samebug tips0

There are no available Samebug tips for this exception. If you know how to solve this issue, help other users by writing a short tip.

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

Solutions on the web1877

  • via Oracle Community by 929077, 11 months ago
    , 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
  • via Oracle Community by 2712224, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT prl.requisition_header_id, prl.requisition_line_id, prl.line_num AS LINE, msi.concatenated_segments AS ITEM_NUMBER, prl.item_revision
  • via Oracle Community by Bipin Behari Sethy, 1 year ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT NVL(PAA.DATE_START, PAA.DATE_PROJECTED_START) START_DATE, NVL(PAA.DATE_END, PAA.DATE_PROJECTED_END) END_DATE, PAATTL.NAME ABSENCE_TYPE
  • Stack trace

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

    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 user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 10 months ago
    Unknown user
    Once, 11 months ago
    Unknown user
    Once, 11 months ago
    10 more bugmates