My Oracle Support Banner

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 DECEMBER 10, 2019

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:

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

The issue can be replicated with the following 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.

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.