The invoice was paid partially by a payment, the record still stuck in the selected invoices for payment table so it can be choosen for a new payment, Datafix required

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:    

The invoice was paid partially by a payment, the record still stuck in the selected invoices for payment table so it can be choosen for a new payment, Datafix required

Solution:

he invoice was paid partially by a payment, the record still stuck in the selected invoices for payment table so it can be choosen for a new payment, Datafix required

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:

3. Stop all users from using concurrent or on-line accounting until this process is finished.

4.

>> backup
create table SR_3_1774038931_asia_2 as
select *
from AP_SELECTED_INVOICES_ALL
where CHECKRUN_NAME = 'Quick Payment: ID=171827'
and PAY_SELECTED_CHECK_ID = 169088
and INVOICE_ID = 277823
and ORG_ID = 116;

select count(*) from SR_3_1774038931_asia_2;
--1 row selected

create table SR_3_1774038931_asica_2 as
select *
from AP_SELECTED_INVOICE_CHECKS_All
where CHECKRUN_NAME = 'Quick Payment: ID=171827'
and SELECTED_CHECK_ID = 169088
and ORG_ID = 116;

select count(*) from SR_3_1774038931_asica_2;
--1 row selected

>> delete records

delete from AP_SELECTED_INVOICES_ALL
where CHECKRUN_NAME in
(select CHECKRUN_NAME from SR_3_1774038931_asia_2);
--1 row deleted

delete from AP_SELECTED_INVOICE_CHECKS_ALL
where CHECKRUN_NAME in
(select CHECKRUN_NAME from SR_3_1774038931_asica_2);
--1 row deleted

Get Oracle Certifications for all Exams
Free Online Exams.com