Table 37. Oracle BI Repository Date Variables
|
|
BUILD |
Holds the internal build number information for the Oracle BI repository. |
CAL_MONTH_YEAR_AGO |
Returns the value of Previous Year Month in the YYYY/MM format. |
CURRENT_DAY |
Returns the value of Current Date in the MM/DD/YYYY format. |
CURRENT_FSCL_MONTH |
Returns the value of Current Fiscal Month in the YYYY/MM format. |
CURRENT_FSCL_QUARTER |
Returns the value of Current Fiscal Quarter in the YYYY Q n format. |
CURRENT_FSCL_WEEK |
Returns the value of Current Fiscal Week in the YYYY Week nn format. |
CURRENT_FSCL_YEAR |
Returns the value of Current Fiscal Year in the FYYYYY format. |
CURRENT_JULIAN_DAY_NUM |
Returns the value of Current Julian Date Number. |
CURRENT_MONTH |
Returns the value of Current Month in the YYYY/MM format. |
CURRENT_QTR |
Returns the value of Current Fiscal Quarter in YYYY Q n format. |
CURRENT_WEEK |
Returns the value of Current Week in the YYYY Week nn format. |
CURRENT_YEAR |
Returns the value of Current Year in the YYYY format. |
FSCL_MONTH_YEAR_AGO |
Returns the value of Previous Year Fiscal Month in YYYY/MM format. |
FSCL_QTR_YEAR_AGO |
Returns the value of Previous Year Fiscal Quarter in YYYY Q n format. |
PREVIOUS_FSCL_MONTH |
Returns the value of Previous Fiscal Month in the YYYY/MM format. |
PREVIOUS_FSCL_QUARTER |
Returns the value of Previous Fiscal Quarter in the YYYY Q n format. |
PREVIOUS_FSCL_WEEK |
Returns the value of Previous Fiscal Week in the YYYY Weeknn format. |
PREVIOUS_FSCL_YEAR |
Returns the value of Previous Fiscal Year in the FYYYYY format. |
PREVIOUS_MONTH |
Returns the value of Previous Month in the YYYY/MM format. |
PREVIOUS_QUARTER |
Returns the value of Previous Fiscal Quarter in the YYYY Q n. |
PREVIOUS_WEEK |
Returns the value of Previous Week in the YYYY Weeknn format. |
PREVIOUS_YEAR |
Returns the value of Previous Year in the YYYY format. |
NEXT_FSCL_MONTH |
Returns the value of Next Fiscal Month in the YYYY / MM format. |
NEXT_FSCL_QUARTER |
Returns the value of Next Fiscal Quarter in the YYYY Q n. |
NEXT_FSCL_WEEK |
Returns the value of Next Fiscal Week in the YYYY Weeknn format. |
NEXT_FSCL_YEAR |
Returns the value of Next Fiscal Year in the FYYYYY format. |
NEXT_MONTH |
Returns the value of Next Month in the YYYY / MM format. |
NEXT_QUARTER |
Returns the value of Next Fiscal Quarter in the YYYY Q n. |
NEXT_WEEK |
Returns the value of Next Week in the YYYY Weeknn format. |
NEXT_YEAR |
Returns the value of Next Year in the YYYY format. |
YEAR_AGO_DAY |
Returns the value of year ago date in the mm/dd/yyyy format. |
TIME_OFFSET |
Returns the difference between the current date and a given number of days value. It is primarily used for testing to simulate an earlier or later date. You could set the variable to the number of days you want the preceding date variables to be moved back. |
REF_JULIAN_DATE |
Stores the start date of the Julian calendar and should not be changed. |
REF_JULIAN_DATE_NUM |
Stores the Julian number for the start of the Julian calendar and should not be changed. |
IS_CME_ORDER_NUM |
Set to 1 if the Order is a CME Order. This variable should not be changed. |
CURRENT_BALANCE_DK_AP |
Returns the value of the last date key for the available Accounts Payable balance. It is used in Accounts Payable Account Balance Computation. |
CURRENT_BALANCE_DK_AR |
Returns the value of the last date key for the available Accounts Receivables balance. It is used in Accounts Receivable Account Balance Computation. |
CURRENT_BALANCE_DK_GL |
Returns the value of the last date key for the available General Ledger balance. It is used in General Ledger Account Balance Computation. |