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, ApInvDistAllEO.DIST_CODE_COMBINATION_ID OriginalDistCcid, PAP.SEGMENT1 PROJECT_NUM, PAT.TASK_NUMBER PROJECT_TASK_NUMBER, HOU.NAME EXPENDITURE_ORG_NAME, ApInvDistAllEO.PROJECT_ID OLD_PROJECT_ID, ApInvDistAllEO.TASK_ID OLD_TASK_ID, ApInvDistAllEO.EXPENDITURE_TYPE OLD_EXPENDITURE_TYPE, ApInvDistAllEO.EXPENDITURE_ITEM_DATE OLD_EXPENDITURE_ITEM_DATE, ApInvDistAllEO.EXPENDITURE_ORGANIZATION_ID OLD_EXPENDITURE_ORG_ID, ApInvDistAllEO.AMOUNT OLD_AMOUNT, sob.chart_of_accounts_id, xx_sagt_func1(i.invoice_id) VALUEONE, xx_sagt_func2(i.invoice_id) VALUETWO FROM AP_INVOICE_DISTRIBUTIONS_ALL ApInvDistAllEO, fnd_id_flex_structures_vl f, ap_invoices_all i, gl_sets_of_books sob, PA_PROJECTS_ALL PAP, PA_TASKS PAT, HR_ORGANIZATION_UNITS HOU 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 AND ApInvDistAllEO.project_id = PAP.project_id AND ApInvDistAllEO.task_id = PAT.task_id AND ApInvDistAllEO.expenditure_organization_id = HOU.organization_id (+)) QRSLT WHERE (:1 = INVOICE_ID) AND (:2 = INVOICE_LINE_NUMBER)

