Data Integration
Discussion List
-
Change of Sign in SQL Data Management MappingsHello everyone, I hope you are all doing well. I am reaching out to get your perspective on a case I am working on for a project. In the context of data management mappi…Miguel Medina Cerda 21 views 4 comments 0 points Most recent by N.S-Oracle Financial Consolidation and Close -
Open Batch behaves differently for PCM and EPCM, but both are under common DM and follows same URLSummary: Open Batch behaves differently for PCM and EPCM, but both are under common DM REST and follows same URL then why is this inconsistent? Content (please ensure yo… -
Data is doubled in EPBCS from FCCSSummary: I noticed that the data in EPBCS is doubled from FCCS amount. See details below. FCCS Data Form: Data Load Rule Filter: Data in EPBCS: Thank you! Bianca Content…User_ZCB13 71 views 15 comments 0 points Most recent by User_ZCB13 Financial Consolidation and Close -
Groovy script used with Other Web services is blocking a portSummary: Content (please ensure you mask any confidential information): Hi all We have an issue where a connection used with Integration to OIC, using groovy is timing o… -
FCCS data integration Option to copy DLR availability?Summary: While developing JDE integration, we have come across create multiple DLR in data integration screen and every time we have to do certain steps to create new DL… -
Pipeline not passing Source Filters to DLR after update 25.02.83Summary: Pipeline not passing Source Filters to DLR after update 25.02.83, this works in 25.01.31. Content (please ensure you mask any confidential information): Source … -
Data Management - Description for Multi - GAAPSummary: Data Management - Description for Multi-GAAP Dimension Content (please ensure you mask any confidential information): Hi All, is possible to have in Data Manage…Antonio Barbaro 1 view 1 comment 0 points Most recent by N.S-Oracle Financial Consolidation and Close -
https://localhost:9000/aif/rest/V1/jobsHello, I am using this connection for one of my pipeline and rule but since the 25.02 update, it is not working anymore. Can someone help me with a workaround? I tried u… -
Has anyone had issues with Data Integration Mappings disappearing overnight?Summary: Mappings disappearing from Data Integrations overnight, across multiple Locations Content (please ensure you mask any confidential information): We've had a few… -
While building import format, new dimension is not visible in Data Management EPBCSWe created a new dimension named 'category'. While building import format, this dimension is not visible in the dropdown to map columns in EPBCS. We are using file based… -
Power user not able to export data via Data management using replace modeSummary: Content (please ensure you mask any confidential information): Until last week we were able to export data via Data management using REPLACE mode and now we see…NKW 31 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Loading of P13 data from FCCS to P13 EPBCS ASO cubeSummary: What setups to do to load P13 data from FCCS to P13 EPBCS ASO cube? Content (please ensure you mask any confidential information): Version (include the version …User_ZCB13 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
FCCS Data Exchange not throwing error on loading data at parent accountSummary: FCCS Data Exchange not throwing error on loading data at parent account. Is it expected behavior or a bug. Current Scenario : Content (please ensure you mask an…AlokP 71 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Automate creation of Integration (Data Exchange)Summary: Is there a way to automate creation of DLR / Integration (Data exchange) - FCCS Content (please ensure you mask any confidential information): More than 500 DLR…Jai Prakash 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
No Data being loaded to FCCS to specific new accountsSummary: Despite correct data loading map from ERP, there is no data being loaded to FCCS for these newly created accounts: 150300006 EQUITY INVESTMENT IN JV – MMP 15810…Martha Pauline Malaluan 71 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Map Monitor Audit Report data retention?Summary: We have enabled map audit. Client is asking how long will the FCCS system retain this mapping audit information? Version: Service: Enterprise Performance Manage…Shawn Paperwala 81 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
DataMap error-The dimension 50962 is invalid.In EPM cloud Planning data maps I am trying to save one of the DataMap (which is cross pod) and I got the error called "The dimension 50962 is invalid". Any suggestions/… -
Mapping is not triggered/not visible in the workbenchSummary: When loading data into ARCS in this case, we do not see the triggered mapping when we click "view mapping" in the workbench. We have a mapping issue on that dim…Pieter-Jan Vandendriessche 11 views 1 comment 0 points Most recent by Pieter-Jan Vandendriessche EPM Platform and Freeform -
Is it possible to drill through on-prem PeopleSoft General Ledger using URL from FCCS?Summary: Is it possible to drill through PeopleSoft General Ledger using URL from FCCS? Eevnthough we are pulling PeopleSoft table data to FCCS using EPMagent. Our requi… -
Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Summary Is it possible to use User Defined Attribute (UDA) in Data Management for PCMCS?Content Hello experts, I want to build a a DLR in Data management to export data …Parmit Choudhury-Deloitte 234 views 8 comments 0 points Most recent by User_511P1 Profitability and Cost Management -
Valid Intersections Causing Large Performance Issues with Data ManagementSummary: With valid intersections enabled, a 7000 line file times out at 30 minutes; with them disabled, it takes 5 minutes. Content (please ensure you mask any confiden…Dale Joosten 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Authentication error when importing data into Profitability and Cost Management from EPM Planning.Hello!!! I have an integration to import data into a Cost and Profitability environment from an EPM Planning environment. Initially, the integration worked correctly, bu…User_F8Z0S 21 views 1 comment 0 points Most recent by Don Bean-Oracle Profitability and Cost Management -
Inclusion of rule description in output file generated in case of EPCM to GL direct integrationSummary: How to add journal description in data extract file automatically created in FBDI format in case to EPCM to GL direct integration Content (please ensure you mas…Deeksha Gupta EPM 31 views 4 comments 0 points Most recent by Deeksha Gupta EPM EPM Platform and Freeform -
Is it possible to reference attributes in member mapping?Summary: I would like to reference values in an attribute dimension in a member mapping Content (please ensure you mask any confidential information): In my Product dime… -
Unable to set decimal precision for Data integration and EPCMSSummary: Content (please ensure you mask any confidential information): Hi all When exporting Data using data management with EPCMS I am not able to set the data decimal… -
Data Integration Pipeline - EPM FCCS Job - Clear Data not working for power userSummary: We created a pipeline in FCCS to execute jobs, one of which is the "Clear Data" job. The pipeline must be run by a Power User. When executed with System Adminis…Gayatri Vurukuti 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
MDX Descendants function - Exclude Level 0 baseSummary: How do we design the MDX Descendants function to return parent members only and exclude level 0 base members? Content (please ensure you mask any confidential i…Jacalyn Munyon 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close