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

Last updated on FEBRUARY 10, 2015

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.
Checked for relevance on 03-Dec-2010.
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.

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