Data Integration
Discussion List
-
Adding dimension members through Data Management in PCMSummary Adding dimension members through Data Management in PCM is possible?Content Addition of dimension members through Data Management in PCM is possible? It was answ…User_2025-02-05-23-55-14-602 40 views 7 comments 2 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
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 41 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 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