Format Payment Instructions Fail with "An error has occured while updating instruction and payment statuses and marking them as complete." (Doc ID 1276122.1)

Last updated on OCTOBER 04, 2024

Applies to:

Symptoms

Format Payment Instructions failing with the following error:

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:502)
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 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.

ERROR Code : -20001
ERROR Msg : ORA-20001: APP-SQLAP-10000: ORA-01403: no data found occurred in
AP_WITHHOLDING_PKG.Create_AWT_distributions<-AP_WITHHOLDING_PKG.AP_Do_Withholding

Cause

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