My Oracle Support Banner

PPR Stuck In Process. Unable To Complete Or Terminate, PPR Partially Committed (Doc ID 1590125.1)

Last updated on MARCH 27, 2024

Applies to:

Oracle Payments - Version 12.1.2 and later
Information in this document applies to any platform.

Symptoms

PPR stuck in process. Unable to complete or terminate.

Payment Process Request is stuck in Processing.

The invoices are still stuck in "Selected for Payment" Status.

PPR says it is "Confirmed Payment" BUT the payments are not recorded. Payments inserted into IBY_PAYMENTS_ALL (IBY Schema) but have not been inserted into AP_CHECKS_ALL (AP Schema).

User is not able to progress the PPR or Terminate it to reprocess the Invoices.

When trying to terminate the Payment instruction, the following error raised:

ERROR
-----------------------
Payment instruction can not be terminated since payment is already completed. You may void the payments.

 

GDF Patch 16655155 (described in Note 874862.1) was applied but did not resolve the issue.

 

FND Log show the following:

oracle.apps.iby.exception.PSException: An error has occured while updating instruction and payment statuses and marking them as complete.
at oracle.apps.iby.scheduler.FDExtractAndFormatting.postResults(FDExtractAndFormatting.java:532)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:324)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:154)
at oracle.apps.fnd.cp.request.Run.main(Run.java:157)

An error has occured while updating instruction and payment statuses and marking them as complete.
An error occurred. Roll back any changes.
Done roll back changes.
Request completed in error.

 

PPR Data:
IBY_PAY_SERVICE_REQUESTS.PAYMENT_SERVICE_REQUEST_STATUS = PAYMENTS_CREATED
IBY_PAY_SERVICE_REQUESTS.CREATE_PMT_INSTRUCTIONS_FLAG = Y
IBY_DOCS_PAYABLE_ALL.DOCUMENT_STATUS = PAYMENT_CREATED (for 30 rows)
IBY_PAYMENTS_ALL.PAYMENT_STATUS = FORMATTED (for 6 rows)
IBY_PAY_INSTRUCTIONS_ALL.PAYMENT_INSTRUCTION_STATUS = FORMATTED_ELECTRONIC
AP_CHECKS_ALL (0 rows retrieved)

APLIST:
Amount Remaining of the Payment Schedule still not equal zero.
AP_PAYMENT_SCHEDULES_ALL.AMOUNT_REMAINING = XXXXX

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
 CodeFix
 DataFix
References


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