To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Planning
Discussion List
-
Link to 24.100 Smart View .MSISummary: Hello, We recently identified that the bulk of our Smart View user base is on very outdated versions of the add-on and that we needed to get all our users level… -
Using getSharedMembers for cube specific shares?Summary: I am trying to find cube specific shared members using getSharedMembers since the documentation shows this should be possible, but I'm getting shared members fr… -
what is the syntax to update alias with groovy scriptSummary: Is there a syntax to update alias using a groovy script? We would like to update the alias of a period member based on the start period of the actual scenario. …
-
is there a way to restrict user access during the time our pipeline runs to refresh data?We have a pipeline that runs daily to refresh data from netsuite to NSPB. It takes about 1.5 hours total to run. I'd like to stop access to all users (other than admin) … -
Threading / Multi-Processing Equivalent in GroovySummary: Is there a way to accomplish threading / multi-processing in Groovy within EPBCS? We have a number of jobs where scripts are running on a large set of Project d… -
How to add more elements to dashboard than page will allowI was curious if there's a way to add more items to a dashboard than what is visible on the page. I've so far been unable to find a way to add anything additional beyond…
-
FCCS Indirect Cash Flow movementSummary: How to enable Cash Flow movements in FCCS? Content (please ensure you mask any confidential information): Hello, We want to start using Cash Flow functionality …
-
Groovy Validator Missing in Production for Prebuilt ScriptHi All, We’re using a prebuilt Groovy rule in our Dev, UAT, and Production environments in Oracle EPM Cloud. In Dev and UAT, we can see the Groovy Validator Option under…
-
Groovy Validator Missing in Production for Prebuilt ScriptHi All, We’re using a prebuilt Groovy rule in our Dev, UAT, and Production environments in Oracle EPM Cloud. In Dev and UAT, we can see the Groovy Validator Option under…
-
Can you insert Financial Reports into DashboardsSummary: I'm trying to insert Financial reports created in EPM into Dashboards. However it doesn't seem like this option exists. Only options are either to add forms int…
-
Update Cell-Level Security in GroovyHere is some sample code to create CLS in Groovy // #### RULE HEADER - START // // Author: Jeremie Richard // Date: Sep 2025 // Purpose: Generate Cell Level Security (CL…
-
Creating via Groovy Rule the Excel file needed for the update of Cell-Level SecuritiesSummary: We would need to create and populate the two-tab-based Excel file needed for the Cell-Level Securities update. Is there a way to do so? Content (please ensure y…
-
Sort values in form using Groovy, possible?Hello! Does anyone have experience with sorting values in a Form? For example displaying "top 10 values" or "least profitable services" or similar? My search so far have… -
Can Data Map be run by non-Admin userSummary Can Data Map be run by non-Admin userContent I have a form that is failing on the smartpush because of too much data. I replaced the smartpush with a groovy rule… -
How can I know where the form is open in Excel?Hello everyone, I am opening the form in SmartView on a web browser : However, when launching the .sclnk file, sometimes it opens in workbook A, sometimes it opens in wo… -
New Groovy Engine EnquiryWe came across the following Oracle notification: "A future version of the Groovy engine, which is planned for the second half of 2025, has stricter validation rules tha…
-
PBCS find accounts not usedWe are having some performance issues with so many accounts and would like to remove any account that did not have activity in the past years. Is there an easy way to fi… -
EPM AutomationSummary: Can someone guide to do automation for the following: Download the snapshot from object storage(OCI) Upload the snapshot to EPM(Freeform) Restore the snapshot i…
-
Error while RunningOWP_Transfer Business rule in WorkforceI am trying to call OWP_Transfer Business rule through REST APIs in groovy, its giving below error. I tried to run OWP_Transfer rule from 'Rules' card from home page, st…
-
Request for implementing an informational warning in Groovy for modified form in EPBCSDescription: Hello, We are trying to implement an informational warning message upon saving a form (Customer Schedule – Overdue Receivables) in Oracle EPBCS (version 24.…
-
We need to host EPM Automate in OCI and also write shell script for EPM AutomateSummary: We need to host EPM Automate in OCI and also write shell script for EPM Automate which calls Pipeline functionality. How can we achieve using OCI that has EPM e…
-
EPM to ERP Project management Project ExportSummary: We are trying to Export Approved Projects (Created in EPM) to ERP PROJECT MANAGEMENT through jobs Export projects and Budgets. It is showing Error. Content (ple…
-
Smart Push warning in EPM PlanningSummary: We configured some Datamap in EPM Planning. However, when excecuting smart push, the following warning message was displayed. I have no idea why this message ha…
-
Smart List Labels Not Updating After Alias ChangeSummary: I have a Smart List that's derived from members. When I update the member alias in the dimension editor, the Smart List label doesn’t update automatically. What…
-
Member Formula Works in Test but Not ProductionSummary: Content (please ensure you mask any confidential information): In our tracker dimension, we have some historical data that is sitting outside our "Closing Balan… -
PBCSSummary: Groovy Engine update and its questions Content (please ensure you mask any confidential information): 1. Could you please confirm the correct Groovy Engine upda…
-
Data maps between Model and CubeHello everyone, I'm trying to connect, using a Data Map on PBCS (version 25.10.76), a model (source) to a cube (target). While mapping the dimensions, I’m running into a…
-
How to clear PCM multiple Periods for Forecast scenario with Groovy scriptSummary: I just want to clear all the data in PCM for Forecast dimension by using groovys script for all periods before laoding it from EPM. I have tried groovy with mdw…
-
Consequences of resetting and child member under dimensionsSummary: Content (please ensure you mask any confidential information): Hi all Can someone confirm what are ALL the consequences of resetting a child member under Dimens… -
Profitability and Cost Management (EPCM) Model Calculations for multiple Periods with GroovySummary: I have a pipeline in EPM Planning that push data into EPCM for all periods of Forecast scenario/Run Model Calculations for all periods to allocate Overheads/ Pu…