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

Fully paid prepayment showing “Unpaid” Status


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.




About Syed Saad Ali

With 13 years of experience as a certified and skilled Oracle Database Administrator, I possess the expertise to handle various levels of database maintenance tasks and proficiently perform Oracle updates. Throughout my career, I have honed my analytical abilities, enabling me to swiftly diagnose and resolve issues as they arise. I excel in planning and executing special projects within time-sensitive environments, showcasing exceptional organizational and time management skills. My extensive knowledge encompasses directing, coordinating, and exercising authoritative control over all aspects of planning, organization, and successful project completions. Additionally, I have a strong aptitude for resolving customer relations matters by prioritizing understanding and effective communication. I am adept at interacting with customers, vendors, and management, ensuring seamless communication and fostering positive relationships.

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