APP-SQLAP-10637: The system cannot create this payment

Scenario:

1. Due to typo error made last April 3, 2009, instead of paying 876.48, we paid only 376.48 in actual to tally payment in bank recon.

We did partial payment in oracle and it was successfully validated.  See attached file for invoice #2811347 with the difference of 500.00

1. In order to close invoice#2811347, we need to pay this in next payment batch and problem occurred while we do payment validation.

Please see attach file for the error encountered. This is not the first time we did partial payment and we successfully closed in next payment except this one.

APP-SQLAP-10637: The system cannot create this payment because one or more invoices selected for this payment have also been selected in a payment batch.Reselect the invoices for this payment before continuing

Solution:

AP_SELECTED_INVOICES_ALL is a temporary table that stores
information about invoices selected for payment in a payment batch.
Your Oracle Payables application inserts into this table after you initiate
a payment batch. There will be one row for each invoice that Payables
selects for payment in the current payment batch. When you build
payments in a payment batch, your Oracle Payables application uses
information in this table to create rows in
AP_SELECTED_INVOICE_CHECKS. Information from this table
appears in the Modify Payment Batch window.

AP_SELECTED_INVOICE_CHECKS_ALL is a temporary table that
stores payment information during a payment batch. Your Oracle
Payables application inserts into this table when you build payments in
a payment batch. There will be one row for each payment issued during
the current payment batch. When you confirm a payment batch, your
Oracle Payables application inserts these payments into
AP_CHECKS_ALL and creates a payment file.
Within a payment batch, SELECTED_CHECK_ID in this table joins with
PRINT_SELECTED_CHECK_ID and PAY_SELECTED_CHECK_ID in
AP_SELECTED_INVOICES to associate a selected invoice with its
payment.

AP_SELECTED_INVOICES_ALL和AP_SELECTED_INVOICE_CHECKS_ALL存在那个异常记录,做删除测试

create table ap_selected_invoices_all_bak as select * from ap_selected_invoices_all

create table ap_selected_invoice_checks_bak as select * from ap_selected_invoice_checks_all

select * from ap_selected_invoices_all
where set_of_books_id=1003
and checkrun_name='Quick Payment: ID=82696'
and invoice_id=178023

delete from ap_selected_invoices_all
where set_of_books_id=1003
and checkrun_name='Quick Payment: ID=82696'
and invoice_id=178023

select * from ap_selected_invoice_checks_all
where checkrun_name='Quick Payment: ID=82696'

delete from ap_selected_invoice_checks_all
where checkrun_name='Quick Payment: ID=82696'

此时,在系统中可以做payment动作了,测试成功