Oracle Community Directory
Oracle Community FAQ
My Oracle Support Community (MOSC)
Go Directly To
Oracle Technology Network Community
My Oracle Support Community
OPN Cloud Connection
Oracle Employee Community
Oracle User Group Community
OTN Speaker Bureau
PeopleSoft General Discussion
Please enter a title.
You can not post a blank message. Please type your message and try again.
This discussion is archived
: Oct 23, 2012 12:51 AM by
How to assign sysdate in application engine peoplecode action
Oct 22, 2012 7:41 PM
How to assign the below query result to local variable in Applicationengine peoplecode action.
select to_char(sysdate,'MM/DD/YYYY') from dual;
My objective is:Need to assign sysdate(date only) to local variable in app engine peoplecode action.
This content has been marked as final.
Show 1 reply
Re: How to assign sysdate in application engine peoplecode action
Oct 23, 2012 12:51 AM
in response to
Use peoplecode function %Date instead of a roundtrip to the database.