Calc Manager
Discussion List
-
Business Rule: Capture logged-in user ID?Summary: Is there a way to capture, say in a variable, the ID of the logged-in user? Content (please ensure you mask any confidential information): We're building a cust… -
Groovy getFormattedValue() not working?Summary: Content (please ensure you mask any confidential information): Hi, Just found that getFormattedValue() not working as expected, it was working correctly before.…
-
Groovy Script ValidatorSummary: Content (please ensure you mask any confidential information): Hi, With the Aug release in TEST to validate groovy rule scripting restrictions by the provided t…
-
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav… -
Rules are not displaying under RulesSummary: Hello, Does anyone know why the rules are not displaying under Rules? The Daily maintenance ran last night, and it did not resolve it. We also redeployed all ru…
-
Why does @parentVal return #MISSING?Summary: Can someone help me understand why @parentVal("Period", "Working") returns #MISSING for the sample code below? Content (required): I have set up a simple exampl…
-
@IRR and @CalcMgrExcelIRR does not return a value equalent to the Excel IRR calculationSummary: We are using @IRR inbuilt oracle function in our Calculation rules to arrive at the IRR value , IRR(AC.PBC.6013)= IRR( Cumulative(Free Cash Flow (FCF)(AC.PBC.50…
-
How do i refer the smartlist value ( not numberic value ) in a business ruleSummary: I have created Increment Month smartlist which has period dimension refernce or smart list entries are Jan, Feb, Mar and so on, and i want to refer and compare …
-
Can I edit OWP_Transfer rule in Workforce Module?Summary: I need to edit the OWP_Transfer rule in TST environment to analyze an issue. When I try to "edit script" it doesn't allow me to edit. Please let me know how I c… -
Allow user to select design time prompt each time rule is runSummary: Allow users to select design time prompt each time rule is run in order to use validations and steps as needed Content (please ensure you mask any confidential …
-
Business Rules RTP behavior between Forms 1.0 and 2.0.Summary: Hi Experts, I have a Business Rule with RTPs that include both numeric values and Smart List selections. I have set Allow #Missing at both the variable and rule…
-
How to use groovy script to run the allocation in PCMCS and how to load driver data using groovySummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Is it possible to set attribute value from SL value?Summary: Is it possible to convert SL Value and attach it on attribute dimension. Can we do it using groovy, if yes could you please share code snippet. Content (please … -
Change in FIX AND behavior with 25.08In my business rules, I often use SET EMPTYMEMBERSETS ON; along with FIX statements to handle different branches of logic that need to occur for different years or scena… -
Calculation of percentile / quantileSummary: How to calculate percentiles / quantiles in EPM Planning BSO without considering #Missing Content (please ensure you mask any confidential information): In my c…
-
How to use @SHIFT(@CurrMBR in a crossdimI am trying to write a calc in calculation manager which will return a different value based on 3 different situations depending on the Period (i.e. "Jan") in the IF sta…
-
How to Check if member from Plan1 exist in Plan2?Summary: Problem : Customer is copying data from one plan to another plan in planning application. Now some dimension member do not exist in target plan type. Do we have…
-
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
How to exclude intersections of different dimensional membersSummary: How to exclude an intersection of different dimensions within a FIX statement? see example below Content (required): Calc Script: In the FIX Statement is the wh…
-
Employees status setting to departureSummary: Content (please ensure you mask any confidential information): We have a business rule that sets active status. This has been working without issue for over a y… -
Calcmgrslmember does not return the correct cross reference value , but returns correctly in debugSummary: I have a business rule that refers to the calcmgrslmember to retrieve a SL member name and identifies the cross referenced value in an intersection. This does n… -
Independent BR assigned to Integration - runs also rules that are not assignedSummary: Hi all, I have created an Integration in EPM Planning (runs as expected) with the BR assigned to it. This business rule has been added as an Independent, event-…
-
Delay in calc manager to recognize new Smart Lists/Variables?Summary: I created a new SmartList within Planning and new Variables in Calc Manager. The SmartList isn't showing in the options for variables and the variables are givi…
-
Calculation Manager Errors and Considerations EnforcementSummary: In the August 2025 Monthly Update e-mail I saw this in Important Actions and Considerations: Calculation Manager Errors and Considerations Enforcement In a futu…
-
Newly added members not getting reflected in the Calculation ManagerAfter creating dimensions in Custom cube and refreshing the application, Member count is reflecting correctly from front end at application level however member count is…
-
Planning Calc Script - @COUNT with ConditionSummary: Hello - not sure why I am struggling so much with this but we have a rule where we want to have an IF statement to only include shared member projects that meet…
-
Workforce Rule Failing for Unknown ReasonSummary: Rule and Ruleset failing for unknown reason Content (please ensure you mask any confidential information): I have a ruleset in workforce that is scheduled in jo…
-
Is there way to view all business rules ran within a time period?I need a full activity report/list with date or time stamps of all business rules that were ran for example in the past 30 days. Thank you!
-
New Groovy version 25.10 Validation ErrorHello Experts, I have a issue when I run validation Groovy Script: My HTML Report have same error in several rules, now are working fine but I'm afraid that is not worki… -
Deleting file from Inbox/Outbox Explorer using REST APIHi all, We are trying to delete a csv file from Inbox/Outbox Explorer using the below REST API https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-co…