E-SQL/DB: Meta-SQL %InsertSelect Incorrectly Resolves %SQL if it Exceeds 99 Override Fields
(Doc ID 2750252.1)
Last updated on APRIL 04, 2025
Applies to:
PeopleSoft Enterprise PT PeopleTools - Version 8.58 and laterInformation in this document applies to any platform.
Symptoms
On : PT 8.58 version,
A customized app engine program tries to use %InsertSelect and %SQL to create a dynamic SQL to run, but the SQL resolves incorrectly on some %SQL construct, thereby causing the program to error out.
Issue can be replicated as follows:
1. Import the test project.
2. Open the SQL definition.
For example,
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |