My Oracle Support Banner

R12.x Format Payment Instruction with Text Output Logfile Errors "For Input String:null" and "Please verify the template is valid" (Doc ID 1634686.1)

Last updated on SEPTEMBER 04, 2024

Applies to:

BI Publisher (formerly XML Publisher) - Version 12.0 and later
Oracle Payments - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Oracle Payables - Version 12.2.11 to 12.2.11 [Release 12.2]
Oracle Payables - Version 12.0.0 to 12.1.3 [Release 12.0 to 12.1]
Information in this document applies to any platform.

Symptoms

IBY_FD_PAYMENT_FORMAT_TEXT Format Payment Instruction with Text Output failed with error, which caused the Payment Process Request (PPR) to be stuck in Formatting status:

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

 
This occurred when using a seeded NACHA template or business has copied a seeded NACHA template.

 

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.