R12: IBY: Format Payment Instructions with Text Output Program Completes With Error ORA-20001: APP-FND-01728: An Assignment Does Not Exist For These Parameters
(Doc ID 2930419.1)
Last updated on JULY 16, 2024
Applies to:
Oracle Payables - Version 12.0.0 to 12.2.12 [Release 12.0 to 12.2]Information in this document applies to any platform.
Symptoms
Format Payment Instructions with Text Output Program ends with error:
IBY_FD_PAYMENT_FORMAT_TEXT: Format Payment Instructions with Text Output
+---------------------------------------------------------------------------+
Exit: iby.scheduler.FDExtractAndFormatting.doExtractAndFormat()
Instruction status was CREATED and the transmission configuration is not avaible. So setting result status to FORMATTED_ELECTRONIC
Enter: iby.scheduler.FDExtractAndFormatting.postResults()
Executing BEGIN IBY_FD_POST_PICP_PROGS_PVT.post_results(:1, :2, :3, :4); END;
Successfully executed PL/SQL.
Inside catch of runProgram before calling of handleProgramException
Inside the handleProgramException--- : iby.scheduler.FDExtractAndFormatting.runProgram()
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:583)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:357)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:179)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)
ex:oracle.apps.iby.exception.PSException: An error has occured while updating instruction and payment statuses and marking them as complete.iby.scheduler.FDExtractAndFormatting.runProgram()
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.
CP main completed runProgram for oracle.apps.iby.scheduler.FDExtractAndFormatting
ERROR Code : -20001
ERROR Msg : ORA-20001: APP-FND-01728: An assignment does not exist for these parameters.
Cause: An attempt was made to find a sequence for this document flexfield. The profile option says Sequential Numbering is only partially used.
Action: None is necessary unless you expected this document flexfield to have a sequence defined.
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Navigate to Payables Responsibility
2. Payment Manager and submit a new Payment Process Request(PPR)
3. PPR gets stuck at Formatting Stage and Format Payment Instructions with Text Output program got completed in error.
Changes
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 |