Data Integration
Discussion List
-
NewLoadYTDClosingBalanceInput not working as expected.Summary: The documentation says "When this substitution variable is set to True, Financial Consolidation and Close reverses the YTD closing balance from the prior period…Zenithz 151 views 5 comments 1 point Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Runtime error FCCS pipeline and EPBCS pipelinesSummary: We are running different integrations using pipeline, and it is failing at export stage for one specific integration. Rest integrations work fine, it is failing…Priyesh P. Rane 131 views 20 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
BS Account at FCCS_ClosingBalance Drill-Through not workingSummary: I am configuring the Drill Through in FCCS and when drilling through a Balance Sheet Account at FCCS_ClosingBalance intersection it is giving a default error th…Kenneth John Asper-Oracle 82 views 14 comments 0 points Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close -
What are the recommended steps to follow for closing business operations from one countryHi All, Our client based out from US and is planning to close the UK operations. Can someone please provide what are the recommended steps to follow to close out all the…
-
drill through to source from FCCS to Planning is generating an errorSummary: Content (please ensure you mask any confidential information): HI all While trying to drill through from FCCS to Planning we are getting this error: Error: ====… -
Run Data Exchange (Pipeline) ConcurrentlyWe built some data management rules and pipeline to enable multiple users to run the pipeline (or data exchange) to load different ledgers' TB from Fusion to FCCS. Howev…ESST 19 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Problem to edit multi dimension mapping via Data IntegrationSummary: Unable to edit Multi Dimension mapping via Data Integration Content (please ensure you mask any confidential information): Our Implementation Partner has added …Ilse De Vries 12 views 5 comments 0 points Most recent by Sarah Dow Financial Consolidation and Close -
Drill Through Error - EPMFDM-140138:No valid scenario could be found for the passed category:nullSummary: Getting error message as "EPMFDM-140138:No valid scenario could be found for the passed category:null" Content (please ensure you mask any confidential informat…PratikYadav 32 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
"POV Period" is RTP to Business rules doesn't change value based on the Period the integration"POV Period" is selected as a parameter for RTP and POV Period is "Feb-25" (running an integration for Feb-25 load) Data Integration log file shows show it correctly : B…Mangesh K 29 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
running Data Management Reports using PipelineHi All, We would like to run Data Management report "TB Current Loc, All Dimensions-Targets, By Target Entity-Acct (Cat,Per)" using Pipeline. Could you please let us kno…Prem Siva Kumar Reddy Rami Reddy 23 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCC to Planning Data ExchangeWe are trying to transfer journals from FCC to Planning using an integration. It is all working except for the load to Planning where we see the following error in the l…CatoTheElder 26 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
can you load data to an account with a member formulaSummary: We are attempting to load data for an account that has a member formula. For this account, one scenario should be calculated with a formula and another scenario…Michelle Kellogg 52 views 8 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
Period is not showing correctly in Data ExchangeIn my integration, I have mapped period to period in 'Map Dimension' But when I export the data, it is not showing my periods Any help is greatly appreciatedJames Coles 1 view 1 comment 0 points Most recent by Jagadiswar Rao Gandham-Oracle Financial Consolidation and Close
-
Can we load data in FCCS to Parent currency(USD) via DM so that it does not translate by default forSummary: We have a requirement where we are pushing consolidated data from FCC at parent currency level and then the allocations are calculated in PCMCS and then the dat…Kasi1981 22 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Do we need to establish new countries when creating new entitiesSummary: When creating completely new entities for the FCC that involve new countries, is it necessary to establish a specific reporting currency for these entities in t…Sanjana Soni 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
ERROR: Drill Region was not created/updated. No valid data rows exist in TDATASEG for Process IDWe are calling same dataload rule from the pipeline in sequential way, We have enabled Drill region. In FCCS we get error while running Dataload rule , but with similar …SrikanthReddy-Oracle 22 views 4 comments 0 points Most recent by SrikanthReddy-Oracle Financial Consolidation and Close
-
Partial Export of data into FCCS with failure in DMHi, We are testing changing the source of some locations in DM in a test environment. They are failing on the export step due to 2 rows of data flagging an invalid inter…Alyssa Longo 23 views 4 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - Error: Invalid Journal file format. Importing consolidation journals.Summary: We are trying to upload a consolidation journal into FCCS. We are getting an format error, which we havent had before. Content (please ensure you mask any confi…Pieter-Jan Vandendriessche 61 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to select entity alias in custom drill urlSummary: In FCCS, we have added a custom drill URL to drill into FDI report. When we hardcode the URL with a specific entity alias, it correctly lands on the desired pag…AishShirke 13 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
DataCopy with FCCS on-demand rulesSummary Is it possible to use DATACOPY in FCCS on-demand rulesContent Hi all, just have a question regarding the usage of Essbase DATACOPY from within FCCS on-demand rul…User_2025-02-03-23-55-06-250 86 views 3 comments 0 points Most recent by Sidd Mandal Financial Consolidation and Close -
support for exclusion in options->filters for an integrationWe have a very specific requirements for filter criteria for data export integration which is requiring us to hard code 100's of members in a filter. It would be great i…Mangesh K 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Why do I have to refresh the FCC Database after making a mapping change in Data Management.Summary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Alan Hall-251497 42 views 5 comments 0 points Most recent by Alan Hall-251497 Financial Consolidation and Close
-
Need to have an automated process to export Journal Entries into a file or database.Summary: Need to have an automated process to export Journal Entries into a file or database. Content (required): In HFM we were able to extract Consolidation Journal En…Zenithz 87 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS DM access provision and controlSummary: Hi Folks, We are looking for details how to segregate roles in FCCS Data Management. We would like to provision user with Drill through option to connect to Ora…Sudha V 112 views 22 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Custom Application FDMEE - File Name CustomizingSummary: Custom Application FDMEE - File Name Customizing Content (please ensure you mask any confidential information): Hi All, I have a question related to a Custom Ap…Antonio Barbaro 22 views 4 comments 0 points Most recent by Antonio Barbaro Financial Consolidation and Close -
Data integration issue with Intercompany dimension from fusion to FCCSHi Team, We are in the process of performing data integration between Oracle ERP Cloud and FCCS. While the integration setup has been completed successfully, we are faci…Suresh V 3 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCC - Drill Through to SAP URL parametersSummary: The client has provided a custom SAP URL for us to set up a Drill Through feature. During the configuration, I replace the placeholders for "Account" and "Entit…Joao Carlos Monteiro 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
can we validate if TB is equal to zero before loading into FCCSHello Experts, Can we check if the Trial Balance loaded into FCCS can be validated before exporting to FCCS in Data Integration ? We've a requirement to check if the TB …Kishan Kesanakurthy 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
EPM FCCS Case-InsensitiveWe are migrating from HFM (11.1.2.1.0) to EPM FCCS (FDMEE 24.11.07). I have come across an issue that is painful to say the least. Everything is case-sensitive in EPM FC…Brian Duncan 1 view 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Data Integration Pipeline - EPM Platform Job - Clear Data not working / need additional parameters?Hello, We have an FCCS "Clear Data" task that exists in the local FCCS application & runs fine manually via "Overview" -> "Clear Data" from FCCS, but we cannot get it to…Trey Daniel 535 views 22 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close