Data Integration
Discussion List
-
Column limitation for Writing Back data to table using EPM Integration AgentSummary: What is the column limitation for Writing Back data from EPM cloud to DB Table using EPM Integration Agent? Here the question is: Does EPM cloud have column lim… -
epm integration agent fail to execute nullI have a new instance in OCI with windows 2022, where I installed Java 21, Python 2.7.3, and EPM integration agent, but when initializing the agent, I get the following …SantiagoC. 31 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
How to call an OIC Integration from a from PBCS/Data Management Cloud?Hello Everyone, I am currently working on integrating Oracle Integration Cloud (OIC) with PBCS Data Management. Is it possible to trigger an OIC job from PBCS Data Manag…DarshanJ 31 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Pre-Validation Error report to check for the error of Data Management before execution of DLRsSummary: If there's any way to get the Pre-validation error report before the DLR execution for loading the data: To know if any member is missing (not in the system but…
-
Custom Attribute unique value can be added automatically in the LOV?Summary: Hi, I wanted to know if within the EPM scope we can add the new values automatically via integration (or any other way) into the Custom Attributes existing valu…
-
"POV Period" is RTP to Business rules doesn't change value based on the Period the integration"POV Period" is selected as a parameter for RTP and POV Period is "Feb-25" (running an integration for Feb-25 load) Data Integration log file shows show it correctly : B…MKhade 21 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Unable to delete a file in the file browserSummary: Some files are not deleteable in the file browser. Content (please ensure you mask any confidential information): When users upload files in the file browser to…Pieter-Jan Vandendriessche 31 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform
-
can you load data to an account with a member formulaSummary: We are attempting to load data for an account that has a member formula. For this account, one scenario should be calculated with a formula and another scenario…Michelle Kellogg 51 views 8 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
EPCMCS Pipeline FunctionalitySummary: Pipeline functionality has been released. Can you run PCM Models using this capability? Content (required): In more complex environments with a significant rule…Adam Spiller 341 views 11 comments 1 point Most recent by NarayananS Profitability and Cost Management
-
Is it possible to backup an EPM environment to OCI buckets without EPM Automate?Summary: Currently we are using AWS Workspace to store our daily backups of all our 7 EPM environments via EPM Automate. I saw that you could also use OCI Buckets from O…Pieter-Jan Vandendriessche 21 views 4 comments 0 points Most recent by Brett Rooks EPM Platform and Freeform
-
You need a higher level of the 'Lists -> Documents and Files' permission to access this page.EPM Planning 25.01.31 Receiving the below error when running new Data Integration after setting up Netsuite Connection for the first time: RuntimeException: java.lang.Ru…
-
Period is not showing correctly in Data ExchangeIn my integration, I have mapped period to period in 'Map Dimension' But when I export the data, it is not showing my periods Any help is greatly appreciatedJames Coles 1 view 1 comment 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close
-
Can we load data in FCCS to Parent currency(USD) via DM so that it does not translate by default forSummary: We have a requirement where we are pushing consolidated data from FCC at parent currency level and then the allocations are calculated in PCMCS and then the dat…Kasi1981 71 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Do we need to establish new countries when creating new entitiesSummary: When creating completely new entities for the FCC that involve new countries, is it necessary to establish a specific reporting currency for these entities in t…Sanjana Soni 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Can SSH keys be used for authentication in "copy from SFTP' rest api rather than username password?Summary: Content (please ensure you mask any confidential information): Link for REST API: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common…P2 Admin 51 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
ERROR: Drill Region was not created/updated. No valid data rows exist in TDATASEG for Process IDWe are calling same dataload rule from the pipeline in sequential way, We have enabled Drill region. In FCCS we get error while running Dataload rule , but with similar …SrikanthReddy-Oracle 162 views 4 comments 0 points Most recent by SrikanthReddy-Oracle Financial Consolidation and Close
-
Partial Export of data into FCCS with failure in DMHi, We are testing changing the source of some locations in DM in a test environment. They are failing on the export step due to 2 rows of data flagging an invalid inter…Alyssa Longo 21 views 4 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
multi column-all data type export through Data ExchangeSummary: Hi Experts, We have a requirement to export smartlist and 2 data values of DataSource dimension from ePCM into a file. We chose to use Data Management for this …Sahitya Guruju Veena 124 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management
-
FCCS - Error: Invalid Journal file format. Importing consolidation journals.Summary: We are trying to upload a consolidation journal into FCCS. We are getting an format error, which we havent had before. Content (please ensure you mask any confi…Pieter-Jan Vandendriessche 102 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Enable drill-down to transactional data uploaded into the EPM Planning application via a flat file.Summary: Hello Experts, We are working on an integration where a flat file is used as the source to upload GL balances into the EPM Cloud Planning application. One of th…
-
GROOVY SCRIPT FOR ASO data exportSummary: Hi All, I have writeen a Groovy script to export the level0 data from the ASO cube to a csv file based on few conditions. Account dimension is not a compression…Sreekumar Hariharan 722 views 17 comments 0 points Most recent by SuneelKanthala EPM Platform and Freeform
-
Using Encrypted File as a Source for Uploading Data into EPM Cloud ApplicationHello Experts, I’m working with the Oracle EPM Cloud application and I would like to upload data from an encrypted file. Could anyone provide guidance or best practices …Ganipisetty N 21 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
How to select entity alias in custom drill urlSummary: In FCCS, we have added a custom drill URL to drill into FDI report. When we hardcode the URL with a specific entity alias, it correctly lands on the desired pag…AishShirke 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
How to pull data from sparse dynamic calc member in Data management PBCSHello Oracle Community, I’m working with Oracle PBCS and am trying to pull the parent values of sparse dynamic members using Data Management (DM). However, I’m encounter…
-
Is it possible to add a Data Map in the Action Menus so I can add it to a Form?I am trying to add a Data Map into the Form so when Users do a right-click on the form, they can do it themselves. I am wondering if this is possible. Smart Push in the …
-
Changing Default Time Zone and Restricting User Preferences in Oracle EPMSummary: Is it possible to change the default time zone of Oracle EPM pods to specific region time zone, as all our users are located in this region? Additionally, we wo…DarshanJ 131 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Write back from EPM to Oracle ERPHi! I couldn't find any documentation regarding how to write back data from EPM to ERP. Would it be possible to create an integration where EPM serves as the source and … -
How can I load rates through Data Exchange using the EPM Agent?Summary: Error in loading average rate and ending rate in Financial Consolidation and Close through Data Exchange using the EPM Agent. Content (please ensure you mask an…
-
support for exclusion in options->filters for an integrationWe have a very specific requirements for filter criteria for data export integration which is requiring us to hard code 100's of members in a filter. It would be great i…MKhade 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Why do I have to refresh the FCC Database after making a mapping change in Data Management.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Alan Hall-251497 41 views 5 comments 0 points Most recent by Alan Hall-251497 Financial Consolidation and Close