R12: AP: Payment Process Request (PPR) shows Payment Created but Payment Documents not Created
(Doc ID 1429890.1)
Last updated on MARCH 01, 2024
Applies to:
Oracle Payables - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
Unable to process ACH Payments
A Payment batch / Payment Process Request (PPR) encountered an error during formatting.
The payment documents were not created but the PPR has status 'PAYMENTS_CREATED' and the invoices are stuck in 'Selected for Payment' status.
The error shown in the PPR formatting stage standard log file is:
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.
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.
Steps to reproduce:
- Log into Oracle Applications using a Payables responsibility.
- Open the "Payments Manager Dashboard"
(N) Payments > Entry > Payments Manager - Submit a New Single Payment Process Request (PPR)
- PPR processing continues OK until the Payment Formatting stage.
- Format Payment Instruction concurrent Log file shows the Error described above.
Changes
Data-Fix script ibytermpi(.sql), provided by Oracle Support, was attempted but did not fix the problem PPR.
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 |
| References |