My Oracle Support Banner

Create Settlement Batch Not Generating Bank File When Bank Account Has a Hyphen/Dash "-" (Doc ID 2516326.1)

Last updated on MAY 19, 2020

Applies to:

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

Symptoms

On Prod: 12.2.5 version, FC Core

Create Settlement Batch (CSB) was not generating a Bank File

ERROR (CSB Log)

java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:606)
at oracle.apps.xdo.common.xml.XSLT10gR1.invokeProcessXSL(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLT10gR1.transform(Unknown Source)
at oracle.apps.xdo.common.xml.XSLTWrapper.transform(Unknown Source)
at oracle.apps.xdo.template.eft.EFTGenerator.generate(Unknown Source)
at oracle.apps.xdo.template.EFTGeneratorProcessor.process(Unknown Source)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.runProcessTemplate(TemplateHelper.java:6141)
at oracle.apps.xdo.oa.schema.server.TemplateHelper.processTemplate(TemplateHelper.java:3338)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:199)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:62)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:257)
at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:951)
at oracle.apps.iby.scheduler.SchedEFTBatchClose.closeEFTBatch(SchedEFTBatchClose.java:558)
at oracle.apps.iby.scheduler.SchedEFTBatchClose.schedPmt(SchedEFTBatchClose.java:421)
at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:326)
at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:425)
at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:215)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)
Caused by: oracle.xdo.parser.v2.XPathException: Cannot convert 00000123456-01 to number.
at oracle.xdo.parser.v2.XSLStylesheet.flushErrors(XSLStylesheet.java:1534)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:521)
at oracle.xdo.parser.v2.XSLStylesheet.execute(XSLStylesheet.java:489)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:271)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:155)
at oracle.xdo.parser.v2.XSLProcessor.processXSL(XSLProcessor.java:192)
... 22 more

Exception occured during formatting
oracle.apps.iby.exception.PSException: Internal Error to Payment Server:
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:224)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:62)
at oracle.apps.iby.engine.ExtractFormatter.applyFormat(ExtractFormatter.java:257)
at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:951)
at oracle.apps.iby.scheduler.SchedEFTBatchClose.closeEFTBatch(SchedEFTBatchClose.java:558)
at oracle.apps.iby.scheduler.SchedEFTBatchClose.schedPmt(SchedEFTBatchClose.java:421)
at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:326)
at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:425)
at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:215)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

Aborting request..
oracle.apps.iby.exception.PSException: Error: an error occured during formatting API call to XML Publisher.
at oracle.apps.iby.payment.proc.BatchEFTPayment.closeBatch(BatchEFTPayment.java:997)
at oracle.apps.iby.scheduler.SchedEFTBatchClose.closeEFTBatch(SchedEFTBatchClose.java:558)
at oracle.apps.iby.scheduler.SchedEFTBatchClose.schedPmt(SchedEFTBatchClose.java:421)
at oracle.apps.iby.scheduler.Scheduler.doProcess(Scheduler.java:326)
at oracle.apps.iby.scheduler.Scheduler.init(Scheduler.java:425)
at oracle.apps.iby.scheduler.SchedInitiator.runProgram(SchedInitiator.java:215)
at oracle.apps.fnd.cp.request.Run.main(Run.java:156)

Exception occured while processing profile codes : 42 Error: an error occured during formatting API call to XML Publisher.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Create Settlement batch
2. See..program completes successfully but payment system has not received any file
3. Check concurrent Log file to see error

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot process payments

Changes

 

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
Changes
Cause
Solution


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