Oracle Community | 1022129 | 2 years ago
  1. 0

    EO based VO extension with bind variables and view link - How To

    Oracle Community | 2 years ago | 1022129
    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, ApInvDistAllEO.DIST_CODE_COMBINATION_ID OriginalDistCcid, PAP.SEGMENT1 PROJECT_NUM, PAT.TASK_NUMBER PROJECT_TASK_NUMBER, HOU.NAME EXPENDITURE_ORG_NAME, ApInvDistAllEO.PROJECT_ID OLD_PROJECT_ID, ApInvDistAllEO.TASK_ID OLD_TASK_ID, ApInvDistAllEO.EXPENDITURE_TYPE OLD_EXPENDITURE_TYPE, ApInvDistAllEO.EXPENDITURE_ITEM_DATE OLD_EXPENDITURE_ITEM_DATE, ApInvDistAllEO.EXPENDITURE_ORGANIZATION_ID OLD_EXPENDITURE_ORG_ID, ApInvDistAllEO.AMOUNT OLD_AMOUNT, sob.chart_of_accounts_id, xx_sagt_func1(i.invoice_id) VALUEONE, xx_sagt_func2(i.invoice_id) VALUETWO FROM AP_INVOICE_DISTRIBUTIONS_ALL ApInvDistAllEO, fnd_id_flex_structures_vl f, ap_invoices_all i, gl_sets_of_books sob, PA_PROJECTS_ALL PAP, PA_TASKS PAT, HR_ORGANIZATION_UNITS HOU 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 AND ApInvDistAllEO.project_id = PAP.project_id AND ApInvDistAllEO.task_id = PAT.task_id AND ApInvDistAllEO.expenditure_organization_id = HOU.organization_id (+)) QRSLT WHERE (:1 = INVOICE_ID) AND (:2 = INVOICE_LINE_NUMBER)
  2. 0

    Daniel Borgstrom talking about Oracle: Fix for java.sql.SQLException: Invalid column type when extending a VO

    blogspot.com | 3 months ago
    oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.   Statement: SELECT * FROM (SELECT ca.location LocId, ca.party_site_number LocNumber, ca.party_name PartyName, ca.party_number PartyNumber, ca.address1 Address1, ca.address2 Address2, ca.address3 Address3, ca.address4 Address4, ca.city City, ca.state State, ca.zip PostalCode, ca.country Country, ca.party_id partyId, hzp.site_use_type CurrSiteUsage FROM csi_hzpty_addresses_v ca, hz_party_site_uses hzp, hz_cust_acct_sites_all hcas, hz_cust_site_uses_all hcsu WHERE ca.party_id = :1 AND ca.location = hzp.party_site_id(+) AND site_use_type(+) = 'INSTALL_AT' AND ca.status = 'A' AND SYSDATE BETWEEN NVL(ca.start_date_active, SYSDATE) AND NVL(ca.end_date_active, SYSDATE) AND hzp.status(+) = 'A' AND ca.location = hcas.party_site_id AND hcsu.cust_acct_site_id = hcas.cust_acct_site_id AND hcsu.status = 'A' AND hcsu.site_use_code = 'SHIP_TO' AND hcas.org_id = nvl(FND_PROFILE.VALUE('ORG_ID'), hcas.org_id) AND hcsu.org_id = nvl(FND_PROFILE.VALUE('ORG_ID'), hcsu.org_id)) QRSLT WHERE (( UPPER(ADDRESS1) like UPPER(:2) AND (ADDRESS1 like :3 OR ADDRESS1 like :4 OR ADDRESS1 like :5 OR  ADDRESS1 like :6)))
  3. 0

    oracle.apps.fnd.framework.OAException: java.lang.NullPointerException at

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

    Automated exception search integrated into your IDE

  5. 0

    oracle.jbo.NoDefException: JBO-25058: Definition ColumnName of type Attribute not found in NameOfVO1

    Oracle Community | 3 years ago | user5803804
    oracle.apps.fnd.framework.OAException: oracle.jbo.NoDefException: JBO-25058: Definition CustomerName of type Attribute not found in CustNameLovVO1
  6. 0

    Could not load application module error in EBS 12.0.6 / JDev 10.1.3.3

    Oracle Community | 5 years ago | elcaro
    oracle.apps.fnd.framework.OAException: Could not load application module 'oracle.apps.icx.por.rcv.server.ReceivingHomeAM'.

    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, ApInvDistAllEO.DIST_CODE_COMBINATION_ID OriginalDistCcid, PAP.SEGMENT1 PROJECT_NUM, PAT.TASK_NUMBER PROJECT_TASK_NUMBER, HOU.NAME EXPENDITURE_ORG_NAME, ApInvDistAllEO.PROJECT_ID OLD_PROJECT_ID, ApInvDistAllEO.TASK_ID OLD_TASK_ID, ApInvDistAllEO.EXPENDITURE_TYPE OLD_EXPENDITURE_TYPE, ApInvDistAllEO.EXPENDITURE_ITEM_DATE OLD_EXPENDITURE_ITEM_DATE, ApInvDistAllEO.EXPENDITURE_ORGANIZATION_ID OLD_EXPENDITURE_ORG_ID, ApInvDistAllEO.AMOUNT OLD_AMOUNT, sob.chart_of_accounts_id, xx_sagt_func1(i.invoice_id) VALUEONE, xx_sagt_func2(i.invoice_id) VALUETWO FROM AP_INVOICE_DISTRIBUTIONS_ALL ApInvDistAllEO, fnd_id_flex_structures_vl f, ap_invoices_all i, gl_sets_of_books sob, PA_PROJECTS_ALL PAP, PA_TASKS PAT, HR_ORGANIZATION_UNITS HOU 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 AND ApInvDistAllEO.project_id = PAP.project_id AND ApInvDistAllEO.task_id = PAT.task_id AND ApInvDistAllEO.expenditure_organization_id = HOU.organization_id (+)) 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:912)
      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:2685)
      5. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1950)
      6. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:550)
      7. oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:438)
      7 frames
    3. Unknown
      _OA._jspService
      1. _OA._jspService(_OA.java:212)
      1 frame
    4. com.orionserver.http
      OrionHttpJspPage.service
      1. com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59)
      1 frame
    5. oracle.jsp.runtimev2
      JspServlet.service
      1. oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390)
      2. oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594)
      3. oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518)
      3 frames
    6. JavaServlet
      HttpServlet.service
      1. javax.servlet.http.HttpServlet.service(HttpServlet.java:856)
      1 frame
    7. com.evermind.server
      ResourceFilterChain.doFilter
      1. com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64)
      1 frame
    8. oracle.apps.jtf
      ReleaseResFilter.doFilter
      1. oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26)
      1 frame
    9. com.evermind.server
      EvermindFilterChain.doFilter
      1. com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15)
      1 frame
    10. oracle.apps.fnd
      AppsServletFilter.doFilter
      1. oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318)
      1 frame
    11. com.evermind.server
      AJPRequestHandler.run
      1. com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642)
      2. com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391)
      3. com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908)
      4. com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458)
      5. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313)
      6. com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199)
      6 frames
    12. oracle.oc4j.network
      ServerSocketReadHandler$SafeRunnable.run
      1. oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260)
      1 frame
    13. com.evermind.util
      ReleasableResourcePooledExecutor$MyWorker.run
      1. com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303)
      1 frame
    14. Java RT
      Thread.run
      1. java.lang.Thread.run(Thread.java:619)
      1 frame