My Oracle Support Banner

E-AWE: Percent % Variables Not Resolving In Approval Framework Email Notifications. (Doc ID 2306340.1)

Last updated on DECEMBER 16, 2019

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.52 and later
PeopleSoft Enterprise SCM eProcurement - Version 9.1 and later
PeopleSoft Enterprise SCM Purchasing - Version 9.1 and later
Information in this document applies to any platform.


On : Approval Framework Workflow (AWE) Email Notification

Variables from Generic Templates are not resolving in AWE Email notifications, the % # are showing up instead of the data values populating.  The Configure Transaction Route for Approval includes the SQL Object Identifier. The SQLID is correct in Application Designer, and contains all the SELECT fields used in Generic Template are present.   The SQL when run outside of the system works and returns correct values.  The Trace is showing NULL for the SQLID;

Expectation is that the variables would be resolved and data populated in the AWE Email notification.

The issue can be reproduced at will with the following steps:
1. Submit Requisition.
2. Receive Email notification
3. Observe that only the %1 for URL is populated, none of the other variables are populated.


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.