Data Integration
Discussion List
-
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 61 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 54 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 24 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Unable to retrieve Average exchange rate from Fusion GL to FCCS using direct integrationSummary: The integrated exchange rate import process in FCCS brings only Closing rate, while trying to retrieve closing rate & average rate from Fusion GL to FCCS Conten…Dhanasekaran Kasimani-Oracle 84 views 8 comments 0 points Most recent by Rushikumar Shah-Oracle Financial Consolidation and Close
-
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…
-
Set Default Export Mode in Data ExchangeSummary: Hi. Is there a way to set the Default Export Mode for all Locations in Data Exchange? We have a rule which sets the Export Mode in Data Management. We wanted to…Alyssa Longo 9 views 2 comments 0 points Most recent by Ashutosh Bhatikar-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…
-
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… -
[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 106 views 3 comments 0 points Most recent by User_ZCB13 Financial Consolidation and Close -
FX RATE load from Oracle EBS GL to FCCSSummary: Raising this question under Financial Consolidation and Close section : We have a requirement to load FX RATES from Oracle EBS GL to FCCS using Data management/…
-
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 34 views 1 comment 0 points Most recent by Sunil Gavvala-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 12 views 0 comments 0 points Started by Antonio Barbaro 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 462 views 20 comments 0 points Most recent by Ashutosh Bhatikar-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 23 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 13 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 26 views 2 comments 0 points Most recent by Tjeerd Huisman Financial Consolidation and Close -
Data exchange - pipeline process details display incorrect informationSummary: Content (please ensure you mask any confidential information): Hi all Has anyone seen this behaviour with pipelines process details? They seem to display very r…Nkehli 34 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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…
-
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 338 views 6 comments 0 points Most recent by BrettMac24 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…
-
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 23 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 22 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 35 views 5 comments 0 points Most recent by Vani-Oracle Financial Consolidation and Close
-
Import from Excel In data load mapping is not workingWe have exported the mapping to excel using Export to Excel option in Data Load Mappings, then added the new mappings in Excel, then when we try to import the excel we a…Prem Siva Kumar Reddy Rami Reddy 3 views 1 comment 0 points Most recent by Dhanasekaran Kasimani-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…Nkehli 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close