Data Integration
Discussion List
-
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 630 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 3 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 13 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 82 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 126 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 72 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 33 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 13 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 183 views 3 comments 0 points Most recent by User_ZCB13 Financial Consolidation and Close -
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 151 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 22 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 83 views 11 comments 0 points Most recent by Narayan 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 34 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 468 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 36 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 31 views 5 comments 0 points Most recent by Vani-Oracle Financial Consolidation and Close
-
Clarification on New System Maintenance Process for Consistent Data Load Performance in 24.11Summary: Hi Oracle, Can you please provide update on disabling the below feature provided in the 24.11 release notes: To address inconsistent data load times, Data Integ…Ramsha Ansari 41 views 2 comments 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close
-
Pull Dynamic Calc Member Values using Data Load RuleHi all, We are trying to pull values from members in which are dynamic calc for the consolidation dimension using a data load rule, has anyone been able to accomplish th…Sarah Paroya 22 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Management AuditSummary: We are looking to find a way to audit/see a record of changes in DM. For example, we had a change made to the Execution Mode of one of our Batch Definitions. We…Alyssa Longo 12 views 3 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Oracle FCCSUnable to copy Lvl0 data from P01-FY25 to P04-FY24 from one period to another, in FCCS. What are the ways to copy all Lvl0 data from the period P01-FY25 to P04-FY24? We …Global Support Desk 13 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Exchange menu unavailable under Application in FCCSHi All, I don't see 'Data Exchange' sub-menu under Application menu in FCCS. Although I see this in a test environment, the same is unavailable in Production environment…Thiru Vedantham 12 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Drill through from FCCS to PowerBIHello, Is it possible to setup drill through URL from FCCS to PowerBI report and - most importantly - pass members from application dimensions as values for report's URL…
-
Users Unable to see the existing file and folders (flat file) in Data exchangeSummary: Hi , Power users having access all the entity, he trying to upload the file in Data Exchange card. but he can upload the file but file is not visible and he can…Nagarajan Mouttouvelou 272 views 10 comments 0 points Most recent by Sandeep Hardikar N S Financial Consolidation and Close
-
Is there any Security feasibility available on using Import and Export mode optionsIs there any option to hide this import /export feature.Eshant Gupta 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Pushback FCCS Journals to Oracle on-premise EBSHello EPM Community, I am currently working on integrating FCCS (Financial Consolidation and Close Cloud Service) with our Oracle E-Business Suite (EBS) and need some as…Navikesh 43 views 1 comment 0 points Most recent by Karan Varshney Financial Consolidation and Close
-
data integration: Browser's autofill option affecting Pipelines propertiesSummary: Content (please ensure you mask any confidential information): Hi all Hs anyone experienced that Pipeline properties such as Types or Files names sometimes disp…