Last updated on SEPTEMBER 11, 2017
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.
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