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 |