Format Payment Instructions errors with ORA-01422: exact fetch returns more than requested number of
Our PPR fails on the Format Payment Instruction with the following error:
ORA-06512: at "APPS.IBY_EXTRACTGEN_PVT", line 380
ORA-06512: at line 1
Would anyone able to help track down which supplier/bank info would cause this or any other ways of a starting point to debug this ? I've created a SR but no response as yet.
Below is the full log of the error:
+---------------------------------------------------------------------------+
Payments: Version : 12.0.0
Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
IBY_FD_PAYMENT_FORMAT_TEXT module: Format Payment Instructions with Text Output
+---------------------------------------------------------------------------+
Current system time is 27-FEB-2013 10:35:37
+---------------------------------------------------------------------------+
FDExtractAndFormatting->runProgram():TEST
RequestId:(TEST)13176218
Start time:(TEST) Wed Feb 27 10:35:48 MST 2013