R12:AP/IBY/FUN: Invoices Stuck in "Selected for Payment” Status And Could Not Identify Which Payment Process Request the Invoice Could be Stuck in
(Doc ID 2092627.1)
Last updated on SEPTEMBER 06, 2022
Applies to:Oracle Financials Common Modules - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Oracle Payables - Version 12.0.0 and later
Information in this document applies to any platform.
Invoice is stuck in 'Selected for Payment' status and cannot be paid. The suspected or the latest Payment Process Request submitted did not select the stuck invoice also.
The suspected Payment Process Request name or CHECKRUN_NAME doesn't exist under AP_INV_SELECTION_CRITERIA_ALL.
The following queries returned no rows:
a) select * from AP_INV_SELECTION_CRITERIA_ALL
where checkrun_name = <PPR_Name>;
b) select * from AP_SELECTED_INVOICES_ALL;
The Master Generic Datafix (MGDF) Diagnostics from Doc Id 1360390.1 didn't return any relevant result for the Invoice ID.
The selection script -- ap_Rel_Inv_frm_TermPPR_sel.sql from Doc ID 874862.1 didn't select any invoices from the suspected Payment Process Request (PPR) that have issue.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document