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 JUNE 07, 2017

Applies to:

Oracle Payables - Version 12.0.0 and later
Oracle Financials Common Modules - Version 12.0.0 and later
Oracle Payments - Version 12.0.0 and later
Information in this document applies to any platform.

Symptoms

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 - "R12: Master GDF Diagnostic (MGD) to Validate Data Related to Invoices, Payments, Accounting, Suppliers and EBTax" 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 -"R12: Generic Data Fix (GDF) patch for "stuck" invoices after PPR is terminated or completed"

didn't select any invoices from the suspected Payment Process Request (PPR)  that have issue.

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms