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)

Solutions on the web1041

  • via Oracle Community by 1022129, 11 months ago
    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
  • ) 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)
  • via Oracle Community by user11969884, 11 months ago
    oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select * from omaxe_work_order_headers where work_order_number is not null) QRSLT WHERE (PROJECT_NAME =:1 AND CONTRACTOR_NAME=:2)
  • Stack trace

    • 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(OAException.java:912) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.prepareException(OAPageErrorHandler.java:1169) at oracle.apps.fnd.framework.webui.OAPageErrorHandler.processErrors(OAPageErrorHandler.java:1435) at oracle.apps.fnd.framework.webui.OAPageBean.processRequest(OAPageBean.java:2685) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:1950) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:550) at oracle.apps.fnd.framework.webui.OAPageBean.preparePage(OAPageBean.java:438) at _OA._jspService(_OA.java:212) at com.orionserver.http.OrionHttpJspPage.service(OrionHttpJspPage.java:59) at oracle.jsp.runtimev2.JspPageTable.service(JspPageTable.java:390) at oracle.jsp.runtimev2.JspServlet.internalService(JspServlet.java:594) at oracle.jsp.runtimev2.JspServlet.service(JspServlet.java:518) at javax.servlet.http.HttpServlet.service(HttpServlet.java:856) at com.evermind.server.http.ResourceFilterChain.doFilter(ResourceFilterChain.java:64) at oracle.apps.jtf.base.session.ReleaseResFilter.doFilter(ReleaseResFilter.java:26) at com.evermind.server.http.EvermindFilterChain.doFilter(EvermindFilterChain.java:15) at oracle.apps.fnd.security.AppsServletFilter.doFilter(AppsServletFilter.java:318) at com.evermind.server.http.ServletRequestDispatcher.invoke(ServletRequestDispatcher.java:642) at com.evermind.server.http.ServletRequestDispatcher.forwardInternal(ServletRequestDispatcher.java:391) at com.evermind.server.http.HttpRequestHandler.doProcessRequest(HttpRequestHandler.java:908) at com.evermind.server.http.HttpRequestHandler.processRequest(HttpRequestHandler.java:458) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:313) at com.evermind.server.http.AJPRequestHandler.run(AJPRequestHandler.java:199) at oracle.oc4j.network.ServerSocketReadHandler$SafeRunnable.run(ServerSocketReadHandler.java:260) at com.evermind.util.ReleasableResourcePooledExecutor$MyWorker.run(ReleasableResourcePooledExecutor.java:303) at java.lang.Thread.run(Thread.java:619)

    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, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    Unknown user
    Once, 1 year ago
    14 more bugmates