Data Integration
Discussion List
-
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 41 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…MKhade 23 views 7 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 51 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-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 64 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 113 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 21 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 91 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 11 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 95 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…MKhade 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 43 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 81 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…Sud VJ 111 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 1 view 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 656 views 22 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to pass 12 months forecast in time format 2024M10 - 2025M09 in one process to DWHi all, We are on a monthly basis reporting a 12 months rolling forecast to a Datawarehouse (DW) through the EPM Integration Agent. Date format in DW is like this exampl…Bo Løve Langhorn 1 view 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Viewing Historical Process IDs in Oracle Data ManagementSummary: Hello, We are currently experiencing an issue with one of the Oracle Data Integration process IDs. Example: Process ID 1627 was used during yesterday's integrat…VikramMed 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
What is the limit on the number of records that Data Exchange can import?Summary: What is the limit on the number of records that Data Exchange can import? Lets say we have a Oracle EBS source system from where we are importing 3million recor…
-
How can we load data directly from SAP cloud to FCCS using APISummary: Client want to have a API based connection where they can load the SAP files directly to FCCS. Is there an option to achieve this currently without using any mi…AniN 81 views 10 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
Loading of Adjustment period from ERP GL to FCCSSummary: We have P13 period enabled in FCCS and we're planning to load the adjustment period from ERP GL to this period. The connection we used was the native or out of …User_ZCB13 142 views 3 comments 0 points Most recent by User_ZCB13 Financial Consolidation and Close
-
Is there a way to automate data validation for all Entities and Accounts between Fusion and FCCS?Summary: Curious if anyone has found a way to automate data at all levels between Fusion and FCCS for Entity and Account? I don't think this is available standard out of…Greg Hull 78 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data Management - loading Debit and Credit using delimited fileHi All, I am able to load credit and debit from Delimited file in Data management using the below SQL but one of the issue i am seeing is change sign is not applying bec…Prem Siva Kumar Reddy Rami Reddy 44 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Mapping for amount based on accountcurrent setup is to receive amount in different columns. "Amount1" and "Amount2" If accounts are between 1000 and 2000 then Amount to be mapped as (Amount1 value divided…Dharanidharan M 11 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
FCC to PBC refresh members using REST APISummary: We need to automate the process of 'Refresh Members' for the Target application within FCC. An API will need to be established to call this function. This is to…