R12:AP/IBY: Payment Process Request (PPR) Stuck in Status Formatting (Doc ID 561048.1)

Last updated on APRIL 04, 2025

Applies to:

Oracle Payments - Version 12.0.1 to 12.0.5 [Release 12.0]
Oracle Payables - Version 12.0.1 to 12.0.5 [Release 12.0]
Information in this document applies to any platform.

Oracle iPayment - Version: 12.0.1 to 12.0.5
IBY_FD_PAYMENT_FORMAT

Symptoms

When attempting to format a payment process request the following error occurs:

ERROR
The PPR gets stuck in status Formatting.
In the Formatting log the following error appears:

IBY_FD_PAYMENT_FORMAT module: Format Payment Instructions
...
Executing BEGIN IBY_FD_POST_PICP_PROGS_PVT.post_results(:1, :2, :3, :4); END;
Successfully executed PL/SQL.
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:502)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:306)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:141)
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.

-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. Enter invoice
2. Validate and approve
3. Create payment request using correct bank account
4. After select and build exclude some invoices but keep more then one invoice to be paid.
5. Submit the Format Payment Instruction process
6, This process/concurrent request will never complete and all PPRs get stuck.

Please note that there are other situations when log does not show any error but PPR will still remain - in Payments Dashboard - in status Formatting.