E-SQR: PROCESSING-LIMITS On SQR Should Be Increased (Doc ID 1471890.1)

Last updated on SEPTEMBER 20, 2016

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.49 to 8.52 [Release 8.4]
Information in this document applies to any platform.

Goal

The Processing-Limits section is used to define the sizes and limitations of some of the internal structures used by SQR, which has a direct impact on memory requirements.

Due to the limits, SQR programs with large size tends to exceed the limits. In that case, developer has to divide the program into multiple programs.

It takes the developer a long time to divide such programs.

DYNAMICARGS 32767
PROGLINEPARS 65535
PROGLINES 32767
VARIABLES 32767 
etc.

Is there a workaround to resolve this issue?

Solution

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