Data Integration
Discussion List
-
Does Data Management sum data for matching POV?Summary: Should Data Management sum data for multiple records that map to the same POV for FCC and Planning? Content (required): My latest FCC app does not behave this w…MrKellyGreen 61 views 2 comments 0 points Most recent by MrKellyGreen Financial Consolidation and Close -
Is it possible to get a separate period for the adjustment period?Is it possible to get a separate period for the adjustment period? Not merge it into an existing period. According to data loads in DM are driven by the period key, but …Sun Wei-Oracle 11 views 4 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
View Role for Data Load Rule and MappingContent In Data Management, is it possible to give a view role/security to a user so that he can only view Data Load Rule and Data Load Mapping? Any response will be hig…Nrupansh Joshi 43 views 3 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Why Run Integration role doesn't allow user to browse and select file in DLR for data load uploadSummary: Content (required): Version (include the version you are using, if applicable): Code Snippet (add any code snippets that support your topic, if applicable):
-
YTD view as result of custom calculationSummary Currently YTD is dynamic calc which doesnt work for outbound integrationContent Hello, here is my issue. We have a set up in PCMCS for Periodic view as store dat…User_2025-02-06-00-44-44-141 66 views 6 comments 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
PCMCs with Data management import error: [NULL ACCOUNT VALUE]Summary: Warning: No records exist for Period 'Sep-21' and [NULL ACCOUNT VALUE] Content (required): Hi all We are trying to import data from PBCS to PCMCs but we are get… -
Exporting data from PCMCS with DM how do I round the output values to 2 decimal placesSummary round exported values from PCMCS to export fileContent There does not appear to be a way to export values from PCMCS with DM, so that the values are rounded to 2…Dawn Watson 111 views 7 comments 1 point Most recent by User_2025-02-05-23-55-14-602 EPM Platform and Freeform -
"Setting Up Passwords that Do not Expire" in the Mar-21 updateContent Hi -- Trying to find some more information around a topic I saw in the Mar-21 release notes, specifically for a new topic in the EPM Cloud Operations Guide for :… -
Executing data load for a POV and Calculation for different POV & Lock & Send Smart View also failsSummary: Executing data load for a POV and Calculation for different POV results the calculation as success(but the calc does not run and only status gets as success) bu…User_2025-02-05-23-55-14-602 11 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management
-
Parameters for Drill-QuerySummary: I'm looking for Parameters for drill-query, e.g. Source-Entity, Source-PeriodKey, etc Content (required): Hi all, I'm just trying to build a drill-query for EPM…User_2025-02-03-23-55-06-250 11 views 2 comments 0 points Most recent by User_2025-02-03-23-55-06-250 EPM Platform and Freeform
-
Issues with $START_PERIODKEY[YYYY]$: giving wrong yearSummary: I've implemented an integration, where I'm trying to leverage $START_PERIODKEY[YYYY]$ unfortunately for Dec-20 it gives me year 2021 but I would have expected 2…User_2025-02-03-23-55-06-250 21 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Drill THROUGH to source emptyContent Hello, I have arranged for a file to be uploaded to the application via Data Management. I also enabled the Drill region function and in fact after importing the…Alberto Parisella 23 views 7 comments 0 points Most recent by Ryan Li Financial Consolidation and Close -
FCCS's DM Workbench data disappeared after snapshot restoreSummary: FCCS's DM Workbench data disappeared after snapshot restore Content (required): We got to know that FCCS-DM Product has limitation of workbench data not being c…User_2025-02-06-06-07-43-641 21 views 1 comment 1 point Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Task Manager - Integration with WorkivaHi Experts, We are evaluating below integration options from Oracle Task Manager. Appreciate if you can share your views. Task integration with Data Exchange Option Task…Kotak Pramit 31 views 1 comment 0 points Most recent by Tom LeFebvre-Oracle Financial Consolidation and Close -
OAuth 2.0Summary: When will OAuth 2.0 be available for Non OCI Environments. Content (required): When will OAuth 2.0 be available for Non OCI Environments. This is needed for enh…User_2025-02-05-23-55-14-602 21 views 1 comment 0 points Most recent by Omar Shubeilat. Profitability and Cost Management
-
FCCS Data Export CommandSummary FCCS Data Export CommandContent In recent past, FCCS Data Export Command was not supported in Calculation Manager but when creating a custom app in DM with filte…User_2025-02-05-23-55-14-602 42 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Financial Consolidation and Close
-
Data Management and Data ExchangeSummary Data Management and Data ExchangeContent Hello, We have data management and data integration available in FCC. Most of the features are similar and I could see t…
-
Subtotal with rows in a source file FDMEEContent Hello to all, I'm setting up a mapping on FDMEE. I'm importing data from a file, the purchase cost field values of which are sorted in ascending order. I have …Alberto Parisella 27 views 1 comment 0 points Most recent by User_2025-02-05-23-55-14-602 Financial Consolidation and Close
-
Separate an account string in Data ManagmentContent Many file exports have a concatenated account string such as 000-0000-00000-00 where each segment represents a different FCCS dimension. Is there any method for …
-
Resubmission of TB after loading STAT accountsContent Hi Team, We are following below data loading process as a standard load, However there can be a need of resubmission of Trial balance for some entities (In Repla…Kotak Pramit 20 views 2 comments 0 points Most recent by Kotak Pramit Financial Consolidation and Close
-
Data Integration Event Based Business Rules - Warnings when no data to loadSummary Data Integration Event Based Business Rules - Warnings when no data to loadContent Hello, We have configured a Clear to run "Before Load" using Data Integration …
-
Cutting of leading characters in Data Management (before Mapping)Summary A source system extract will change and we will need to cut of the leading 4 characters (or change all mappings)Content Hi everyone, an extract from a source sys…
-
Data Integration - connection cloud to cloudContent Hi all Does Oracle support / facilitate Data Integration from Cloud to Cloud? I see that it is designed to pull data from on-premise to Cloud, but not Cloud to c…
-
Migrate On-prem Essbase Data to Oracle EPM CloudContent we have a use case to migrate 1.8 Million or more records from on-premise Hyperion Essbase to Oracle EPM - PBCS cloud SaaS Application. We see limitation on FDME… -
Generate Data in Query with ThresholdSummary Generate Data in Query with ThresholdContent Hi - Is there a way we can generate Data through PCMCS Query with a threshold, say I would like to have only the Cos…Amit Agarwal-158816 43 views 3 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
Using Substitution Variables in Data Exchange FilesSummary Using Substitution Variables in Data Exchange FilesContent Hi- Is there a possibility to use substitution variable as a suffix in Data Exchange output files? We …Amit Agarwal-158816 47 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Deleting data in Data ManagementSummary Data was loaded in Data Management by mistake. We want to delete it before Exporting to FCCSVersion 21.06Roshni Mohan 36 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close