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.
Symptoms
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 TXXXXXXX6.uxxxxxxp.com 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.
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:
- Create and Validate Invoice via the Invoice Workbench
- Create a PPR to pay invoice via the Payment Dashboard
- Invoice is "Selected for Payment"
- PPR is cancelled
- Invoice still shows as "Selected for Payment"
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |