R12/AP: An Error Has Occurred While Updating Instruction And Payment Statuses And Marking Them As Complete

Last updated on OCTOBER 27, 2017

Applies to:

Symptoms

  A Payment Process Request (PPR) is formatted but errors occur:

An error has occurred while updating instruction and payment statuses and marking them as complete.
An error occurred. Roll back any changes.
Done roll back changes.

The Build program works for expense reports between 10 and 68 invoices. However anything over 68 causes the payment batch to fail.

After testing the same PPR parameters with a smaller number of invoices the batch processes without errors.  Error in the format logfile:


length of the output - baos::14131
After formatting, periodicSeq is null or empty.{}
length of the output - baos::14131
Exit: iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon()
Saving format output.
Enter: iby.scheduler.FDExtractAndFormatting.queryFileSysAttributes
Querying file system output attributes
ppDir: /data/IOFP/bacs_download
ppExt: null
ppPre: 20177340
File system output settings that override the concurrent program default: {OUTPUT_FILE_PREFIX=20177340, OUTPUT_DIR=/data/IOFP/bacs_download}
Enter: iby.scheduler.FDFormatProgramUtils.saveToFileSystemCustom()
Concurrent request output file name: /var/opt/oraapps/IOFP/applcsf/out/o762367.out
File.separator: /
Custom file name: /data/IOFP/bacs_download/20177340o762367.out
Opened file in append mode: /data/IOFP/bacs_download/20177340o762367.out
Updating FND request record for the custom file location/data/IOFP/bacs_download/20177340o762367.out
request id: 762367
Exit: iby.scheduler.FDFormatProgramUtils.saveToFileSystemCustom()
Enter: iby.scheduler.FDExtractAndFormatting.saveFormatOutput()
15-Mar-2010 13:53:42 oracle.adf.share.config.ADFConfigFactory findOrCreateADFConfig
INFO: oracle.adf.share.config.ADFConfigFactory No META-INF/adf-config.xml found
Format output not exist. Saving it.
Saved attachment doc id: 211365
Exit: iby.scheduler.FDExtractAndFormatting.saveFormatOutput()
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.
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.

Cause