R12/AP: An Error Has Occurred While Updating Instruction And Payment Statuses And Marking Them As Complete
(Doc ID 1108941.1)
Last updated on OCTOBER 27, 2017
Applies to:
Oracle Payables - Version 12.1.1 to 12.1.2 [Release 12.1] Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!