Procurement Repository and Session Variables for Business Intelligence

You can use these repository and session variables in your analyses:

Variable Name	Type	Usage	Offering
CURRENT_DAY	Session Variable	Returns the value of Current Date.	All
CURRENT_MONTH	Repository Variable	Returns the value of Current Month in the YYYY/MM format.	All
CURRENT_WEEK	Repository Variable	Returns the value of the current week in YYYY Week nn format.	All
CURRENT_QUARTER	Repository Variable	Returns the value of Current Quarter in YYYY Q n format.	All
CURRENT_YEAR	Repository Variable	Returns the value of Current Year in the YYYY format.	All
NEXT_MONTH	Repository Variable	Returns the value of Next Month in the YYYY / MM format.	All
NEXT_WEEK	Repository Variable	Returns the value of Next Week in the YYYY Week nn format.	All
NEXT_QUARTER	Repository Variable	Returns the value of Next Calendar Quarter in the YYYY Q nn format.	All
NEXT_YEAR	Repository Variable	Returns the value of Next Year in the YYYY format.	All
PREVIOUS_MONTH	Repository Variable	Returns the value of Previous Month in the YYYY/MM format.	All
PREVIOUS_WEEK	Repository Variable	Returns the value of Previous Week in the YYYY Week nn format.	All
PREVIOUS_QUARTER	Repository Variable	Returns the value of Previous Quarter in the YYYY Q nn format.	All

This variable is available for only Oracle Fusion Cloud Procurement:

Variable Name	Type	Usage	Offering
PO_ACK_FEATURE_INDICATOR	Repository Variable	Returns Y or N to indicate whether the customer has enabled the opt-in to skip the supplier acknowledgment phase.	Procurement