My Oracle Support Banner

E-UPG: Application Designer Crash With Error "Illegal uncommitted SQL cursor detected" When Partitioning Records In PT 8.56 (Doc ID 2406802.1)

Last updated on JANUARY 03, 2023

Applies to:

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


On : 8.56 version, Application Designer

PeopleSoft App Designer crashed when select 'Tools > Data Administration > Partitioning' in PT 8.56

Illegal uncommitted SQL cursor detected. Close down all windows and reboot. (22,3)

The issue can be reproduced at will with the following steps:
1) Navigate to PeopleTools > Utilities > Partitioning Utilities
2) Select the Record GP_PYE_STAT_WRK
3) Enter the Table Partitioning Attributes, click <Generate Partitioning DDL> button and <Save DDL> button
4) Login to App Designer, open record GP_PYE_STAT_WRK
5) Select Tools > Data Administration > Partitioning. Error message appear.
6) Click <OK> on the error message, The Maintain Partitioning DDL windows is launched
7) Select the [Apply Partitioning] checkbox
8) Click <Save> button or Click <OK> button, the App Designer will be crashed /closed suddenly




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.