Data Integration
Discussion List
-
DM: Getting unusual errors when doing a metadata refreshSummary: Content (required): When we do a metadata refresh we get these strange errors which do not make sense and log is not generate even though it is set to level6: T… -
FCCS DSO no direct integration to ARCS in data management?Hi all, We need to integrate data from FCCS with Account Reconciliation, however there is no target type of ARCS in data management. Is there a way to integrate directly?yanni vossos 121 views 2 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Error loading YTD trial balance file into FCCS.Summary: We are trying to load YTD Trial balance file into FCCS. This file was used to load into HFM and now we are trying to load it into FCCS. When loading under YTD_I…Zenithz 71 views 8 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
Best practices for updating EPM Integration Agent on Linux platformSummary: Hello experts, I'm looking for best practices of updating EPM Integration Agent on Linux Platform. Content: What are the recommendations to update Integration A…Ganesh Golla 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
High performance data export from PCMIn case you missed it: In update 21.12 the exportQueryResults function was enhanced to support fast and scalable export of level 0 data from PCM. With this new enhanceme…Don Bean-Oracle 61 views 7 comments 3 points Most recent by AndrewLaferla Profitability and Cost Management -
How to check EPM Agent Run status on Linux machineSummary: We have configured the EPM Agent in asynchronous mode on OCI box (Linux). We need to monitor Agent run status. Content (required): To Monitor Agent status, we a…
-
FCC Task Manger Integration of Reporting Packages from Narrative ReportingSummary: How to integrate in FCC Task Manger as a Basic Task a Reporting Package from Narrative Reporting? Content (required): Hi all, what is the best practice/ are det… -
'Check' Function in Data Management giving error if we use alternate hierarchy for Entity in FCCSSummary: Im using 'Check' feature in Data Management (4th fish in Import-Validate-Export-Check ) 'Check' is giving me error if I use alternate hierarchy for entity dimen…Srinivas Hindupur-Oracle 51 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPM Integration Agent Unable to WriteBackSummary: Am trying to Writeback Forecast data from PBCS to On-premise DB and getting error which i am not able to fix. Content (required): Trying to export data from PBC…Amith Kumar Madisetty 41 views 12 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform -
Local and Reporting FX data import rather than Calculation in FCC - what is best practise?Summary: What is best practice for FX ledgers, pull from ERP or re-calculate? Content (required): A client is using SAP erp and has multiple ledgers with local and repor…Lesa Muir-175186 42 views 6 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close
-
YTD INTEGRATIONSummary :- Facing issue in running the rule on YTD When I'm trying to run the rule for a complete financial year (1st Jul 21 to 30th Jun 22) I'm getting an error but whe…User_2025-02-10-10-48-52-544 31 views 6 comments 0 points Most recent by User_2025-02-05-23-55-14-602 Profitability and Cost Management -
Added ASO target app in TRCS data management,but "Refresh metadata/member" continues to fail.Summary: Added EPM Cloud Essbase (ASO) target app in TRCS data management,but "Refresh metadata/member" continues to fail. Content (required): We wanted to integrate wit…
-
Integration Agent two different ARCS pods.Hi all, We need to clone our ARCS prod POD to test POD. Both instances have configured a separate integration agent. What will happen after the cloning to the test envir…yanni vossos 12 views 1 comment 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Can you connect Oracle ERP to Repository / Reporting Web Studio?Summary: Client is trying to create an automated data load reconciliation report at hash totals. As the DM cannot extract data at dynamic calc members, we are looking in…Ryan Heyvaert 21 views 5 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close
-
Integration agent two different FCCS pods possible?Hi all, As we migrating our FCCS application to enterprise license POD DSO, is it possible to connect to an existing integration agent from the old POD? Thank you yannis
-
What member (movement) do I load my first ever Trial Balance to?Summary: First time user for consolidation. Struggle to find to get started with my first period. what member does this need to be loaded to? Content (required): My firs…Ilse De Vries - Sinube 51 views 7 comments 0 points Most recent by Kapil_Bankeraika Financial Consolidation and Close
-
FCCS default Period Mapping is not showing data managementSummary FCCS default Period Mapping is not showing data managementContent Hi All, We have created FCCS application with adjustment period(P13) and when we are trying to …User_2025-01-30-22-17-55-523 65 views 6 comments 1 point Most recent by User_CGD11 Financial Consolidation and Close
-
Delete AttributeSummary: Deleting the attribute How can we delete the attribute which is not in use anywhere in the application whereas as before it was associated with one of the dimen…User_2025-02-10-10-48-52-544 41 views 5 comments 0 points Most recent by Evan L Profitability and Cost Management
-
Is there Business Rule in PCMCS?Summary: After reading "Oracle Enterprise Performance Management Cloud Operations Guide" I was interested in setting Business Rule to optimize the BSO Cube, but I can't …Francois Desjardins 31 views 3 comments 0 points Most recent by Aman Kothari-191377 Profitability and Cost Management -
How to load metadata through data management in PCMCS(Profitability and Cost Management)Summary: We are trying load meta data through data management In PCMCS. But We can not able fetch the target application. Content (required): Version (include the versio…Santhosh Kumar-262342 31 views 1 comment 0 points Most recent by Viral Soni Profitability and Cost Management
-
Guidance to Configure Data Management to Load Trial Balance Data for FCCSummary: Guidance to Configure Data Management to Load Trial Balance Data in FCC Content (required): We want to load Trial Balance (TB) Data for data being sourced from …Al_DuqueEstrada 82 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Load YTD data for BG accounts in JanuarySummary: Content (required): Hi guys, Is there any way of loading data YTD for balance accounts in January. We have tried several ways, but we can't find a proper one. W…Luli18 31 views 3 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
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