Data Integration
Discussion List
-
Trial balance with Multiple currenciesSummary: Content (required): Hi guys, Our client extracts from the ERP a trial balance with multiple currencies, and then, in Excel, they make the currency conversion. I… -
[Data Integration] Using a dense dimension as the Source Dimension for multiple Target DimensionsHi everyone, I am trying to use a dense dimension (Account) as the source for multiple target dimensions in a data integration. This is in the context of a data extract …Matt Maurer 21 views 7 comments 0 points Most recent by Matt Maurer Financial Consolidation and Close -
DRCRSplitSummary: Hi All, In PCMCS import mapping expression in account dimension when we click on pencil button there is a different type of expression type there out of them I …Mrinmoy Paul 21 views 2 comments 0 points Most recent by Mrinmoy Paul Profitability and Cost Management -
Period MappingSummary: Is it is possible to load .csv or .xls file in period mapping. Because currently, I create a one-by-one-period mapping in PCM Data management. For Example, if c…Mrinmoy Paul 31 views 3 comments 0 points Most recent by Viral Soni Profitability and Cost Management
-
Integration using FDMEE from HFM to TRC - Best way to launch consolidation in TRCSummary: How to kick off consolidation in TRC immediately after FDMEE integration from HFM on premise Content (required): An FDMEE integration from on-premise HFM to TRC…Chris Garman 43 views 1 comment 0 points Most recent by Ken Kramer-Oracle Tax Reporting (Direct Tax) -
Unable to select Numeric Data only optionSummary: Hi all, I try to change the Load method to a Numeric data type but facing some errors. For Ref I attached the screenshot below:- Content (required): I connect m…Mrinmoy Paul 11 views 2 comments 0 points Most recent by Mrinmoy Paul Profitability and Cost Management
-
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 12 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