Automate Tasks
Discussion List
-
Excel format in EPM Automate?Summary: Can EPM Automate be used to trigger an Excel format extract? Content (please ensure you mask any confidential information): We are not on the current version of… -
We use epmautomate's Extract-Dimension and we are needing clarification of .xlsx supportedSummary: We use epmautomate's Extract-Dimension and we are needing clarification based on an error we are receiving below: 06-06-2025 08:29:34 - Executing deletefile "ED…
-
EDMCS - Sync of Account member between ERP vs FCCSSummary: Adding level 0 account members in FCCS under Traditional Balance Sheet hierarchy Content (please ensure you mask any confidential information): ERP and FCCS par…
-
Can Hash values for a combination be sent to Oracle Control Budget from EPMSummary: We are looking for an advise to see if EPM has ability to send out Hashed Combinations to Oracle Control budget and is it acceptable at the Oracle Control budge…DharaniR 11 views 1 comment 0 points Most recent by Suruchi S-Support-Oracle EPM Platform and Freeform
-
EDMCS how to set an approval policy expirationHow can I establish an approval duration after which the policy automatically progresses to the next stage, while retaining all collected approvals? For instance, set an…Emile Helegbe 11 views 1 comment 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
Trigger an alternate subscription to a existing subscription to update the same hierarchy and NTSummary: We have a B application hierarchy which is getting updated from the MASTER application via Subscription marked as BLUE line. but within the same B application t…Neethu Durgaram 13 views 2 comments 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management
-
How to integrate Valid Intersection from EDM to FCCEDM can generate extract as .csv/xlsx files with Single sheet. Extract Packages allows you to combine the output in a single file. Has anyone integrated Valid Intersecti…Mukesh_Pardasani 12 views 1 comment 1 point Most recent by Kevin McKenzie-Oracle Enterprise Data Management -
Use Case Possible? Want to use a data file to only load new membersI'm exploring the feasibility of using EDM to manage dimension updates in Planning, and I'm hoping someone can clarify if this is possible. Here’s the scenario: We have … -
How can I calculate and store a Core.Name to also use sequencing?Summary: I want to have EDMCs suggest/populate the 5 digit longer Department Number in the Core.Name property. For example, DEPT_10101. However, it obviously should not … -
Can we use SSH key instead of password in the EPM Automate command: copyToSFTPHi Team I wanted to confirm if we can use SSH key instead of password in the EPM Automate command: copyToSFTP. The syntax of command is given as: epmautomate copyToSftp …PM2024 41 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
I am wanting to build a subscription calculating a Parent NodeSummary: We leverage a mapping between our Chart of Accounts from our Legacy On-Prem General Ledger to our Oracle Cloud General Ledger. This was built before the EDMCS f…
-
Calculating a node name as the parent + an integer that adds 1 everytime a new child is addedSummary: I'm trying to calcualte the node name as the parent node name contactactened with a string and an integer that adds 1 everytime a new child is added. For exampl…Hayley Matheson 21 views 2 comments 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management
-
How to use a Node's property to calculate a Parent in NT ConvertorSummary: Is there a way to access the current node's property to determine the target parent in a NT Convertor? Currently only the Node's Parent is accessible in the Par… -
How to write validation expression to find when parent (top level node) becomes Orphan(level 0)How to write validation expression to find when parent (top level node) becomes Orphan(level 0). Here both Top level and bottom level are 5 digit number Eg : 10000(Paren…Navyabolla 11 views 1 comment 0 points Most recent by Kevin McKenzie-Oracle Enterprise Data Management
-
Combining location() and children.toStringList() in Expression BuilderHi Community, We are currently trying to implement a requirement using the Expression Builder and need support from the community experts. Our view has two viewpoints re… -
How to get Details of a EDMCS Request on mail notification?Summary: Currently, the EDMCS Request notification mail specifies the request number and the View name. Content (required):Would like to know if we can get the Details o…
-
Does EDMCS Export trigger Inherit Segment Value Attributes process?Summary: When a segment value is updated in the EDMCS FCGL application to change its Enabled property from TRUE to FALSE, will a subsequent EDM Export of FCGL trigger th…Katrina Boyajian 111 views 2 comments 0 points Most recent by Katrina Boyajian Enterprise Data Management -
How can I use IsLeaf() function in EDM expression builder?Hi Community, I want to define a derived EDM Property that provides an info (True/False) if the node is a Level 0 node. I was looking for IsLeaf() function in the expres…
-
How to run Audit Type Reports by EPM Automate or by RestAPI for EDMCSSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Sadaf Ali 13 views 1 comment 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
Can we setup the sequence property to get automate number series.Summary: Can we setup the sequence property to get automate number series. Content (please ensure you mask any confidential information): Can we configure the sequence p…
-
How to assign a sequenced code for only nodes whose attribute is true ?Summary: I need to assign a sequenced code as an attribute for nodes whose flag(different attribute) is set to true. These nodes are spread across levels. How to get it …
-
System Settings Update using Rest APISummary: Part1: Not all settings are being exported when retrieving system settings from Application using rest api. brandColor, oglServerURL,oglApplicationId settings a…
-
EDM Export to Fusion cloud GL using GroovySummary: We have a business requirement to create an EDM export to Fusion Cloud GL using Groovy script. Could you please let us know if this is possible and any supporti…
-
EPM Automate error: EPMAT-7: Configuration system failed to initializeSummary: My colleague and I are using the same login credentials to access EDMCS using epmautomate. He can log in, but I am unable to do so, and an error message stating…Saikrishna Somarouthu 53 views 5 comments 0 points Most recent by BalaR-Oracle EPM Platform and Freeform
-
can we derive the attribute property based on child/parent node?Summary: Is this possible to derive this? Please share your suggestions on this. The attribute property should be derived such that only bottom nodes are permitted to ac…
-
Merge option is not working in Viewpoint upload using epmautomate in EDMCS, have you come across?Hello, When I try to upload members using the merge option with epmautomate, it is clearing all the existing members and loading only new members that are present in the…Sudhakara Reddy 31 views 3 comments 0 points Most recent by Sudhakara Reddy Enterprise Data Management
-
How to calculate and Store a parent where hierarchySet is required to be used in the expression?Summary: The hierarchySet is available in the Expression interface against CoreStats.parent, however the EDMCS documentation (Chapter 22-page 31) indicates that this can…Hayley Matheson 21 views 1 comment 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
Unable to retrieve base currency value based on the node data type property valueSummary: In Department dimension UDA property, we need to concatenate Entity value with its corresponding Base Currency value from Entity dimension. For this we have cre…Swami Ayyappa Basava 51 views 8 comments 0 points Most recent by Swami Ayyappa Basava Enterprise Data Management
-
Subscription not working for Delete ActionSummary: The requirement is to set up a subscription between FCCS and Planning viewpoints for common sub hierarchies as part of Alternate hierarchies. Both the FCCS and …SwapnaTumula 63 views 7 comments 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management
-
When Consolidating Requests is there a way to get the request to auto submit?Summary: When Consolidating Requests is there a way to get the request to auto submit? Currently, when we consolidate requests it goes into Draft, we then have to submit…John Burton 1 view 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management