My Oracle Support Banner

R12: IBY: Format Payment Instructions with Text Output Ends In An Error "an error occurred during formatting. Please verify the template is valid." (Doc ID 2950542.1)

Last updated on JULY 04, 2023

Applies to:

Oracle Payments - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Format Payment Instructions with Text Output Ends In An Error "an error occurred during formatting. Please verify the template is valid."

the following error occurs.

ERROR
-----------------------

java.lang.NumberFormatException: For input string: "null"
at java.lang.NumberFormatException.forInputString(NumberFormatException.java:65)
at java.lang.Integer.parseInt(Integer.java:492)
at java.lang.Integer.parseInt(Integer.java:527)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:6167)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3511)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:119)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:281)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:394)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:241)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:97)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:484)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:300)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runProgram(FDExtractAndFormatting.java:179)
at oracle.apps.fnd.cp.request.Run.main(Run.java:159)

Error: an error occurred during formatting. Please verify the template is valid.
Inside catch of runProgram before calling of handleProgramException
Inside the handleProgramException--- : iby.scheduler.FDExtractAndFormatting.runProgram()
oracle.apps.iby.exception.PSException: Internal Error to Payment Server: For input string: "null"
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:163)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:281)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCore(FDFormatProgramUtils.java:394)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doExtractAndFormatCommon(FDFormatProgramUtils.java:241)
at oracle.apps.iby.scheduler.FDFormatProgramUtils.doPmtInstrExtractAndFormat(FDFormatProgramUtils.java:97)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.doExtractAndFormat(FDExtractAndFormatting.java:484)
at oracle.apps.iby.scheduler.FDExtractAndFormatting.runMainLogic(FDExtractAndFormatting.java:300)
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: Internal Error to Payment Server: For input string: "null"iby.scheduler.FDExtractAndFormatting.runProgram()
Internal Error to Payment Server: For input string: "null"
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
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+

 

Steps to reproduce:

  1. Navigate to Payables Responsibility --> Payments --> Payments Manager
  2. Submit Payment Process Request

 

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
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.