My Oracle Support Banner

R12: AP/IBY: Invoice Status is "Selected For Payment" but Payment Process Request (PPR) Shows "No Invoice Selected" and PPR Status is "Cancelled - No Invoices Selected" (Doc ID 2950665.1)

Last updated on APRIL 12, 2024

Applies to:

Oracle Payables - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.


Unable to pay invoice via a payment batch.

Invoice status is "Selected for Payment" and the last Payment Process Request (PPR) that selected it has status "Cancelled - No Invoices Selected".

Unable to terminate the PPR via the "Payment Dashboard".

Data-fix script ap_Rel_Inv_frm_TermPPR_sel.sql from R12: Generic Data Fix (GDF) Patch for "Stuck" Invoices After PPR is Terminated or Completed, did not fetch the problem invoice.  Script output shows:

Selection script executed on instance prod host_name on 24-APR-23
The ap_Rel_Inv_frm_TermPPR_sel.sql select file version is : 120.0.12000000.22
Validating PPR name - 799XXXXXXXXXCHKUSD

This GDF releases invoices from the PPR if the PPR is in TERMINATED/CONFIRMED or if stuck in Selecting/Calculating/New/Canceling/Invoices Pending Review/Selected status and are still holding invoices.

There is no PPR in TERMINATED/CONFIRMED or Selecting/Calculating/New/Canceling/Invoices Pending Review/Selected state which this AP GDF can release.

If you still have this PPR stuck, please follow these steps
1. Ensure that you have patches 9074848:R12.AP.A (for 12.0.x) or 9460510:R12.AP.B (for 12.1.x) applied.
2. Try terminating the PPR from PPR Search Page UI using 'Terminate' icon.
3. The PPR will either get terminated or a message will be shown why it can't be terminated at this moment.
4. If you still seek clarification/help from Development, please log bug with Development giving the above message and confirmation that the above patches are applied.

Notice the highlighted line.


Steps to reproduce:

  1. Create and Validate Invoice via the Invoice Workbench
  2. Create a PPR to pay invoice via the Payment Dashboard
  3. Invoice is "Selected for Payment"
  4. PPR is cancelled
  5. Invoice still shows as "Selected for Payment"






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

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