E-CI: ExcelToCI Gave "Type Mismatch" VB Runtime Error At FormatNumber Function When Submitting Data

(Doc ID 2018730.1)

Last updated on JUNE 12, 2015

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.50 and later
Information in this document applies to any platform.


Application & Version: PT 8.53.04/FSCM 9.2

Using ExceltoCI utility to upload historical data via INTFC_FINPHY_SS_A Component Interface, when submitting data, it gave below error, then stop at FormatNumber() function on Visual basic editor.

Error seen on screen

Microsoft Visual Basic
Run-time error '13':
Type mismatch



Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms