APP-SQLAP-10637 the system can’t create this payment because one or more invoices selected for thispaymeny have also been selected in a payment batch

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

Problem: APP-SQLAP-10637 the system can’t create this payment because one or more invoices selected for thispaymeny have also been selected in a payment batch






Symptoms:
2 invoices can’t be selected for payment, the record stuck in the AP_SELECTED_INVOICES_ALL table

while creating the payment and selecting the invoices when save system is giving error APP-SQLAP-10637 the system can’t create this payment because one or more invoices selected for this payment have also been selected in a payment batch,...



Solution:



To implement the solution, please execute the following steps::
in your TEST instance FIRST :

1. Ensure that you have taken a backup of your system before applying the
recommended solution.

2. Run the following scripts in a TEST environment first:

1. Backup:
--------------
CREATE TABLE TAR_3_2171544221_ASIA AS
SELECT * FROM AP_SELECTED_INVOICES_ALL where checkrun_name like 'Quick Payment: ID=172102';

select count(*) from TAR_3_2171544221_ASIA;

-- 2 rows should be selected.

CREATE TABLE TAR_3_2171544221_ASICA AS
SELECT * from AP_SELECTED_INVOICE_CHECKS_ALL where checkrun_name like 'Quick Payment: ID=172102' ;

select count(*) from TAR_3_2171544221_ASICA;

-- 2 rows should be selected.

2. Fix:
--------

delete from AP_SELECTED_INVOICES_ALL where checkrun_name in (select
checkrun_name from TAR_3_2171544221_ASIA) ;

-- 2 rows should be deleted

delete from AP_SELECTED_INVOICE_CHECKS_ALL where checkrun_name in (select
checkrun_name from TAR_3_2171544221_ASICA);

-- 2 rows should be deleted

3. Commit if appropriate number of records are deleted.


5. Once the scripts complete, confirm that the data is corrected.
You can use the following SQL to confirm:

select count(*) from AP_SELECTED_INVOICES_ALL where checkrun_name in (select
checkrun_name from TAR_3_2171544221_ASIA) ;

It should display Zero


6. Confirm that the data is corrected whith the following steps in the Oracle Applications.

Try to pay the invoice


7. Migrate the solution as appropriate to other environments.

References:

Get Oracle Certifications for all Exams
Free Online Exams.com