R12 : Unable To Complete Payment Instructions If Sequential Numbering Is Partially Used (Doc ID 437551.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Payables - Version: 12.0.1
This problem can occur on any platform.
PATCHSET:12.0.3

Symptoms

-- Problem Statement:
On 12.0.1 through 12.0.4 in Production:
When attempting to format a payment process request the following error occurs:

ERROR
The format payment instructions fails in error  and remains at status 'Formatting'.

The error message in the log file of the program  : IBY_FD_PAYMENT_FORMAT module: Format Payment Instructions  is ;

"oracle.apps.iby.exception.PSException: An error has occurred while updating instruction and payment
statuses and marking them as complete.
at oracle.apps.iby.scheduler.FDExtractAndFormatting.postResults(FDExtractAndFormatting.java:501)
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 occurred while updating instruction and payment statuses and marking them as complete.
An error occurred. Roll back any changes"


-- Steps To Reproduce:
The issue can be reproduced at will with the following steps:
1. In the Payment Process manager
2. select the payment process request XX-4
3. the status is Formatting ,
4. In the Payment Process TAB , click on Action ,
the format program is processing but fails in error  again in the same status.

-- Business Impact:
The issue has the following business impact:
Due to this issue, users cannot complete the payment process manager for the payment
process request XX-4.

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