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.

Symptoms

ISSUE STATEMENT
---------------
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.
  
ERROR
---------------
"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)”"

ENVIRONMENT
---------------
PeopleTools 8.53.10

STEPS
---------------
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

IMPACT
---------------
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.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms