oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT ApInvDistAllEO.ACCOUNTING_DATE, ApInvDistAllEO.ACCRUAL_POSTED_FLAG, ApInvDistAllEO.ASSETS_ADDITION_FLAG, ApInvDistAllEO.ASSETS_TRACKING_FLAG, ApInvDistAllEO.CASH_POSTED_FLAG, ApInvDistAllEO.DISTRIBUTION_LINE_NUMBER, ApInvDistAllEO.DIST_CODE_COMBINATION_ID, ApInvDistAllEO.INVOICE_ID, ApInvDistAllEO.LAST_UPDATED_BY, ApInvDistAllEO.LAST_UPDATE_DATE, ApInvDistAllEO.LINE_TYPE_LOOKUP_CODE, ApInvDistAllEO.PERIOD_NAME, ApInvDistAllEO.SET_OF_BOOKS_ID, ApInvDistAllEO.ACCTS_PAY_CODE_COMBINATION_ID, ApInvDistAllEO.AMOUNT, ApInvDistAllEO.BASE_AMOUNT, ApInvDistAllEO.BASE_INVOICE_PRICE_VARIANCE, ApInvDistAllEO.BATCH_ID, ApInvDistAllEO.CREATED_BY, ApInvDistAllEO.CREATION_DATE, ApInvDistAllEO.DESCRIPTION, ApInvDistAllEO.EXCHANGE_RATE_VARIANCE, ApInvDistAllEO.FINAL_MATCH_FLAG, ApInvDistAllEO.INCOME_TAX_REGION, ApInvDistAllEO.INVOICE_PRICE_VARIANCE, ApInvDistAllEO.LAST_UPDATE_LOGIN, ApInvDistAllEO.MATCH_STATUS_FLAG, ApInvDistAllEO.POSTED_FLAG, ApInvDistAllEO.PO_DISTRIBUTION_ID, ApInvDistAllEO.PROGRAM_APPLICATION_ID, ApInvDistAllEO.PROGRAM_ID, ApInvDistAllEO.PROGRAM_UPDATE_DATE, ApInvDistAllEO.QUANTITY_INVOICED, ApInvDistAllEO.RATE_VAR_CODE_COMBINATION_ID, ApInvDistAllEO.REQUEST_ID, ApInvDistAllEO.REVERSAL_FLAG, ApInvDistAllEO.TYPE_1099, ApInvDistAllEO.UNIT_PRICE, ApInvDistAllEO.AMOUNT_ENCUMBERED, ApInvDistAllEO.BASE_AMOUNT_ENCUMBERED, ApInvDistAllEO.ENCUMBERED_FLAG, ApInvDistAllEO.EXCHANGE_DATE, ApInvDistAllEO.EXCHANGE_RATE, ApInvDistAllEO.EXCHANGE_RATE_TYPE, ApInvDistAllEO.PRICE_ADJUSTMENT_FLAG, ApInvDistAllEO.PRICE_VAR_CODE_COMBINATION_ID, ApInvDistAllEO.QUANTITY_UNENCUMBERED, ApInvDistAllEO.STAT_AMOUNT, ApInvDistAllEO.AMOUNT_TO_POST, ApInvDistAllEO.ATTRIBUTE1, ApInvDistAllEO.ATTRIBUTE10, ApInvDistAllEO.ATTRIBUTE11, ApInvDistAllEO.ATTRIBUTE12, ApInvDistAllEO.ATTRIBUTE13, ApInvDistAllEO.ATTRIBUTE14, ApInvDistAllEO.ATTRIBUTE15, ApInvDistAllEO.ATTRIBUTE2, ApInvDistAllEO.ATTRIBUTE3, ApInvDistAllEO.ATTRIBUTE4, ApInvDistAllEO.ATTRIBUTE5, ApInvDistAllEO.ATTRIBUTE6, ApInvDistAllEO.ATTRIBUTE7, ApInvDistAllEO.ATTRIBUTE8, ApInvDistAllEO.ATTRIBUTE9, ApInvDistAllEO.ATTRIBUTE_CATEGORY, ApInvDistAllEO.BASE_AMOUNT_TO_POST, ApInvDistAllEO.CASH_JE_BATCH_ID, ApInvDistAllEO.EXPENDITURE_ITEM_DATE, ApInvDistAllEO.EXPENDITURE_ORGANIZATION_ID, ApInvDistAllEO.EXPENDITURE_TYPE, ApInvDistAllEO.JE_BATCH_ID, ApInvDistAllEO.PARENT_INVOICE_ID, ApInvDistAllEO.PA_ADDITION_FLAG, ApInvDistAllEO.PA_QUANTITY, ApInvDistAllEO.POSTED_AMOUNT, ApInvDistAllEO.POSTED_BASE_AMOUNT, ApInvDistAllEO.PREPAY_AMOUNT_REMAINING, ApInvDistAllEO.PROJECT_ACCOUNTING_CONTEXT, ApInvDistAllEO.PROJECT_ID, ApInvDistAllEO.TASK_ID, ApInvDistAllEO.USSGL_TRANSACTION_CODE, ApInvDistAllEO.USSGL_TRX_CODE_CONTEXT, ApInvDistAllEO.EARLIEST_SETTLEMENT_DATE, ApInvDistAllEO.REQ_DISTRIBUTION_ID, ApInvDistAllEO.QUANTITY_VARIANCE, ApInvDistAllEO.BASE_QUANTITY_VARIANCE, ApInvDistAllEO.PACKET_ID, ApInvDistAllEO.AWT_FLAG, ApInvDistAllEO.AWT_GROUP_ID, ApInvDistAllEO.AWT_TAX_RATE_ID, ApInvDistAllEO.AWT_GROSS_AMOUNT, ApInvDistAllEO.AWT_INVOICE_ID, ApInvDistAllEO.AWT_ORIGIN_GROUP_ID, ApInvDistAllEO.REFERENCE_1, ApInvDistAllEO.REFERENCE_2, ApInvDistAllEO.ORG_ID, ApInvDistAllEO.OTHER_INVOICE_ID, ApInvDistAllEO.AWT_INVOICE_PAYMENT_ID, ApInvDistAllEO.GLOBAL_ATTRIBUTE_CATEGORY, ApInvDistAllEO.GLOBAL_ATTRIBUTE1, ApInvDistAllEO.GLOBAL_ATTRIBUTE2, ApInvDistAllEO.GLOBAL_ATTRIBUTE3, ApInvDistAllEO.GLOBAL_ATTRIBUTE4, ApInvDistAllEO.GLOBAL_ATTRIBUTE5, ApInvDistAllEO.GLOBAL_ATTRIBUTE6, ApInvDistAllEO.GLOBAL_ATTRIBUTE7, ApInvDistAllEO.GLOBAL_ATTRIBUTE8, ApInvDistAllEO.GLOBAL_ATTRIBUTE9, ApInvDistAllEO.GLOBAL_ATTRIBUTE10, ApInvDistAllEO.GLOBAL_ATTRIBUTE11, ApInvDistAllEO.GLOBAL_ATTRIBUTE12, ApInvDistAllEO.GLOBAL_ATTRIBUTE13, ApInvDistAllEO.GLOBAL_ATTRIBUTE14, ApInvDistAllEO.GLOBAL_ATTRIBUTE15, ApInvDistAllEO.GLOBAL_ATTRIBUTE16, ApInvDistAllEO.GLOBAL_ATTRIBUTE17, ApInvDistAllEO.GLOBAL_ATTRIBUTE18, ApInvDistAllEO.GLOBAL_ATTRIBUTE19, ApInvDistAllEO.GLOBAL_ATTRIBUTE20, ApInvDistAllEO.LINE_GROUP_NUMBER, ApInvDistAllEO.RECEIPT_VERIFIED_FLAG, ApInvDistAllEO.RECEIPT_REQUIRED_FLAG, ApInvDistAllEO.RECEIPT_MISSING_FLAG, ApInvDistAllEO.JUSTIFICATION, ApInvDistAllEO.EXPENSE_GROUP, ApInvDistAllEO.START_EXPENSE_DATE, ApInvDistAllEO.END_EXPENSE_DATE, ApInvDistAllEO.RECEIPT_CURRENCY_CODE, ApInvDistAllEO.RECEIPT_CONVERSION_RATE, ApInvDistAllEO.RECEIPT_CURRENCY_AMOUNT, ApInvDistAllEO.DAILY_AMOUNT, ApInvDistAllEO.WEB_PARAMETER_ID, ApInvDistAllEO.ADJUSTMENT_REASON, ApInvDistAllEO.AWARD_ID, ApInvDistAllEO.MRC_ACCRUAL_POSTED_FLAG, ApInvDistAllEO.MRC_CASH_POSTED_FLAG, ApInvDistAllEO.MRC_DIST_CODE_COMBINATION_ID, ApInvDistAllEO.MRC_AMOUNT, ApInvDistAllEO.MRC_BASE_AMOUNT, ApInvDistAllEO.MRC_BASE_INV_PRICE_VARIANCE, ApInvDistAllEO.MRC_EXCHANGE_RATE_VARIANCE, ApInvDistAllEO.MRC_POSTED_FLAG, ApInvDistAllEO.MRC_PROGRAM_APPLICATION_ID, ApInvDistAllEO.MRC_PROGRAM_ID, ApInvDistAllEO.MRC_PROGRAM_UPDATE_DATE, ApInvDistAllEO.MRC_RATE_VAR_CCID, ApInvDistAllEO.MRC_REQUEST_ID, ApInvDistAllEO.MRC_EXCHANGE_DATE, ApInvDistAllEO.MRC_EXCHANGE_RATE, ApInvDistAllEO.MRC_EXCHANGE_RATE_TYPE, ApInvDistAllEO.MRC_AMOUNT_TO_POST, ApInvDistAllEO.MRC_BASE_AMOUNT_TO_POST, ApInvDistAllEO.MRC_CASH_JE_BATCH_ID, ApInvDistAllEO.MRC_JE_BATCH_ID, ApInvDistAllEO.MRC_POSTED_AMOUNT, ApInvDistAllEO.MRC_POSTED_BASE_AMOUNT, ApInvDistAllEO.MRC_RECEIPT_CONVERSION_RATE, ApInvDistAllEO.CREDIT_CARD_TRX_ID, ApInvDistAllEO.DIST_MATCH_TYPE, ApInvDistAllEO.RCV_TRANSACTION_ID, ApInvDistAllEO.INVOICE_DISTRIBUTION_ID, ApInvDistAllEO.PARENT_REVERSAL_ID, ApInvDistAllEO.TAX_RECOVERABLE_FLAG, ApInvDistAllEO.PA_CC_AR_INVOICE_ID, ApInvDistAllEO.PA_CC_AR_INVOICE_LINE_NUM, ApInvDistAllEO.PA_CC_PROCESSED_CODE, ApInvDistAllEO.MERCHANT_DOCUMENT_NUMBER, ApInvDistAllEO.MERCHANT_NAME, ApInvDistAllEO.MERCHANT_REFERENCE, ApInvDistAllEO.MERCHANT_TAX_REG_NUMBER, ApInvDistAllEO.MERCHANT_TAXPAYER_ID, ApInvDistAllEO.COUNTRY_OF_SUPPLY, ApInvDistAllEO.MATCHED_UOM_LOOKUP_CODE, ApInvDistAllEO.GMS_BURDENABLE_RAW_COST, ApInvDistAllEO.ACCOUNTING_EVENT_ID, ApInvDistAllEO.PREPAY_DISTRIBUTION_ID, ApInvDistAllEO.UPGRADE_POSTED_AMT, ApInvDistAllEO.UPGRADE_BASE_POSTED_AMT, ApInvDistAllEO.INVENTORY_TRANSFER_STATUS, ApInvDistAllEO.COMPANY_PREPAID_INVOICE_ID, ApInvDistAllEO.CC_REVERSAL_FLAG, ApInvDistAllEO.AWT_WITHHELD_AMT, ApInvDistAllEO.INVOICE_INCLUDES_PREPAY_FLAG, ApInvDistAllEO.PRICE_CORRECT_INV_ID, ApInvDistAllEO.PRICE_CORRECT_QTY, ApInvDistAllEO.PA_CMT_XFACE_FLAG, ApInvDistAllEO.CANCELLATION_FLAG, ApInvDistAllEO.INVOICE_LINE_NUMBER, ApInvDistAllEO.CORRECTED_INVOICE_DIST_ID, ApInvDistAllEO.ROUNDING_AMT, ApInvDistAllEO.CHARGE_APPLICABLE_TO_DIST_ID, ApInvDistAllEO.CORRECTED_QUANTITY, ApInvDistAllEO.RELATED_ID, ApInvDistAllEO.ASSET_BOOK_TYPE_CODE, ApInvDistAllEO.ASSET_CATEGORY_ID, ApInvDistAllEO.DISTRIBUTION_CLASS, ApInvDistAllEO.FINAL_PAYMENT_ROUNDING, ApInvDistAllEO.FINAL_APPLICATION_ROUNDING, ApInvDistAllEO.AMOUNT_AT_PREPAY_XRATE, ApInvDistAllEO.CASH_BASIS_FINAL_APP_ROUNDING, ApInvDistAllEO.AMOUNT_AT_PREPAY_PAY_XRATE, ApInvDistAllEO.INTENDED_USE, ApInvDistAllEO.DETAIL_TAX_DIST_ID, ApInvDistAllEO.REC_NREC_RATE, ApInvDistAllEO.RECOVERY_RATE_ID, ApInvDistAllEO.RECOVERY_RATE_NAME, ApInvDistAllEO.RECOVERY_TYPE_CODE, ApInvDistAllEO.RECOVERY_RATE_CODE, ApInvDistAllEO.WITHHOLDING_TAX_CODE_ID, ApInvDistAllEO.TAX_ALREADY_DISTRIBUTED_FLAG, ApInvDistAllEO.SUMMARY_TAX_LINE_ID, ApInvDistAllEO.TAXABLE_AMOUNT, ApInvDistAllEO.TAXABLE_BASE_AMOUNT, ApInvDistAllEO.EXTRA_PO_ERV, ApInvDistAllEO.PREPAY_TAX_DIFF_AMOUNT, ApInvDistAllEO.TAX_CODE_ID, ApInvDistAllEO.VAT_CODE, ApInvDistAllEO.AMOUNT_INCLUDES_TAX_FLAG, ApInvDistAllEO.TAX_CALCULATED_FLAG, ApInvDistAllEO.TAX_RECOVERY_RATE, ApInvDistAllEO.TAX_RECOVERY_OVERRIDE_FLAG, ApInvDistAllEO.TAX_CODE_OVERRIDE_FLAG, ApInvDistAllEO.TOTAL_DIST_AMOUNT, ApInvDistAllEO.TOTAL_DIST_BASE_AMOUNT, ApInvDistAllEO.PREPAY_TAX_PARENT_ID, ApInvDistAllEO.CANCELLED_FLAG, ApInvDistAllEO.OLD_DISTRIBUTION_ID, ApInvDistAllEO.OLD_DIST_LINE_NUMBER, ApInvDistAllEO.AMOUNT_VARIANCE, ApInvDistAllEO.BASE_AMOUNT_VARIANCE, ApInvDistAllEO.HISTORICAL_FLAG, ApInvDistAllEO.RCV_CHARGE_ADDITION_FLAG, ApInvDistAllEO.AWT_RELATED_ID, ApInvDistAllEO.RELATED_RETAINAGE_DIST_ID, ApInvDistAllEO.RETAINED_AMOUNT_REMAINING, ApInvDistAllEO.BC_EVENT_ID, ApInvDistAllEO.RETAINED_INVOICE_DIST_ID, ApInvDistAllEO.FINAL_RELEASE_ROUNDING, ApInvDistAllEO.FULLY_PAID_ACCTD_FLAG, ApInvDistAllEO.ROOT_DISTRIBUTION_ID, ApInvDistAllEO.XINV_PARENT_REVERSAL_ID, ApInvDistAllEO.RECURRING_PAYMENT_ID, ApInvDistAllEO.RELEASE_INV_DIST_DERIVED_FROM, gl_flexfields_pkg.get_concat_description (f.id_flex_num, ApInvDistAllEO.dist_code_combination_id) segments, (SELECT segment1 FROM pa_projects_all ppa WHERE ppa.project_id = apinvdistalleo.project_id) project_number, (SELECT pt.task_number FROM pa_tasks pt WHERE pt.task_id = apinvdistalleo.task_id) task_number, (SELECT NAME FROM hr_all_organization_units hou WHERE hou.organization_id = apinvdistalleo.expenditure_organization_id) expd_org_name FROM AP_INVOICE_DISTRIBUTIONS_ALL ApInvDistAllEO, fnd_id_flex_structures_vl f, ap_invoices_all i, gl_sets_of_books sob where ApInvDistAllEO.invoice_id = i.invoice_id and sob.set_of_books_id = i.set_of_books_id and f.id_flex_num = sob.chart_of_accounts_id and f.id_flex_code = 'GL#' and f.application_id = 101) QRSLT WHERE (:1 = INVOICE_ID) AND (:2 = INVOICE_LINE_NUMBER)

