E-SM: PTLT_EXCI Error: Object required Microsoft VBScript runtime error (Doc ID 1400343.1)

Last updated on JUNE 09, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.51 and later
Information in this document applies to any platform.
*** Currency checked Dec 2014 ***
*** Currency checked June 2016 ***

Goal

When using Setup Manager and running the AE process PTLT_EXCI to generate a Excel to CI Template for DEPARTMENT_TBL Component,why is the following message in log file?
Excel Error Number: 424
Excel Error Description: Object required
Excel Error Source: Microsoft VBScript runtime error

Have updated the permission lists HCPPALL (Primary Permission list) and HCSPPRFL (Process Permission list) attached to my user id by adding the DEPARTMENT_TBL in to COMPONENT Interface tab, and gave FULL Access to all 5 actions and also added WEBLIB_SOAPTOCI to the WEB Library tab.
Have given full permission to ExcelToCI2007 and ExcelToCI VB Script file.
I re-sign in and re-ran the PTLT_EXCI process but no improvement and keep generating the same log file with the same error information.

Solution

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