Calc Manager
Discussion List
-
@UDA NOT WORK "not a valid UDA value" even though the UDA is assigned in Dimension EditorHi Everyone, Hi everyone, I'm working on an Oracle EPM Cloud (Hybrid BSO) application and am experiencing an issue with the @UDA () function. I assigned a UDA to several… -
less powerful role to create rulesSummary: Content (please ensure you mask any confidential information): Hi Apart from giving service admin directly, is there any less powerful role which we can given t… -
Copy Data from Parent to ChildsSummary: I have a requirement where users will input data at parent member and it should get spread evenly to its children's evenly, We have a Market, Product, Entity an…
-
Verify Syntax and Format Code functionalities are not working in the Business Rules (Calc Manager)Summary: I am trying to use the Verify Syntax and Format Code functionalities in Calculation Manager, but they are not working in the Test instance (Version 26.05.66). H…
-
Dynamic calc members crossing dim with smart list member does not calculateSummary: Content (please ensure you mask any confidential information): Hello, I have the following calculation Sparse_DimA = @MEMBER(@CONCATENATE("HSP_ID_",@HSPNUMTOSTR… -
Update status for Leave of Absence in workforceSummary: Content (please ensure you mask any confidential information): We have the below business rule that assigns status based on start/term dates. We need to now tak… -
How to clear partial data in ASO Reporting Cube via Groovy when Aggregation Views are enabled?Hi everyone, I'm working on an Oracle EPM Cloud Planning application (version 26.05) and I need to clear partial data from an ASO reporting cube before running a series …
-
Balance Sheet Closing Balance calculation in Business ruleSummary: Content (please ensure you mask any confidential information): To calculate the Opening balance for the current month, we have a business rules that takes the p…
-
Did OOTB EPBCS rules get affected in Groovy script update?Summary: I have been running "Batch Trend Based Calculation" rule with no issues in EPBCS. After the May update to Groovy scripts I get an error message in this rule. I … -
The calculation results of business rules using UDA are not as expected.I've written the following business rules to handle cases where a UDA is assigned and cases where it's not, but as you can see in the attached image, the results are not…
-
ASO Dynamic Calc member formula issue after April updateWe have a Account dynamic calc member with below formula for ASO, which worked fine before April update and now we are facing issue with SmartView retrieval because of t…
-
SET HYBRIDBSOINCALCSCRIPT FULL; IssueSummary: Content (please ensure you mask any confidential information): Hi we encountered an error when using SET HYBRIDBSOINCALCSCRIPT FULL; Just wanted to know why it …
-
Seeing different results in Groovy 26.04 vs 26.05 in variable settingSummary: Validating business rules between 26.04 and 26.05 and we found syntax that produces different results Content (please ensure you mask any confidential informati… -
Drill Through Does not return any data when executingSummary: When i Try to drill, the landing pange open and i recieve the follow message: Drill query does not return any data. Data was not loaded to this intersection usi…
-
Clearing ASO cube on RTPs with GroovySummary: I am new to EPBCS and Groovy. I have a requirement to clear partial data from ASO cube by users on recurring basis. I am trying to write a business rule which u…
-
Workforce Planning Deprecated Rules in June 2026Summary: The Nov 2025 "Important Actions and Considerations" included that the following workforce rules will be updated and prior rules will be deprecated in the June 2…
-
YTD CPP and EI benefit accounts does not retain values in employee transfersSummary: When we do employee transfers between departments of one entity, the YTD CPP and EI values are not adjusted for when calculating benefits in the new department.…
-
Create business rule to move employee data when they switch departmentsSummary: Content (please ensure you mask any confidential information): I need to create a business rule in Workforce to move the employee's bonus expense from their old…
-
Deleted Business Rule Still Appears in ListSummary: Content (required): I asked this before, but cannot remember what the fix was, so apologies for the dup question. I have a few Business Rules that I have delete…
-
in EPM CLOUD business rule how to traverse the dimension in the order of a DATA COlumnhi All in the business rule in EPM CLoud - Planning - BSO Cube, we want to traverse all legal entities, based on a data column (PRIORITY), so primarily we need to perfor…
-
Usage of Scripts to improve the efficiency of business RuleSummary: Hi, Just wanted to confirm that I have used the following scripts in sequence at the start of business rule in designer format SET FRMLBOTTOMUP ON; SET CALCPARA…
-
groovy business rules for emailSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Export list of rules and list of rules securitySummary: Content (please ensure you mask any confidential information): Is there a way to export a list of business rules and the security (users assigned) to them? Vers…
-
How do I speed up an aggregation ruleSummary: Content (please ensure you mask any confidential information): We recently changed our subsidiary storage type to store. This has decreased refresh time in Smar…
-
Need to Run or Skip Section of Rule with Yes/No promptSummary: Content (please ensure you mask any confidential information): I have a section of a rule that copies forecast to a proforma scenario. My users would like this …