Fully paid prepayment showing “Unpaid” Status

https://aporaclepayables.blogspot.com/2018/06/fully-paid-prepayment-showing-unpaid.html

SOLUTION

Run the following statement to find the issue data
select * from AP_INVOICES_ALL where invoice_id =&invoice_id

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

For implementing the solution, please execute the following steps:

Step 1. Ensure that you have backup your system before applying the recommended solution.

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

A. create table SR_XXX_aia as select * from ap_invoices_all where invoice_id =&invoice_id;

B. update ap_invoices_all set payment_status_flag = ‘Y’ where invoice_id =&invoice_id;


Step 3. If the result are satisfied, issue a commit.

Commit;

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