Category 101
Discussion List
-
Issue with getEmailAddress() Method in Oracle EPM Groovy: "Email Doesn't Exist" ErrorHi Folks, I'm encountering an issue in Oracle EPM when using the getEmailAddress() method of the User class in Groovy. When I call operation.user.getEmailAddress(), I re… -
Having Weekly and Monthly Global Period Mappings Share Period KeysIs it possible to have weekly and monthly global period mappings share the same period keys? I.e., Week 5 of December and Month 12 both using 12/31/24. We have monthly a…
-
Groovy in Essbase 21CHi all, Sorry if I am posting the question in wrong platform. But, I did not find any better community than this. Although I have worked on EPM applications, I got curio…
-
Burst Reports with Custom Email FromHi All The default email is no.reply@epm.oraclecloud.com for all our epm planning environments. If I'm bursting reports to various users its easy to get confused as to t…
-
Find a substring in an Alias and compare to textSummary: We have a standard PBCS license (so no Groovy Scripting) and I am trying to analyse member aliases on the Entity dimension to see if there is a matching substri…
-
Data Integration from ERP throwing 401 errorWe have a pipeline that runs every morning around 2:30 am to refresh the last 4 years of budget data, the current and 3 previous years. The pipeline uses the same integr…
-
EPM Automate: Invalid CredentialsHi all, Good day! We are trying to login to planning application using EPM Automate login command. But we are encountering "Invalid Credentials" error as below. But, we …
-
Required IP for EPM Automate upgrade commandSummary: Is there any special IP address for using EPM Automate upgrade command? Now we're using IP Whitelist to control server-cloud connection, and already set up to u…
-
Dynamic Children and Groovy saveMember questionSummary: Content (please ensure you mask any confidential information): Hi, With Dynamic Children enabled for a "Dynamic Calc" parent, and use Groovy(non-REST API) to ad…
-
Is there any option to convert free form app to planning app? in order to use task managerSummary: We are currently having free form plannign app, but wanted to convert free form planning app to plannign app so that we can utilize task manager functionality. …
-
Can the target Category managed by a substitution variable in DataExchange instead of hardcodingLogin to EPBCS → Data Exchange → Actions → Category Mapping → Target Category - Can a substitution variable be defined instead of hardcoding the value?
-
Advice on new SECURE 2.0Summary: The SECURE Act 2.0 introduces significant changes to 401(k) plans, including requirements for the catch-up contribution portion. I wanted to check if Oracle has…
-
How to re load budget revisions?Summary: Is there a way that anyone knows of to reload budget revisions that have already passed funds check and funds reserve? We are connected to budgetary control and…
-
Issue while loading Period Multi Column Data in Data ManagementSummary: Error while loading Multi column Period data for a year using data file in Data Management Content (required): Hello All Here we are trying to load Multi column…
-
Current polled request status is: WAITSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Cannot calculate. Essbase Error(1042017): Network error: Timed out before receiving all dataSummary: 'Cannot calculate. Essbase Error(1042017): Network error: Timed out before receiving all data' error was received Content (please ensure you mask any confidenti…
-
Reports Relative Member of CurrentPOV -1 does not render Dec prior year if Jan is selected in POVWe have a Balance Sheet Report with the Period Dimension leveraging CurrentPOV in one column and Relative Member of CurrentPOV -1 in another column and then a variance c…
-
How to Download Large-Sized Application Snapshot More Efficiently via REST API?I have an EPBCS (Planning) account where I am using a REST API (version 2) to download the Application Snapshot (see link attached). I am running into an issue where the…
-
Request for EPM Sustainability snapshot - EPM Update Jan 2025Summary: Content (please ensure you mask any confidential information): As per the EPM Updates for January 2025, there seems to be a new solution that has been launched … -
Form Validation using groovyHi, I am trying to match two separate set of columns using groovy. (Yellow should match with Green section - the Green section is dynamic). If it's not match script shou…
-
Cell Comments (Notes) not importing using importdataslice rest apiSummary: Cell Comments (Notes) not importing using importdataslice rest api Content (please ensure you mask any confidential information): Hi , i am trying to copy cell …
-
Cannot Remove Hsp_CurrencyHello, I am using EPBCS. I changed the account type of a specific member, which was previously set as Revenue, to "Saved Assumption." (The data type was changed to Non-C…
-
How to know what is the data input and what is the calculated data?Hello everyone, I have one question about the business rule calculation functions. Can any calculation function be used in business rules to extract only inputted data? … -
Pipeline feature to copy file from unixSummary: Can we directly pull the file from unix box to epm inbox using Copy to Object Storage Job Type after setting up the External Web Service Connection Unixfile is …
-
how to automate a refresh member from data exchange with groovy rule?Summary: how to automate a refresh member from data exchange with groovy rule? Content (please ensure you mask any confidential information): We created a groovy rule to…
-
Targeted Distribution File to Send to Some Users on Same EmailSummary: Content (please ensure you mask any confidential information): I have a Targeted Distribution File that sends different department reports to multiple users. Cu… -
Is it possible to send email notifications to users through business rules?Hi! Is it possible to send email notifications to users through business rules without using groovy script? I have a requirement to send email notifications to user once…
-
Data Integration - Copying data to different scenarios using Period as conditionHi All, We are trying to copy data from one scenario to another in ASO cube with certain conditions that involves scenario and period using data management/data integrat…
-
Substitution Variable with multiple members as a Clear Region Filter Condition in Data IntegrationIf have a Substitution Variable &MovementTarget that contains a comma separated list of members ex: "CSHFLWHDGS_MVMT","TURLGLCFHG_MVMT","TEST_CLEAR_MVMT" and I want to u…
-
split a column in PBCS data management ExportSummary: Hi, we are trying to export data from PBCS application using Data Integration process into .csv file. we have a requirement where we would like to split our acc…