Data Integration
Discussion List
-
How to extract data file with date timestamp in data managementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Subhojyoti Chakraborty 31 views 2 comments 0 points Most recent by Subhojyoti Chakraborty EPM Platform and Freeform -
How to ignore Header and Footer rows in Flat Files for Data IntegrationHi team, Using the new UI of Data Integration. How do you ignore header and footer rows of a flat file? I know with multi-column load you can have it in the expression, …Peter Joelson 781 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
How to set pipeline substitution variable for Week Period combinationSummary: Our PBCS application period holds data in a different way. I.e in Weeks format. Eg: 01/05/2023 01/12/2023 11/02/2023 We have started integrated EPM with Snowfla…Praveen Reddy 111 views 8 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Need information regarding EPM AgentSummary: Hi , we are using EPBCS , we are getting salary data from a view and it’s a multi column data for account, in a file integration , we can define the import form…
-
Customize Data Management Log FileSummary: If any errors in data load rule running, the log file will show the error message. But the file is too tech with coding words. Is there any way to customize the…Xu, Angela Menglei 11 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
How to access Map Monitor Audit Reports within Data ExchangeSummary: Currently within Data Management, there are a series of audit reports that we regularly run for Audit and Controls purposes (See Data Management > Workflow > Re…John Herbert-271036 64 views 3 comments 3 points Most recent by Tbian7577 Financial Consolidation and Close
-
How to Import data in HFM application from FCCSSummary: Is there any out of box integration available to import data in HFM application from FCCS Content (required): Hi Team, We have a requirement where parent entity…
-
Pipeline Copy from Object Store File NamesSummary: We're currently trying to set up the pipeline to import current period trial balances for specific locations into FCCS data manager via the Pipeline Copy from O…
-
DM Update 19.06, Producing Flat-File Extracts out of Cloud Data ManagementSummary As an EPM Administrator or Implementation Specialist, we have all had that moment when someone comes to us and asks for the dreaded extract out of an Enterprise …User_2025-01-30-05-17-11-782 71 views 2 comments 2 points Most recent by Neha Talati-267028 Financial Consolidation and Close -
Connection between FCCS and IBM Planning Analytics version 2.09.02Summary: We are now looking to see if FCCS can send data feeds into IBM Planning Analytics version 2.09.02 in real time. One of our branch is using this system to do rep…Hugo Bergeron 92 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to extract YTD data from Nonextended Dimentional FCCS applicationSummary: Hi Experts, We are trying extract YTD data from FCCS application to TRCS application via Data management. Source FCCS application is Non-Extended dimensional ap…KC-2109 121 views 21 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
FCCS - Movement dimension member mapping for Accounts in Data Management loadsHi Team, We are implementing new FCC application with ERP cloud as source. We set it up the Accounts dimension and assigned Movement dimension member as like below. In F…Ankamma 345 views 9 comments 0 points Most recent by GaneshN-Support-Oracle EPM Platform and Freeform
-
Quick modes export data to file fails when no recordshi Since today morning (23.12), quick mode Export data to file integrations FAILS while running the integration. So far it used to be run successfully with just the HEAD…
-
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …Sarah Paroya 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …Sarah Paroya 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPM - Data Integration - Is it possible to use a like operator in the filter condition?I have an integration between Oracle EPM (ARCS) and Oracle ERP Cloud. For one of the dimensions (the 'XX_AFF_00_S04" dimension), instead of retrieving all level 0 values…
-
Error: java.sql.SQLException: Protocol violation on EPM Integration agentSummary: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/epm_agent_epm_zip_102x805297a3.html We used above doc to configured EPM int…