My Oracle Support Banner

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 FEBRUARY 01, 2019

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 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.

 

Cause

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
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.