Where Used

Session Variables are used in the application UI to access certain parameters which are dynamic in nature from the implicit object session. The Platform creates this implicit object and it can be used in the application to set default values, while building Expressions etc.

e.g. If you want to set the default value of a Text field with the email address of the current logged-in user, then you can use the expression #{session.emailAddress} for the "Default Value" property

Syntax

#{session.variableName}

Note: Session variables are not case sensitive
List of Session Variables available on both Server & Client
userid
Logged-in user's USERID e.g. 4554. Will be same as FND_GLOBAL.USER_ID if the auth provider is OracleApps.
orgid
Logged-in user's ORGID e.g. 1000. This is platform specific, most applications doesn't use this value.
username
Logged-in user's USERNAME e.g. JBOSS
displayname
Logged-in user's Display Name e.g. John
emailaddress or email
Logged-in user's email address e.g. jboss@example.com
resourceid
Logged-in user's Resource ID. Will be null if the auth provider is anything other than OracleApps
subdomain
Logged-in application's subdomain. If http://example.domain.com is the URL to access the application, then example will be the subdomain.
clienttimezone
Browser's timezone. e.g. GMT-07:00
sysdate
Current Date & Time
servertimezone
Server timezone. e.g. GMT-07:00
uploadrequestid
A unique sequence number generated for every excel upload request
uploadfilename
The excel file name that was uploaded as part of the current action set
rolecode
Role code through which the logged-in user navigated to the current page

List of Session Variables available ONLY on Client Side

pageid
Current page id.
pagecode
Current page code.
pagedirty
True if there are unsaved changes on the current page.
HostPageBaseURL
The base URL from which the application is served.

Profile Values

Profile values can be accessed as #{session.profile.PROFILE_CODE} Note: In order for a profile value to be accessed this way, the "Load On Startup" property has be checked in the Profile Configuration.

System Variables

Syntax

#{system.variableName}

List of System Variables available on both Server & Client
newline
New Line character

Location

101 California Street, Suite 2710
San Francisco, CA 94111


440 N. Wolfe Rd.
Sunnyvale, CA 94085


Office 11, 5th Floor, Building 9,
Mindspace IT Park
Hyderabad 500081

p: +1 (844) AT CloudIO (844-282-5683)
f: +1 (650) 300-5247 | e: sales@cloudio.io
© 2009, 2017 CloudIO Inc. | Terms of Use | Privacy Policy