E-PC: OLE PeopleCode Fails with "OLE Automation error in Workbooks.OPEN: ObjectDoMethod: Unable to get the Open property of the Workbooks class" on 64 Bit Servers (Doc ID 1315663.1)

Last updated on AUGUST 04, 2017

Applies to:

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

Symptoms

Running OLE PeopleCode fails on 64 Bit Servers (Application Servers or Process Schedulers) with the following error:

Error:
--------
OLE Automation error in Workbooks.OPEN: ObjectDoMethod: Unable to get the Open property of the Workbooks class

Steps:
----------
1. Execute the following PeopleCode on a 64 Bit Server(Application Server or Process Scheduler):
Local object &oWorkApp, &oWorkBook;
  &oWorkApp =
CreateObject("COM", "Excel.Application");
  &oWorkBook =
ObjectGetProperty(&oWorkApp, "Workbooks");
ObjectDoMethod(&oWorkBook, "OPEN", "c:\temp\ppg1.xls");
2. Execute the Application Engine on a Process Scheduler running on Windows 2008 64Bit
3. The AE errors out with "OLE Automation error in Workbooks.OPEN: ObjectDoMethod: Unable to get the Open property of the Workbooks class"

Working Condition:
-----------------------------
Running the same code on App Designer / Windows XP works.
When run in background via Windows Service it would only show in Event Viewer.
It can be called both in online PC code and in batch PC code from AE.

Environment:
---------------------
PeopleTools 8.50.09
Windows 2008 Server 64 Bit

Cause

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