How to fix data post failure of IBY_FD_RECORD_PRINT_STATUS
Multiple (17) instances of IBY_FD_RECORD_PRINT_STATUS concurrent program were waiting on "latch: cache buffers chains" for the same Sql Hash Value of 1286279379. We expected the 17 instances to finish within an hour. This concurrent program was terminated through the GUI after 12 hours .
This is the last program that is run before our process extracts data for OFS db for use in other processes. I believe that the program updates ap.ap_invoices_all (payment_status_flag = "Y") and ap.ap_paymens_schedule_all (payment_status_flag="Y") and removes rows from ap.ap_selected_invoices_all table.
Now we want to manually "fix" the data.
This is the last program that is run before our process extracts data for OFS db for use in other processes. I believe that the program updates ap.ap_invoices_all (payment_status_flag = "Y") and ap.ap_paymens_schedule_all (payment_status_flag="Y") and removes rows from ap.ap_selected_invoices_all table.
Now we want to manually "fix" the data.
Tagged:
0