R12: AP/IBY: PPR Stuck In Formatting, Payment File Got Created But PPR Cannot Be Confirmed And GDF 19903129 SEL Script Nor Script Recall_AP_payments_completed.sql Are Fetching The Problem PPR (Doc ID 2727381.1)

Last updated on JULY 17, 2024

Applies to:

Symptoms

There is an electronic Payment Instruction that could not be completed because the payment document had a payment document category but a sequence numbering was not assigned. 

The document sequence set has been corrected but the  user is unable to complete the payment instruction.
 
The Payment Instruction can not be terminated since the payments were sent to the bank already.

PPR is stuck in Formatting, payment file got created but PPR cannot be confirmed

The PPR Formatting log may shows the message

No workaround available

The issue matches the issue described in "GDF: STUCK PPR DUE TO PARTIAL COMMIT DATA" but the GDF fix given does not resolve the issue

The issue occurs occasionally, issue cannot be reproduced

Changes

GDF Patch 19903129 SEL Script Does Not Fetch the Problem PPR

Script Recall_AP_payments_completed.sql Does Not Fetch the problem PPR

Cause

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