Home / Accounts Payables / Fully paid prepayment showing “Unpaid” Status

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.

 

 

 

........Subsribe OracleSolutions.pk........
OracleSolutions.pk is exclusively meant to guide the newbies to Learn and Share.

About oracle.solutions

Check Also

An Introduction to Financial Statement Generator (FSG)

An Introduction to Financial Statement Generator (FSG) Financial Statement Generator The Financial Statement Generator (FSG) …

Leave a Reply

Skip to toolbar