PeopleTools and Lifecycle Management - PSFT (MOSC)

MOSC Banner

Problem with guid mismatch on approval workflow emails

edited Nov 25, 2017 4:01AM in PeopleTools and Lifecycle Management - PSFT (MOSC) 1 commentAnswered

I sent a user an approval workflow email.  The guid in the email body reads *emcGuid=328532596622754603893880173447*emcField1=A

Peoplesoft stored the guid as 328532596622754603893880173447 in the database at time of sending.  The EOAWEMC application engine program is reading the email and comes up with a guid of 328532596622754603893880173447*emcFi .  The application engine program is attempting to execute the following sql exec statement: SELECT GUID,MSGNAME,TO_CHAR(CAST((EOAW_DATETIME_SENT) AS TIMESTAMP),'YYYY-MM-DD-HH24.MI.SS.FF'),EOAW_SENT_TO,USERID,COMPLETE_FLAG,EOAWEMC_SENTTO_CHK FROM PS_EOAWEMC_PND_HDR WHERE GUID=:1  The sql exec returns no results because of the guid mismatch.  I'm trying to figure out why there is a mismatch.  Why does the application engine program select more characters.  Any ideas?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

PSFT PeopleTools Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center