My Oracle Support Banner

E-PC:PSSpreadsheet Open Method Fails When Invoked By App Designer. (Doc ID 2717268.1)

Last updated on OCTOBER 06, 2020

Applies to:

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

Symptoms

 Attempting to build an Excel workbook using the PSSpreadsheet object fails if code is placed in App Engine and invoked from within App Designer.

Insert the following code:
Local object &ssObject;
Local any &success;
&ssObject = CreateObject("PSSpreadsheet");
&ssObject.open("C:\temp\sample.xlsx", False);
&ssObject.SetActiveSheetName("Sample");
&ssObject.Save();
Invoke the program from within App Designer and you get:
Sep 08, 2020 10:33:09 AM com.peoplesoft.pt.psspreadsheet.WorkbookManager getWorkbookManager
INFO: Enter getWorkbookManager
Sep 08, 2020 10:33:10 AM com.peoplesoft.pt.psspreadsheet.WorkbookManager getWorkbookManager
INFO: Exit getWorkbookManager
Sep 08, 2020 10:33:10 AM com.peoplesoft.pt.psspreadsheet.WorkbookManager openWorkbook
INFO: Enter openWorkbook
PeopleTools 8.58.05 - Application Engine
Copyright (c) 1988-2020 Oracle and/or its affiliates.
All Rights Reserved
java.lang.NoClassDefFoundError: org/apache/poi/openxml4j/exceptions/InvalidFormatException
com.peoplesoft.pt.psspreadsheet.WorkbookManager.openWorkbook(WorkbookManager.java:207)
Could not create/open workbook for (Open). (28,251) CH_SS_SMPL.MAIN.GBL.default.1900-01-
01.Step01.OnExecute  PCPC:187  Statement:2
 Message Set Number: 28
 Message Number: 251
 Message Reason: Could not create/open workbook for (%1). (28,251)
Process 7070887 ABENDED at Step CH_SS_SMPL.MAIN.Step01 (PeopleCode) -- RC = 8 (108,524)
 Message Set Number: 108
 Message Number: 524
 Message Reason: Process 7070887 ABENDED at Step CH_SS_SMPL.MAIN.Step01 (PeopleCode) -- RC = 8 
(108,524)
Process %s ABENDED at Step %s.%s.%s (Action %s) -- RC =

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.