Category 101
Discussion List
-
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. … -
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…
-
Auto Predict Explain Predictions Not AvailableSummary: Auto Predict Explain Predictions Not Available Content (please ensure you mask any confidential information): Auto Predict Explain Predictions Not Available. Th… -
How to import Average FX rates from Financials to Planning in the new Exchange Rates integration?Summary: We are unable to get Average FX rates in the new Exchange Rates integration, when loading data from Financials to Planning. We are getting Closing FX rates, but…
-
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…
-
WHY is difference between PREDICTIVE PLANNING and Auto-predict resultsin PBCS custom application, we have run Predictive planning (From data form), v/s Auto-predict —- both have shown model being used ARIMA Question 1) then why if you see …
-
October 25.10 calc manager bug introduced: a valid dimension could not be found for variable...Summary: Just noticed ASO business rules no longer validate if a variable of type "Members" is used. I get error message: A valid dimension could not be found for variab… -
file attachment limitation size in commentHello everyone, I want to ask : What is the attachment size limit in the EPBCS Data Form? Is there any Official document refer to this? Thanks and have a nice day. -
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…
-
Custom Report for DM Tables in EPBCSSummary: Hello, I want to know if i can generate a report using custom query with a join between Datamanagement tables say AIF_BAL_RULE_PARAMS or AIF_BALANCE_RULES in EP…
-
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…
-
Can Groovy script produce Business Rule logs?Summary: When we run a Business Rule in could EPM, the job console does not show the log as it would when run on prem. Is it possible to generate essbase-like calculatio…
-
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…
-
Drill-through works on one branch but not the otherSummary: In our projects dimension, we have 2 branches in the tree for the dimension. Total Projects where we simply list all the project values primarily for external r…Matthew - Town of Aurora 35 views 8 comments 0 points Most recent by Matthew - Town of Aurora Planning
-
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… -
How to write csv file with groovy rule without adding Byte Order Mark (BOM)I am trying to create a csv file with groovy rule. All went well, except this created file contains byte-order mark (BOM), which is not needed. Automation is sending thi…
-
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…
-
Bug or not? About member on form gets removed.Summary: Content (please ensure you mask any confidential information): Hi, As people all knows that if dimension members are explicitly used on forms, you won't be able…
-
Pipeline setup for Copy to SFTPSummary: Content (please ensure you mask any confidential information): Hi, Can anyone provide some guidance on how to setup the Copy to SFTP with pipeline? While readin…
-
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…
-
Adding access to users to Rulesets in PBCSUnable to add users to rulesets in the Rules section of PBCS. Can anyone help me assign permissions to users for rulesets?Hareesh Reddy Kadipikonda 27 views 2 comments 0 points Most recent by Hareesh Reddy Kadipikonda Planning
-
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.…