Fully paid prepayment showing "Unpaid" Status

Issue:

Fix:

Invalid data in AP_INVOICES_ALL

select * from AP_INVOICES_ALL where invoice_id =&invoice_id find the wrong data

PAYMENT_STATUS_FLAG P

if the invoice is fully paid, the status PAYMENT_STATUS_FLAG should be Y.

To implement the solution, please execute the following steps:

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:
.
create table SR_XXX_aia as
select *
from ap_invoices_all
where invoice_id =&invoice_id;
.
update ap_invoices_all
set payment_status_flag = 'Y'
where invoice_id =&invoice_id;

commit;

-- one row updated

3. If you are satisfied with the results, issue a commit.

4. Confirm that the data is corrected when viewed in the Oracle Applications.