My Oracle Support Banner

E-AD: "Resolve Meta SQL" Option From Application Designer Changes '.' To '_' (Doc ID 2830259.1)

Last updated on MARCH 16, 2022

Applies to:

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


"Resolve Meta SQL" option changes '.' to '_' .
The expected behavior is "Resolve Meta SQL" to not interfere with the SQL logic/formatting.

This behavior will not cause any issue when the SQL is saved

The issue can be reproduced at will with the following steps:
1. Login in Application Designer
2. Create new SQL definition
3. Write: ':'||a.test
4. Right-click in the SQL window and select "Resolve Meta SQL"
5. See results: ':'||a_test
6. When including a space before/after the pipe line, the meta SQL resolves correct i.e. ':'|| a.test




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.