My Oracle Support Banner

E-PC: PSSpreadsheet SetCell% Functions Are Limited to Be Used Only in One For-Loop (Doc ID 2817545.1)

Last updated on JANUARY 04, 2022

Applies to:

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


Using PSSpreadsheet SetCell% methods inside multiple for-loops, the columns do not get populated as expected. Starting with the second for-loop, only the last 100 rows get populated
In previous PeopleTools(PT) releases, all cells got populated, regardless in how many for-loops those were set.

The issue can be reproduced at will with the following steps:

1. In Application Designer, on a button on the PSTESTUTIL page, added the following PC using SetCell% methods and 2 for-loops e.g.:

2. Test and see the excel file generated: the first column is populated correctly - with numbers from 1 to 1000, while the second column is populated only starting with row 901 to 1000


 Upgrade to PT 8.58.00 or higher.


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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.