Fully paid prepayment showing “Unpaid” Status
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.
Step 4. Confirm that the data is corrected when viewed in the Oracle Applications.