Data Integration
Discussion List
-
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 161 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 131 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 103 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 731 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
-
PCM Essbase data load on member with Chinese charSummary: Our application has products with chinese characters in the member name (not alias), so when we are trying to load data to the PCM_CLC cube its throwing error s…HarryEPMUser 11 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Need to have an automated process to export Journal Entries into a file or database.Summary: Need to have an automated process to export Journal Entries into a file or database. Content (required): In HFM we were able to extract Consolidation Journal En…Zenithz 81 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS DM access provision and controlSummary: Hi Folks, We are looking for details how to segregate roles in FCCS Data Management. We would like to provision user with Drill through option to connect to Ora…Sud VJ 111 views 22 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data Exchange Data Mapping Target Expression SQL Case statementSummary: In an EPM Planning Data Exchange integration, I need to replace a parent value and member value of “T” with another value like “T_Fund”. I cannot use Replace() …
-
How to populate agentContext["INTEGRATION"] for File based source systemSummary: We've a required to pickup the file from agentinbox folder into Data Integration. We're using EPM agent event script (BefExtract.py) Jython scripting to copy th…Kishan Kesanakurthy 22 views 2 comments 0 points Most recent by Ganesh Karri EPM Platform and Freeform -
Loading allocation results to ERP GL CloudSummary: Loading allocation results to ERP GL Cloud Content (please ensure you mask any confidential information) We have a need to load the results of our EPCMCS alloca…SAW23321 21 views 2 comments 0 points Most recent by Pat McCarty-Oracle Profitability and Cost Management
-
Custom Application FDMEE - File Name CustomizingSummary: Custom Application FDMEE - File Name Customizing Content (please ensure you mask any confidential information): Hi All, I have a question related to a Custom Ap…Antonio Barbaro 21 views 4 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Capture error/.out file from Data management processWe are encountering an issue in the Oracle EPM Data Management process while executing a data load rule. The process fails, and the detailed error is logged in the .out …Poorna durga 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data integration issue with Intercompany dimension from fusion to FCCSHi Team, We are in the process of performing data integration between Oracle ERP Cloud and FCCS. While the integration setup has been completed successfully, we are faci…Suresh V 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCC - Drill Through to SAP URL parametersSummary: The client has provided a custom SAP URL for us to set up a Drill Through feature. During the configuration, I replace the placeholders for "Account" and "Entit…Joao Carlos Monteiro 21 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close