Category 101
Discussion List
-
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 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…
-
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…
-
Understanding OOB Lease Asset Calculation with IFRS16 enabledSummary Hi, I came across an issue with the capital planning module with respect to lease planning with IFRS 16 enabled When I create a lease (for e.g. 4 year lease with…
-
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…
-
Resolving Groovy Business Rule Validation IssuesHello experts, I have a problem validating groovy rules using new tool that is able to check if rule is good or not: Groovy Script Validator I have a rule using this cod… -
How can I remove some inactive users from private Demand and Supply plan users selection?Hi team, I would like to know how can I remove some inactive users from private Demand and Supply plan users selection, since the users are no longer active in the syste…Mauricio Ovalle Alvarez 31 views 1 comment 0 points Most recent by Thejaswini Kamreddy-Oracle Supply Chain Planning and Collaboration
-
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… -
Your environments will be upgraded to Essbase version 21.7.xx in 25.11Summary: As Oracle has notified us that our environments will be upgraded to Essbase version 21.7.xx as part of the 25.11 update, we would like to gain a clear understan…
-
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…
-
(PLEASE IGNORE THIS) Invalid Dimension Name in Asymmetric rowsSummary: Content (please ensure you mask any confidential information): Hi, When we do the Clone from TEST to PROD (in same version), everything is fine except for sever…
-
How to rename a series of form name at one time?Hello everyone, I have one question about renaming the form name. Now, in my Planning application, I have more than 100 forms, and I need to rename 100 forms at the same…
-
Is it possible to have access to a cube and not another so the cube is not visible in Smart View?Summary: We have a POD with multiple applications/cubes. This POD is currently not in Production but will be soon. Unfortunately, not all of the cubes will be ready for …
-
SV Behaviour Since EPM Planning 25.10 Update and Windows UpdateAfter EPM production was updated to version 25.10 over the weekend, if I open an existing SV (25.100) and refresh it with ADFDI 5.1.1.24695 add-in enabled, and log in to…
-
Can Form Spreadsheet Exports be Formatted?Summary: Is there any way to apply formatting to form spreadsheet exports (the Excel file that is generated when a user clicks on Actions→Spreadsheet Export)? (This woul… -
Unrecognized smart list value for the smart list: OCX_FinstatementAccountsHello everyone, We are trying to run datamap to push data from CAPEX to FS cube but it failed with "Unrecognized smart list value "-9.223372036854776e+18" for the smart …
-
ERP to EPM integration failing with error Connection Project Reporting is not found in applicationCan Someone help me on this issue: I’m facing an issue while exporting projects from EPM Standard Cloud to ERP. I’m unable to create a connection using “Project Reportin…