Scenarios

Expose Scenario Planning Range time horizon information as expressions, which allow you to specify the following:

  • Start Year: Returns the start year in string format for the given scenario.
  • End Year: Returns the end year in string format for the given scenario.
  • Start Month: Returns the start month in string format for the given scenario.
  • End Month: Returns the end month in string format for the given scenario.
  • Module Start Year: Returns the start year in string format for the given module and scenario.
  • Module End Year: Returns the end year in string format for the given module and scenario.

Note:

Module Start Year and Module End Year are only valid for Oracle Enterprise Planning and Budgeting Cloud applications.

Calculation Manager Syntax:

[[getStartYear("ScenarioName")]]
[[getEndYear("ScenarioName")]]
[[getStartMonth("ScenarioName")]]
[[getEndMonth("ScenarioName")]]
[[getModuleStartYear("ModuleName","ScenarioName")]]
[[getModuleEndYear("ModuleName,"ScenarioName")]] 
  

ScenarioName can be a typed in Scenario member, or a Calculation Manager run-time prompt member type variable. The member must be enclosed in double quotes. For example, [[getStartYear("Actual")]].

Example 1

The following syntax, where {rtpScenario} is a run-time prompt variable of type member with a default value of actual:

FIX({rtpScenario}, [[getStartYear({rtpScenario})]]:[[getEndYear({rtpScenario})]],
   [[getStartMonth({rtpScenario})]]:[[getEndMonth({rtpScenario})]])
      FIX ( Working, P_000, "111")
        "5800" = 5500;
      ENDFIX
ENDFIX  

returns the following script:

FIX ("Actual", "FY10" : "FY18", "Jan" : "Dec") 
    FIX (Working, P_000, "111") 
      "5800" = 5500;
    ENDFIX 
ENDFIX

Example 2

The following syntax:

FIX({rtpScenario}, [[PlanningFunctions.getModuleStartYear("CAPITAL",{rtpScenario})]]:
[[PlanningFunctions.getModuleEndYear("CAPITAL",{rtpScenario})]] , "Jan" : "Dec")
  FIX(OEP_Working, P_000, "111")
    "5800" = 5500;
  ENDFIX
ENDFIX

returns the following script:

FIX("OEP_Plan", "FY18" : "FY22", "Jan" : "Dec")
  FIX(OEP_Working, P_000, "111")
    "5800" = 5500;
  ENDFIX
ENDFIX