Category 101
Discussion List
-
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… -
How to print attachment file in cell commentHello everyone, I have attached the Excel file to a cell : My question here is: How can I print all the attachments in all the cells at one time? Is there any feature or… -
File Based Integration Explicit Period Mapping Not Allowed?Summary: I am trying to do a multi period data load in Planning that is a file type. I setup a Source Period Map, but don't have the option to setup Explicit mapping, is…
-
can we add more than 5 webforms in EPM Dashboard 2.0Summary: Unable to add more than 5 webforms in EPM Dashboard 2.0 Content (please ensure you mask any confidential information): We are trying to design Dashboards where …
-
Performance issue with writeback operations to Snowflake table using EPM Integration agentHello, I am trying to load some data in Snowflake table using EPM Integration agent. It is crossing default batch timeout of 30 minutes to load just 5k rows and integrat…
-
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.
-
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. …
-
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… -
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…
-
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…