Automate Tasks
Discussion List
-
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 33 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 22 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 12 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 72 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…
-
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 51 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 61 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
-
How to automate alternate hierarchy populationSummary: I need to populate an alternate hierarchy with cost centers that meet certain property criteria. My best idea is to create an extract formatted as an import and…
-
Unable to downloading Snapshots larger than 13G from Cloud to on-premise, can it be split up?We download an archive (snapshot) to our jumpbox to have a live copy; we have run into an issue with the size of the snapshot; its 13G and unable to download. Is there a…
-
What does it means to rename the data source in a template importSummary: See the screenshot. I am using a Application Template from our testing environment to migrate our changes to our Production environment. I am previewing the add…John Burton 41 views 8 comments 1 point Most recent by BBrocklesby-Oracle Enterprise Data Management
-
IDCS Group Audit Reporting REST APISummary: How do I get Audit Reporting for IDCS Groups and Application Roles using REST API? Content: I can report on users assigned to an Application Role directly in ID… -
Does an EPM auto job or REST API to pull the record count log and Total Node and Record Count existSummary: It would be helpful if there was a way to automatically export the record count log and Total Node and Record Count. Does anyone know if this is possible? Conte…CCel 11 views 1 comment 0 points Most recent by Anurag Garg - Oracle-Oracle Enterprise Data Management
-
How can I auto-increment a member name in a flat dimension?Summary: In a hierarchy dimension, I can auto-increment a member name by using the PreviousSibling methods in the Calculate and Store expression on the name property. Ho…Josh Winters 11 views 1 comment 0 points Most recent by Matt Lontchar-Oracle Enterprise Data Management -
Create a data integration direct connection from Freeform to EDMIt appears you cannot create a data integration direct connection from cloud EPM applications to EDM. Is that correct?Michelle Kellogg 31 views 4 comments 0 points Most recent by Stuart.Porad Enterprise Data Management -
enterprise data management Permissions Report from Hierarchy set and Node TypeWe are trying to extract Reports for permissions on all the Hierarchy sets and Node Type. So typically getting reports for Permissions at Hierarchy set level and Node Ty…