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

Last updated on OCTOBER 03, 2017

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 PI, 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 Collector Sample:
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 = 548800

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms