Data Integration
Discussion List
-
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 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…Sudha V 113 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 21 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 12 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 12 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 2 views 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 551 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 2 views 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 …
-
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 66 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 32 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…
-
[Data Integration] Trouble pulling ONLY adjustment period (P13) data from Oracle ERP Cloud into FCCHi everyone, I am trying to pull adjustment period (P13) data from Oracle ERP Cloud into FCC. However, when I do so, it also pulls Dec data. Does anyone know how to avoi…Matt Maurer 167 views 3 comments 0 points Most recent by User_ZCB13 Financial Consolidation and Close -
IGNORE Mappings in SQLSummary Error exporting to FCCS when mapping to IGNORE utilizing SQL scriptingContent Was hoping someone could help with this. I setup Data Load Mapping using SQL script…
-
NetSuite Integration with FCCS1.Our goal is to load trial balance data directly from NetSuite ERP into FCCS. 2.We understand that there is no specific documentation available for integrating NetSuite…K Maheswara Reddy 41 views 1 comment 0 points Most recent by Sunil Gavvala-Oracle Financial Consolidation and Close
-
Substitution Variable - Not Working in Custom Application FDMEESummary: Issue with using Substitution Variable in FDMEE Content (please ensure you mask any confidential information): Hi All, we noticed an issue with a Custom Applica…Antonio Barbaro 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Facing issue having error message starting with "You are trying to change the data" after patchSummary: While deploying rules or try opening forms, we are facing below issue in the EPM application after the patch has been updated on Friday. Appreciate your help an…Subramanian Karunamoorthi 81 views 11 comments 0 points Most recent by NarayananS Financial Consolidation and Close -
Load Data in YTD_InputHello, The cumulative data upload (YTD_Input) forces you to define a single "Default Movement" per accounting account ("Calculate Movement rule"). If so, how could I loa…CarolinaRodriguez 12 views 1 comment 0 points Most recent by CarolinaRodriguez Financial Consolidation and Close
-
Use substitution variable in data integration pipeline jobSummary: We would like to use substitution variables for the start/endperiod of a data integration as part of a pipeline job (with a few integrations and a consolidation…Tjeerd Huisman 22 views 2 comments 0 points Most recent by Tjeerd Huisman Financial Consolidation and Close -
Showing Balance Sheet Accounts with natural signage from TB and P&L Accounts with sign flip in FCCSummary: Hi All Client requires us to show Balance Sheet Accounts with natural signage from ERP and P&L Accounts with sign flip. This requirement is from reporting stand…Parmit Choudhury-Deloitte 366 views 6 comments 0 points Most recent by BrettMac24 Financial Consolidation and Close
-
How to connect Oracle DB from EPM?Hi Team, As part of integration project, we would like to connect Oracle DB from EPM; which could help us to create a view and get the desired data from Oracle DB to EPM…Sukanya 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to pull FCCS data with fully qualified name.Summary: I'm working on integration to PBCS. I need map Entity Dimension shared member to different entity Target in PBCS with its base member to separate consol elimina…Rosida Majid 33 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Controlling Standard Movement Calculations based on ClosingBalance_InputHello, In our FCCS system, some entities in the group load both the Closing Balance and Movement Balance, while others provide only the Closing Balance. For entities tha…Bjoern Schumacher 34 views 5 comments 0 points Most recent by Vani-Oracle Financial Consolidation and Close
-
How to lock a POV for several periods in Data ManagementSummary: Content (please ensure you mask any confidential information): Hi all In Data Management for EPM there is a option to LOCK a POV for a specific period, but I do…NK2025 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close