My Oracle Support Banner

E-AD Cannot Edit PeopleCode When Referenced Function Is Missing (Doc ID 2007941.1)

Last updated on MAY 01, 2017

Applies to:

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


When Component PeopleCode has a Declare Function statement that refers to a function library and the function that statement refers to does not exist, Application Designer crashes when you try to edit the referring PeopleCode.
"Function function_name not found in PeopleCode program RECORDNAME.FIELDNAME.FieldFormula. (2,301)"
"Illegal uncommitted SQL cursor detected. Close down all windows and reboot. (22,3)”"

PeopleTools 8.53.10

The issue can be reproduced with the following steps:
1. Develop a component that refers to functions in a record-based function library
2. Remove a function from the function library
3. Try to edit the component PeopleCode that referred to the function that had been removed
4. Application Designer reports a couple of errors "Illegal uncommitted SQL cursor detected," then closes itself

This occasionally impacts development since it makes it necessary to restart Application Designer and recreate the deleted function in order to make changes to the PeopleCode that referred to the deleted function.


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.