My Oracle Support Banner

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


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.