Print      Open PDF Version of Online Help


Previous Topic

Next Topic

Session Variables

Session variables hold predefined values for a user and are initialized when a user logs in to Oracle CRM On Demand. When session variables are initialized, they remain unchanged for the duration of the session. Session variables are private values for a user and each instance of a session variable can be initialized with a different value for different users. You can reference them in the following areas: Title views, Narrative views, Column Filters, Column Formulas, Dashboard Prompts, and so on.

The most common use of a session variable is to reference it in a column filter condition of a report where you want to dynamically limit the results. The limit is based on the value of a session variable, such as the current fiscal year and month.

A session variable is referenced using the syntax NQ_SESSION.{Variable Name}. To use it in a column formula, it is referenced using the syntax VALUEOF(NQ_SESSION.Variable Name).

Session Variable

Description

CURRENT_DT

Current date and time.

COMPANY_LANG

Company's default language.

COMPANY_TIMEZONE

Company's default time zone.

COMPANY_TMPLT_COUNTRY

Company's default country.

CURRENT_MONTH

Current fiscal month of the session for the user. The values range from 1 to 12.

CURRENT_QTR

Current fiscal quarter of the session for the user. The values range from 1 to 4.

CURRENT_YEAR

Current fiscal year of the session for the user. A four-digit value, for example: 2011.

DISPLAYNAME

Current user's name.

LAST_QTR

Previous quarter.

LAST_QTR_YEAR

Year of the previous quarter.

LAST_YEAR

Previous year.

NEXT_QTR

Next quarter.

NEXT_QTR_YEAR

Year of the next quarter.

NEXT_YEAR

Next year.

QAGO

Last quarter.

QTR_BEFORE_LAST

Two quarters ago.

QTR_BEFORE_LAST_YEAR

Year of two quarters ago.

REPLUSER

Current user's login ID.

SERVER_COMPANY_TIMEZONE_OFFSET

The offset (in minutes) between the server timestamp and company default timestamp. The value of this variable is set when you log in. The variable is not updated during your session.

USER_ALIAS

Current user's alias.

USER_COMPANY_CURCY

Company's default currency.

USER_COMPANY_TIMEZONE_OFFSET

The offset (in minutes) between the user timestamp and company default timestamp. The value of this variable is set when you log in. The variable is not updated during your session.

USER_DEFAULT_CURCY

User's default currency.

USER_FISCAL_CALENDAR

First month of the current user's fiscal year.

USER_LANG

User's default language.

USER_SERVER_TIMEZONE_OFFSET

The offset (in minutes) between the user timestamp and server timestamp. The value of this variable is set when you log in. It is not updated during your session..

USER_TIMESTAMP

The timestamp of the user based on the timezone the setting defined in the user profile. The value of this variable is set when you log in. The variable is not updated during your session.

USER_TIMEZONE

The timezone description as defined in your user profile. The value of this variable is set when you log in. The variable is not updated during your session.

YAGO

Last year.

YEAR_MINUS_THREE

Three years ago.

YEAR_MINUS_TWO

Two years ago.

YEAR_PLUS_TWO

Two years from now.


Published 5/4/2012 Copyright © 2005, 2012, Oracle. All rights reserved. Legal Notices.