Oracle Community | 575709 | 8 years ago
  1. 0

    oracle.jbo.SQLStmtException:JBO-27122:SQL error during statement preparatio

    Oracle Community | 8 years ago | 575709
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT ApInvDistAllEO.ACCOUNTING_DATE, ApInvDistAllEO.ACCRUAL_POSTED_FLAG, ApInvDistAllEO.ASSETS_ADDITION_FLAG, ApInvDistAllEO.ASSETS_TRACKING_FLAG, ApInvDistAllEO.CASH_POSTED_FLAG, ApInvDistAllEO.DISTRIBUTION_LINE_NUMBER, ApInvDistAllEO.DIST_CODE_COMBINATION_ID, ApInvDistAllEO.INVOICE_ID, ApInvDistAllEO.LAST_UPDATED_BY, ApInvDistAllEO.LAST_UPDATE_DATE, ApInvDistAllEO.LINE_TYPE_LOOKUP_CODE, ApInvDistAllEO.PERIOD_NAME, ApInvDistAllEO.SET_OF_BOOKS_ID, ApInvDistAllEO.ACCTS_PAY_CODE_COMBINATION_ID, ApInvDistAllEO.AMOUNT, ApInvDistAllEO.BASE_AMOUNT, ApInvDistAllEO.BASE_INVOICE_PRICE_VARIANCE, ApInvDistAllEO.BATCH_ID, ApInvDistAllEO.CREATED_BY, ApInvDistAllEO.CREATION_DATE, ApInvDistAllEO.DESCRIPTION, ApInvDistAllEO.EXCHANGE_RATE_VARIANCE, ApInvDistAllEO.FINAL_MATCH_FLAG, ApInvDistAllEO.INCOME_TAX_REGION, ApInvDistAllEO.INVOICE_PRICE_VARIANCE, ApInvDistAllEO.LAST_UPDATE_LOGIN, ApInvDistAllEO.MATCH_STATUS_FLAG, ApInvDistAllEO.POSTED_FLAG, ApInvDistAllEO.PO_DISTRIBUTION_ID, ApInvDistAllEO.PROGRAM_APPLICATION_ID, ApInvDistAllEO.PROGRAM_ID, ApInvDistAllEO.PROGRAM_UPDATE_DATE, ApInvDistAllEO.QUANTITY_INVOICED, ApInvDistAllEO.RATE_VAR_CODE_COMBINATION_ID, ApInvDistAllEO.REQUEST_ID, ApInvDistAllEO.REVERSAL_FLAG, ApInvDistAllEO.TYPE_1099, ApInvDistAllEO.UNIT_PRICE, ApInvDistAllEO.AMOUNT_ENCUMBERED, ApInvDistAllEO.BASE_AMOUNT_ENCUMBERED, ApInvDistAllEO.ENCUMBERED_FLAG, ApInvDistAllEO.EXCHANGE_DATE, ApInvDistAllEO.EXCHANGE_RATE, ApInvDistAllEO.EXCHANGE_RATE_TYPE, ApInvDistAllEO.PRICE_ADJUSTMENT_FLAG, ApInvDistAllEO.PRICE_VAR_CODE_COMBINATION_ID, ApInvDistAllEO.QUANTITY_UNENCUMBERED, ApInvDistAllEO.STAT_AMOUNT, ApInvDistAllEO.AMOUNT_TO_POST, ApInvDistAllEO.ATTRIBUTE1, ApInvDistAllEO.ATTRIBUTE10, ApInvDistAllEO.ATTRIBUTE11, ApInvDistAllEO.ATTRIBUTE12, ApInvDistAllEO.ATTRIBUTE13, ApInvDistAllEO.ATTRIBUTE14, ApInvDistAllEO.ATTRIBUTE15, ApInvDistAllEO.ATTRIBUTE2, ApInvDistAllEO.ATTRIBUTE3, ApInvDistAllEO.ATTRIBUTE4, ApInvDistAllEO.ATTRIBUTE5, ApInvDistAllEO.ATTRIBUTE6, ApInvDistAllEO.ATTRIBUTE7, ApInvDistAllEO.ATTRIBUTE8, ApInvDistAllEO.ATTRIBUTE9, ApInvDistAllEO.ATTRIBUTE_CATEGORY, ApInvDistAllEO.BASE_AMOUNT_TO_POST, ApInvDistAllEO.CASH_JE_BATCH_ID, ApInvDistAllEO.EXPENDITURE_ITEM_DATE, ApInvDistAllEO.EXPENDITURE_ORGANIZATION_ID, ApInvDistAllEO.EXPENDITURE_TYPE, ApInvDistAllEO.JE_BATCH_ID, ApInvDistAllEO.PARENT_INVOICE_ID, ApInvDistAllEO.PA_ADDITION_FLAG, ApInvDistAllEO.PA_QUANTITY, ApInvDistAllEO.POSTED_AMOUNT, ApInvDistAllEO.POSTED_BASE_AMOUNT, ApInvDistAllEO.PREPAY_AMOUNT_REMAINING, ApInvDistAllEO.PROJECT_ACCOUNTING_CONTEXT, ApInvDistAllEO.PROJECT_ID, ApInvDistAllEO.TASK_ID, ApInvDistAllEO.USSGL_TRANSACTION_CODE, ApInvDistAllEO.USSGL_TRX_CODE_CONTEXT, ApInvDistAllEO.EARLIEST_SETTLEMENT_DATE, ApInvDistAllEO.REQ_DISTRIBUTION_ID, ApInvDistAllEO.QUANTITY_VARIANCE, ApInvDistAllEO.BASE_QUANTITY_VARIANCE, ApInvDistAllEO.PACKET_ID, ApInvDistAllEO.AWT_FLAG, ApInvDistAllEO.AWT_GROUP_ID, ApInvDistAllEO.AWT_TAX_RATE_ID, ApInvDistAllEO.AWT_GROSS_AMOUNT, ApInvDistAllEO.AWT_INVOICE_ID, ApInvDistAllEO.AWT_ORIGIN_GROUP_ID, ApInvDistAllEO.REFERENCE_1, ApInvDistAllEO.REFERENCE_2, ApInvDistAllEO.ORG_ID, ApInvDistAllEO.OTHER_INVOICE_ID, ApInvDistAllEO.AWT_INVOICE_PAYMENT_ID, ApInvDistAllEO.GLOBAL_ATTRIBUTE_CATEGORY, ApInvDistAllEO.GLOBAL_ATTRIBUTE1, ApInvDistAllEO.GLOBAL_ATTRIBUTE2, ApInvDistAllEO.GLOBAL_ATTRIBUTE3, ApInvDistAllEO.GLOBAL_ATTRIBUTE4, ApInvDistAllEO.GLOBAL_ATTRIBUTE5, ApInvDistAllEO.GLOBAL_ATTRIBUTE6, ApInvDistAllEO.GLOBAL_ATTRIBUTE7, ApInvDistAllEO.GLOBAL_ATTRIBUTE8, ApInvDistAllEO.GLOBAL_ATTRIBUTE9, ApInvDistAllEO.GLOBAL_ATTRIBUTE10, ApInvDistAllEO.GLOBAL_ATTRIBUTE11, ApInvDistAllEO.GLOBAL_ATTRIBUTE12, ApInvDistAllEO.GLOBAL_ATTRIBUTE13, ApInvDistAllEO.GLOBAL_ATTRIBUTE14, ApInvDistAllEO.GLOBAL_ATTRIBUTE15, ApInvDistAllEO.GLOBAL_ATTRIBUTE16, ApInvDistAllEO.GLOBAL_ATTRIBUTE17, ApInvDistAllEO.GLOBAL_ATTRIBUTE18, ApInvDistAllEO.GLOBAL_ATTRIBUTE19, ApInvDistAllEO.GLOBAL_ATTRIBUTE20, ApInvDistAllEO.LINE_GROUP_NUMBER, ApInvDistAllEO.RECEIPT_VERIFIED_FLAG, ApInvDistAllEO.RECEIPT_REQUIRED_FLAG, ApInvDistAllEO.RECEIPT_MISSING_FLAG, ApInvDistAllEO.JUSTIFICATION, ApInvDistAllEO.EXPENSE_GROUP, ApInvDistAllEO.START_EXPENSE_DATE, ApInvDistAllEO.END_EXPENSE_DATE, ApInvDistAllEO.RECEIPT_CURRENCY_CODE, ApInvDistAllEO.RECEIPT_CONVERSION_RATE, ApInvDistAllEO.RECEIPT_CURRENCY_AMOUNT, ApInvDistAllEO.DAILY_AMOUNT, ApInvDistAllEO.WEB_PARAMETER_ID, ApInvDistAllEO.ADJUSTMENT_REASON, ApInvDistAllEO.AWARD_ID, ApInvDistAllEO.MRC_ACCRUAL_POSTED_FLAG, ApInvDistAllEO.MRC_CASH_POSTED_FLAG, ApInvDistAllEO.MRC_DIST_CODE_COMBINATION_ID, ApInvDistAllEO.MRC_AMOUNT, ApInvDistAllEO.MRC_BASE_AMOUNT, ApInvDistAllEO.MRC_BASE_INV_PRICE_VARIANCE, ApInvDistAllEO.MRC_EXCHANGE_RATE_VARIANCE, ApInvDistAllEO.MRC_POSTED_FLAG, ApInvDistAllEO.MRC_PROGRAM_APPLICATION_ID, ApInvDistAllEO.MRC_PROGRAM_ID, ApInvDistAllEO.MRC_PROGRAM_UPDATE_DATE, ApInvDistAllEO.MRC_RATE_VAR_CCID, ApInvDistAllEO.MRC_REQUEST_ID, ApInvDistAllEO.MRC_EXCHANGE_DATE, ApInvDistAllEO.MRC_EXCHANGE_RATE, ApInvDistAllEO.MRC_EXCHANGE_RATE_TYPE, ApInvDistAllEO.MRC_AMOUNT_TO_POST, ApInvDistAllEO.MRC_BASE_AMOUNT_TO_POST, ApInvDistAllEO.MRC_CASH_JE_BATCH_ID, ApInvDistAllEO.MRC_JE_BATCH_ID, ApInvDistAllEO.MRC_POSTED_AMOUNT, ApInvDistAllEO.MRC_POSTED_BASE_AMOUNT, ApInvDistAllEO.MRC_RECEIPT_CONVERSION_RATE, ApInvDistAllEO.CREDIT_CARD_TRX_ID, ApInvDistAllEO.DIST_MATCH_TYPE, ApInvDistAllEO.RCV_TRANSACTION_ID, ApInvDistAllEO.INVOICE_DISTRIBUTION_ID, ApInvDistAllEO.PARENT_REVERSAL_ID, ApInvDistAllEO.TAX_RECOVERABLE_FLAG, ApInvDistAllEO.PA_CC_AR_INVOICE_ID, ApInvDistAllEO.PA_CC_AR_INVOICE_LINE_NUM, ApInvDistAllEO.PA_CC_PROCESSED_CODE, ApInvDistAllEO.MERCHANT_DOCUMENT_NUMBER, ApInvDistAllEO.MERCHANT_NAME, ApInvDistAllEO.MERCHANT_REFERENCE, ApInvDistAllEO.MERCHANT_TAX_REG_NUMBER, ApInvDistAllEO.MERCHANT_TAXPAYER_ID, ApInvDistAllEO.COUNTRY_OF_SUPPLY, ApInvDistAllEO.MATCHED_UOM_LOOKUP_CODE, ApInvDistAllEO.GMS_BURDENABLE_RAW_COST, ApInvDistAllEO.ACCOUNTING_EVENT_ID, ApInvDistAllEO.PREPAY_DISTRIBUTION_ID, ApInvDistAllEO.UPGRADE_POSTED_AMT, ApInvDistAllEO.UPGRADE_BASE_POSTED_AMT, ApInvDistAllEO.INVENTORY_TRANSFER_STATUS, ApInvDistAllEO.COMPANY_PREPAID_INVOICE_ID, ApInvDistAllEO.CC_REVERSAL_FLAG, ApInvDistAllEO.AWT_WITHHELD_AMT, ApInvDistAllEO.INVOICE_INCLUDES_PREPAY_FLAG, ApInvDistAllEO.PRICE_CORRECT_INV_ID, ApInvDistAllEO.PRICE_CORRECT_QTY, ApInvDistAllEO.PA_CMT_XFACE_FLAG, ApInvDistAllEO.CANCELLATION_FLAG, ApInvDistAllEO.INVOICE_LINE_NUMBER, ApInvDistAllEO.CORRECTED_INVOICE_DIST_ID, ApInvDistAllEO.ROUNDING_AMT, ApInvDistAllEO.CHARGE_APPLICABLE_TO_DIST_ID, ApInvDistAllEO.CORRECTED_QUANTITY, ApInvDistAllEO.RELATED_ID, ApInvDistAllEO.ASSET_BOOK_TYPE_CODE, ApInvDistAllEO.ASSET_CATEGORY_ID, ApInvDistAllEO.DISTRIBUTION_CLASS, ApInvDistAllEO.FINAL_PAYMENT_ROUNDING, ApInvDistAllEO.FINAL_APPLICATION_ROUNDING, ApInvDistAllEO.AMOUNT_AT_PREPAY_XRATE, ApInvDistAllEO.CASH_BASIS_FINAL_APP_ROUNDING, ApInvDistAllEO.AMOUNT_AT_PREPAY_PAY_XRATE, ApInvDistAllEO.INTENDED_USE, ApInvDistAllEO.DETAIL_TAX_DIST_ID, ApInvDistAllEO.REC_NREC_RATE, ApInvDistAllEO.RECOVERY_RATE_ID, ApInvDistAllEO.RECOVERY_RATE_NAME, ApInvDistAllEO.RECOVERY_TYPE_CODE, ApInvDistAllEO.RECOVERY_RATE_CODE, ApInvDistAllEO.WITHHOLDING_TAX_CODE_ID, ApInvDistAllEO.TAX_ALREADY_DISTRIBUTED_FLAG, ApInvDistAllEO.SUMMARY_TAX_LINE_ID, ApInvDistAllEO.TAXABLE_AMOUNT, ApInvDistAllEO.TAXABLE_BASE_AMOUNT, ApInvDistAllEO.EXTRA_PO_ERV, ApInvDistAllEO.PREPAY_TAX_DIFF_AMOUNT, ApInvDistAllEO.TAX_CODE_ID, ApInvDistAllEO.VAT_CODE, ApInvDistAllEO.AMOUNT_INCLUDES_TAX_FLAG, ApInvDistAllEO.TAX_CALCULATED_FLAG, ApInvDistAllEO.TAX_RECOVERY_RATE, ApInvDistAllEO.TAX_RECOVERY_OVERRIDE_FLAG, ApInvDistAllEO.TAX_CODE_OVERRIDE_FLAG, ApInvDistAllEO.TOTAL_DIST_AMOUNT, ApInvDistAllEO.TOTAL_DIST_BASE_AMOUNT, ApInvDistAllEO.PREPAY_TAX_PARENT_ID, ApInvDistAllEO.CANCELLED_FLAG, ApInvDistAllEO.OLD_DISTRIBUTION_ID, ApInvDistAllEO.OLD_DIST_LINE_NUMBER, ApInvDistAllEO.AMOUNT_VARIANCE, ApInvDistAllEO.BASE_AMOUNT_VARIANCE, ApInvDistAllEO.HISTORICAL_FLAG, ApInvDistAllEO.RCV_CHARGE_ADDITION_FLAG, ApInvDistAllEO.AWT_RELATED_ID, ApInvDistAllEO.RELATED_RETAINAGE_DIST_ID, ApInvDistAllEO.RETAINED_AMOUNT_REMAINING, ApInvDistAllEO.BC_EVENT_ID, ApInvDistAllEO.RETAINED_INVOICE_DIST_ID, ApInvDistAllEO.FINAL_RELEASE_ROUNDING, ApInvDistAllEO.FULLY_PAID_ACCTD_FLAG, ApInvDistAllEO.ROOT_DISTRIBUTION_ID, ApInvDistAllEO.XINV_PARENT_REVERSAL_ID, ApInvDistAllEO.RECURRING_PAYMENT_ID, ApInvDistAllEO.RELEASE_INV_DIST_DERIVED_FROM, gl_flexfields_pkg.get_concat_description (f.id_flex_num, ApInvDistAllEO.dist_code_combination_id) segments, (SELECT segment1 FROM pa_projects_all ppa WHERE ppa.project_id = apinvdistalleo.project_id) project_number, (SELECT pt.task_number FROM pa_tasks pt WHERE pt.task_id = apinvdistalleo.task_id) task_number, (SELECT NAME FROM hr_all_organization_units hou WHERE hou.organization_id = apinvdistalleo.expenditure_organization_id) expd_org_name FROM AP_INVOICE_DISTRIBUTIONS_ALL ApInvDistAllEO, fnd_id_flex_structures_vl f, ap_invoices_all i, gl_sets_of_books sob where ApInvDistAllEO.invoice_id = i.invoice_id and sob.set_of_books_id = i.set_of_books_id and f.id_flex_num = sob.chart_of_accounts_id and f.id_flex_code = 'GL#' and f.application_id = 101) QRSLT WHERE (:1 = INVOICE_ID) AND (:2 = INVOICE_LINE_NUMBER)
  2. 0

    Invalid column index: getValidColumnIndex

    Oracle Community | 10 years ago | user542731
    oracle.apps.fnd.framework.OAException: oracle.jbo.AttributeLoadException: JBO-27021: Failed to load CustomDatum value at index 245 with java object of type oracle.jbo.domain.Number due to java.sql.SQLException.
  3. 0

    Error while extending the VO

    Oracle Community | 8 years ago | 656152
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value HzPuiPersnSrchlVL for destination passed to method ViewLinkImpl.setDestination. Explanation: view def mismatch
  4. Speed up your debug routine!

    Automated exception search integrated into your IDE

  5. 0

    Can't access iProcurement after doing personalization :_-(

    Oracle Community | 8 years ago | 650356
    oracle.apps.fnd.framework.OAException: java.lang.IndexOutOfBoundsException: index:0 size:0
  6. 0

    db:: 3.47::oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value fc

    hivmr.com | 4 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.InvalidParamException: JBO-25006: Invalid parameter value HzPuiPersnSrchlVL for destination passed to method ViewLinkImpl.setDestination. Explanation: view def mismatch

    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 * FROM (SELECT ApInvDistAllEO.ACCOUNTING_DATE, ApInvDistAllEO.ACCRUAL_POSTED_FLAG, ApInvDistAllEO.ASSETS_ADDITION_FLAG, ApInvDistAllEO.ASSETS_TRACKING_FLAG, ApInvDistAllEO.CASH_POSTED_FLAG, ApInvDistAllEO.DISTRIBUTION_LINE_NUMBER, ApInvDistAllEO.DIST_CODE_COMBINATION_ID, ApInvDistAllEO.INVOICE_ID, ApInvDistAllEO.LAST_UPDATED_BY, ApInvDistAllEO.LAST_UPDATE_DATE, ApInvDistAllEO.LINE_TYPE_LOOKUP_CODE, ApInvDistAllEO.PERIOD_NAME, ApInvDistAllEO.SET_OF_BOOKS_ID, ApInvDistAllEO.ACCTS_PAY_CODE_COMBINATION_ID, ApInvDistAllEO.AMOUNT, ApInvDistAllEO.BASE_AMOUNT, ApInvDistAllEO.BASE_INVOICE_PRICE_VARIANCE, ApInvDistAllEO.BATCH_ID, ApInvDistAllEO.CREATED_BY, ApInvDistAllEO.CREATION_DATE, ApInvDistAllEO.DESCRIPTION, ApInvDistAllEO.EXCHANGE_RATE_VARIANCE, ApInvDistAllEO.FINAL_MATCH_FLAG, ApInvDistAllEO.INCOME_TAX_REGION, ApInvDistAllEO.INVOICE_PRICE_VARIANCE, ApInvDistAllEO.LAST_UPDATE_LOGIN, ApInvDistAllEO.MATCH_STATUS_FLAG, ApInvDistAllEO.POSTED_FLAG, ApInvDistAllEO.PO_DISTRIBUTION_ID, ApInvDistAllEO.PROGRAM_APPLICATION_ID, ApInvDistAllEO.PROGRAM_ID, ApInvDistAllEO.PROGRAM_UPDATE_DATE, ApInvDistAllEO.QUANTITY_INVOICED, ApInvDistAllEO.RATE_VAR_CODE_COMBINATION_ID, ApInvDistAllEO.REQUEST_ID, ApInvDistAllEO.REVERSAL_FLAG, ApInvDistAllEO.TYPE_1099, ApInvDistAllEO.UNIT_PRICE, ApInvDistAllEO.AMOUNT_ENCUMBERED, ApInvDistAllEO.BASE_AMOUNT_ENCUMBERED, ApInvDistAllEO.ENCUMBERED_FLAG, ApInvDistAllEO.EXCHANGE_DATE, ApInvDistAllEO.EXCHANGE_RATE, ApInvDistAllEO.EXCHANGE_RATE_TYPE, ApInvDistAllEO.PRICE_ADJUSTMENT_FLAG, ApInvDistAllEO.PRICE_VAR_CODE_COMBINATION_ID, ApInvDistAllEO.QUANTITY_UNENCUMBERED, ApInvDistAllEO.STAT_AMOUNT, ApInvDistAllEO.AMOUNT_TO_POST, ApInvDistAllEO.ATTRIBUTE1, ApInvDistAllEO.ATTRIBUTE10, ApInvDistAllEO.ATTRIBUTE11, ApInvDistAllEO.ATTRIBUTE12, ApInvDistAllEO.ATTRIBUTE13, ApInvDistAllEO.ATTRIBUTE14, ApInvDistAllEO.ATTRIBUTE15, ApInvDistAllEO.ATTRIBUTE2, ApInvDistAllEO.ATTRIBUTE3, ApInvDistAllEO.ATTRIBUTE4, ApInvDistAllEO.ATTRIBUTE5, ApInvDistAllEO.ATTRIBUTE6, ApInvDistAllEO.ATTRIBUTE7, ApInvDistAllEO.ATTRIBUTE8, ApInvDistAllEO.ATTRIBUTE9, ApInvDistAllEO.ATTRIBUTE_CATEGORY, ApInvDistAllEO.BASE_AMOUNT_TO_POST, ApInvDistAllEO.CASH_JE_BATCH_ID, ApInvDistAllEO.EXPENDITURE_ITEM_DATE, ApInvDistAllEO.EXPENDITURE_ORGANIZATION_ID, ApInvDistAllEO.EXPENDITURE_TYPE, ApInvDistAllEO.JE_BATCH_ID, ApInvDistAllEO.PARENT_INVOICE_ID, ApInvDistAllEO.PA_ADDITION_FLAG, ApInvDistAllEO.PA_QUANTITY, ApInvDistAllEO.POSTED_AMOUNT, ApInvDistAllEO.POSTED_BASE_AMOUNT, ApInvDistAllEO.PREPAY_AMOUNT_REMAINING, ApInvDistAllEO.PROJECT_ACCOUNTING_CONTEXT, ApInvDistAllEO.PROJECT_ID, ApInvDistAllEO.TASK_ID, ApInvDistAllEO.USSGL_TRANSACTION_CODE, ApInvDistAllEO.USSGL_TRX_CODE_CONTEXT, ApInvDistAllEO.EARLIEST_SETTLEMENT_DATE, ApInvDistAllEO.REQ_DISTRIBUTION_ID, ApInvDistAllEO.QUANTITY_VARIANCE, ApInvDistAllEO.BASE_QUANTITY_VARIANCE, ApInvDistAllEO.PACKET_ID, ApInvDistAllEO.AWT_FLAG, ApInvDistAllEO.AWT_GROUP_ID, ApInvDistAllEO.AWT_TAX_RATE_ID, ApInvDistAllEO.AWT_GROSS_AMOUNT, ApInvDistAllEO.AWT_INVOICE_ID, ApInvDistAllEO.AWT_ORIGIN_GROUP_ID, ApInvDistAllEO.REFERENCE_1, ApInvDistAllEO.REFERENCE_2, ApInvDistAllEO.ORG_ID, ApInvDistAllEO.OTHER_INVOICE_ID, ApInvDistAllEO.AWT_INVOICE_PAYMENT_ID, ApInvDistAllEO.GLOBAL_ATTRIBUTE_CATEGORY, ApInvDistAllEO.GLOBAL_ATTRIBUTE1, ApInvDistAllEO.GLOBAL_ATTRIBUTE2, ApInvDistAllEO.GLOBAL_ATTRIBUTE3, ApInvDistAllEO.GLOBAL_ATTRIBUTE4, ApInvDistAllEO.GLOBAL_ATTRIBUTE5, ApInvDistAllEO.GLOBAL_ATTRIBUTE6, ApInvDistAllEO.GLOBAL_ATTRIBUTE7, ApInvDistAllEO.GLOBAL_ATTRIBUTE8, ApInvDistAllEO.GLOBAL_ATTRIBUTE9, ApInvDistAllEO.GLOBAL_ATTRIBUTE10, ApInvDistAllEO.GLOBAL_ATTRIBUTE11, ApInvDistAllEO.GLOBAL_ATTRIBUTE12, ApInvDistAllEO.GLOBAL_ATTRIBUTE13, ApInvDistAllEO.GLOBAL_ATTRIBUTE14, ApInvDistAllEO.GLOBAL_ATTRIBUTE15, ApInvDistAllEO.GLOBAL_ATTRIBUTE16, ApInvDistAllEO.GLOBAL_ATTRIBUTE17, ApInvDistAllEO.GLOBAL_ATTRIBUTE18, ApInvDistAllEO.GLOBAL_ATTRIBUTE19, ApInvDistAllEO.GLOBAL_ATTRIBUTE20, ApInvDistAllEO.LINE_GROUP_NUMBER, ApInvDistAllEO.RECEIPT_VERIFIED_FLAG, ApInvDistAllEO.RECEIPT_REQUIRED_FLAG, ApInvDistAllEO.RECEIPT_MISSING_FLAG, ApInvDistAllEO.JUSTIFICATION, ApInvDistAllEO.EXPENSE_GROUP, ApInvDistAllEO.START_EXPENSE_DATE, ApInvDistAllEO.END_EXPENSE_DATE, ApInvDistAllEO.RECEIPT_CURRENCY_CODE, ApInvDistAllEO.RECEIPT_CONVERSION_RATE, ApInvDistAllEO.RECEIPT_CURRENCY_AMOUNT, ApInvDistAllEO.DAILY_AMOUNT, ApInvDistAllEO.WEB_PARAMETER_ID, ApInvDistAllEO.ADJUSTMENT_REASON, ApInvDistAllEO.AWARD_ID, ApInvDistAllEO.MRC_ACCRUAL_POSTED_FLAG, ApInvDistAllEO.MRC_CASH_POSTED_FLAG, ApInvDistAllEO.MRC_DIST_CODE_COMBINATION_ID, ApInvDistAllEO.MRC_AMOUNT, ApInvDistAllEO.MRC_BASE_AMOUNT, ApInvDistAllEO.MRC_BASE_INV_PRICE_VARIANCE, ApInvDistAllEO.MRC_EXCHANGE_RATE_VARIANCE, ApInvDistAllEO.MRC_POSTED_FLAG, ApInvDistAllEO.MRC_PROGRAM_APPLICATION_ID, ApInvDistAllEO.MRC_PROGRAM_ID, ApInvDistAllEO.MRC_PROGRAM_UPDATE_DATE, ApInvDistAllEO.MRC_RATE_VAR_CCID, ApInvDistAllEO.MRC_REQUEST_ID, ApInvDistAllEO.MRC_EXCHANGE_DATE, ApInvDistAllEO.MRC_EXCHANGE_RATE, ApInvDistAllEO.MRC_EXCHANGE_RATE_TYPE, ApInvDistAllEO.MRC_AMOUNT_TO_POST, ApInvDistAllEO.MRC_BASE_AMOUNT_TO_POST, ApInvDistAllEO.MRC_CASH_JE_BATCH_ID, ApInvDistAllEO.MRC_JE_BATCH_ID, ApInvDistAllEO.MRC_POSTED_AMOUNT, ApInvDistAllEO.MRC_POSTED_BASE_AMOUNT, ApInvDistAllEO.MRC_RECEIPT_CONVERSION_RATE, ApInvDistAllEO.CREDIT_CARD_TRX_ID, ApInvDistAllEO.DIST_MATCH_TYPE, ApInvDistAllEO.RCV_TRANSACTION_ID, ApInvDistAllEO.INVOICE_DISTRIBUTION_ID, ApInvDistAllEO.PARENT_REVERSAL_ID, ApInvDistAllEO.TAX_RECOVERABLE_FLAG, ApInvDistAllEO.PA_CC_AR_INVOICE_ID, ApInvDistAllEO.PA_CC_AR_INVOICE_LINE_NUM, ApInvDistAllEO.PA_CC_PROCESSED_CODE, ApInvDistAllEO.MERCHANT_DOCUMENT_NUMBER, ApInvDistAllEO.MERCHANT_NAME, ApInvDistAllEO.MERCHANT_REFERENCE, ApInvDistAllEO.MERCHANT_TAX_REG_NUMBER, ApInvDistAllEO.MERCHANT_TAXPAYER_ID, ApInvDistAllEO.COUNTRY_OF_SUPPLY, ApInvDistAllEO.MATCHED_UOM_LOOKUP_CODE, ApInvDistAllEO.GMS_BURDENABLE_RAW_COST, ApInvDistAllEO.ACCOUNTING_EVENT_ID, ApInvDistAllEO.PREPAY_DISTRIBUTION_ID, ApInvDistAllEO.UPGRADE_POSTED_AMT, ApInvDistAllEO.UPGRADE_BASE_POSTED_AMT, ApInvDistAllEO.INVENTORY_TRANSFER_STATUS, ApInvDistAllEO.COMPANY_PREPAID_INVOICE_ID, ApInvDistAllEO.CC_REVERSAL_FLAG, ApInvDistAllEO.AWT_WITHHELD_AMT, ApInvDistAllEO.INVOICE_INCLUDES_PREPAY_FLAG, ApInvDistAllEO.PRICE_CORRECT_INV_ID, ApInvDistAllEO.PRICE_CORRECT_QTY, ApInvDistAllEO.PA_CMT_XFACE_FLAG, ApInvDistAllEO.CANCELLATION_FLAG, ApInvDistAllEO.INVOICE_LINE_NUMBER, ApInvDistAllEO.CORRECTED_INVOICE_DIST_ID, ApInvDistAllEO.ROUNDING_AMT, ApInvDistAllEO.CHARGE_APPLICABLE_TO_DIST_ID, ApInvDistAllEO.CORRECTED_QUANTITY, ApInvDistAllEO.RELATED_ID, ApInvDistAllEO.ASSET_BOOK_TYPE_CODE, ApInvDistAllEO.ASSET_CATEGORY_ID, ApInvDistAllEO.DISTRIBUTION_CLASS, ApInvDistAllEO.FINAL_PAYMENT_ROUNDING, ApInvDistAllEO.FINAL_APPLICATION_ROUNDING, ApInvDistAllEO.AMOUNT_AT_PREPAY_XRATE, ApInvDistAllEO.CASH_BASIS_FINAL_APP_ROUNDING, ApInvDistAllEO.AMOUNT_AT_PREPAY_PAY_XRATE, ApInvDistAllEO.INTENDED_USE, ApInvDistAllEO.DETAIL_TAX_DIST_ID, ApInvDistAllEO.REC_NREC_RATE, ApInvDistAllEO.RECOVERY_RATE_ID, ApInvDistAllEO.RECOVERY_RATE_NAME, ApInvDistAllEO.RECOVERY_TYPE_CODE, ApInvDistAllEO.RECOVERY_RATE_CODE, ApInvDistAllEO.WITHHOLDING_TAX_CODE_ID, ApInvDistAllEO.TAX_ALREADY_DISTRIBUTED_FLAG, ApInvDistAllEO.SUMMARY_TAX_LINE_ID, ApInvDistAllEO.TAXABLE_AMOUNT, ApInvDistAllEO.TAXABLE_BASE_AMOUNT, ApInvDistAllEO.EXTRA_PO_ERV, ApInvDistAllEO.PREPAY_TAX_DIFF_AMOUNT, ApInvDistAllEO.TAX_CODE_ID, ApInvDistAllEO.VAT_CODE, ApInvDistAllEO.AMOUNT_INCLUDES_TAX_FLAG, ApInvDistAllEO.TAX_CALCULATED_FLAG, ApInvDistAllEO.TAX_RECOVERY_RATE, ApInvDistAllEO.TAX_RECOVERY_OVERRIDE_FLAG, ApInvDistAllEO.TAX_CODE_OVERRIDE_FLAG, ApInvDistAllEO.TOTAL_DIST_AMOUNT, ApInvDistAllEO.TOTAL_DIST_BASE_AMOUNT, ApInvDistAllEO.PREPAY_TAX_PARENT_ID, ApInvDistAllEO.CANCELLED_FLAG, ApInvDistAllEO.OLD_DISTRIBUTION_ID, ApInvDistAllEO.OLD_DIST_LINE_NUMBER, ApInvDistAllEO.AMOUNT_VARIANCE, ApInvDistAllEO.BASE_AMOUNT_VARIANCE, ApInvDistAllEO.HISTORICAL_FLAG, ApInvDistAllEO.RCV_CHARGE_ADDITION_FLAG, ApInvDistAllEO.AWT_RELATED_ID, ApInvDistAllEO.RELATED_RETAINAGE_DIST_ID, ApInvDistAllEO.RETAINED_AMOUNT_REMAINING, ApInvDistAllEO.BC_EVENT_ID, ApInvDistAllEO.RETAINED_INVOICE_DIST_ID, ApInvDistAllEO.FINAL_RELEASE_ROUNDING, ApInvDistAllEO.FULLY_PAID_ACCTD_FLAG, ApInvDistAllEO.ROOT_DISTRIBUTION_ID, ApInvDistAllEO.XINV_PARENT_REVERSAL_ID, ApInvDistAllEO.RECURRING_PAYMENT_ID, ApInvDistAllEO.RELEASE_INV_DIST_DERIVED_FROM, gl_flexfields_pkg.get_concat_description (f.id_flex_num, ApInvDistAllEO.dist_code_combination_id) segments, (SELECT segment1 FROM pa_projects_all ppa WHERE ppa.project_id = apinvdistalleo.project_id) project_number, (SELECT pt.task_number FROM pa_tasks pt WHERE pt.task_id = apinvdistalleo.task_id) task_number, (SELECT NAME FROM hr_all_organization_units hou WHERE hou.organization_id = apinvdistalleo.expenditure_organization_id) expd_org_name FROM AP_INVOICE_DISTRIBUTIONS_ALL ApInvDistAllEO, fnd_id_flex_structures_vl f, ap_invoices_all i, gl_sets_of_books sob where ApInvDistAllEO.invoice_id = i.invoice_id and sob.set_of_books_id = i.set_of_books_id and f.id_flex_num = sob.chart_of_accounts_id and f.id_flex_code = 'GL#' and f.application_id = 101) QRSLT WHERE (:1 = INVOICE_ID) AND (:2 = INVOICE_LINE_NUMBER)

      at oracle.apps.fnd.framework.OAException.wrapperException()
    2. oracle.apps.fnd
      OAPageBean.preparePage
      1. oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
      2. oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169)
      3. oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435)
      4. oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2537)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1889)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:533)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:421)
      7 frames