E-AD: Validate Syntax Fails for SQLs using Meta-SQL Elements such as %Select
(Doc ID 2193483.1)
Last updated on FEBRUARY 01, 2019
Applies to:PeopleSoft Enterprise PT PeopleTools - Version 8.55 and later
Information in this document applies to any platform.
When using Meta-SQL such as %Select in the Application Designer SQL Editor, and one tries to validate the SQL, errors would occur:
MS SQL Server platform:
Error executing prepare
Sample Replication Steps:
1. Launch App Designer
2. File > New Definition > SQL
3. Copy & paste the below into the SQL Editor
4. Click the Validate button
5. Error occurs
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