Fully paid prepayment showing “Unpaid” Status

ERROR

Fully paid prepayment showing “Unpaid” Status

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.