Data Integration
Discussion List
-
Print Substitution Variable Value in Pipeline Integration EmailSummary: Hi I am using the substitution variables Consolidation_Period and Consolidation_Year for data loads and its picking the values perfectly, the only issue is that…Shimona Gupta 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCC Pipeline Job Type Import Mapping – RTP for NAMEHi all, The ability to copy pipelines definitely made our work easier. Over time, however, we realized that configuring a specific setting was quite tedious. We need mul…Andreas Otto 31 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Is performance affected by using multidimension mapping for all dimensions in EPM Data Management?Summary: Hello Oracle Experts, We are loading data from a source file with 4 columns (like Account, Entity, Cost Center, Department, Location). In our Data Management se…Vijay_Babu 26 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Oracle FCC Data Management – Invalid Intersection CustomizingHello all, We are looking for a meaningful solution to provide our data integration users with an Intersection Validation Report - comparable to what we had in FDMEE. We…Andreas Otto 41 views 2 comments 3 points Most recent by user11033576 Financial Consolidation and Close
-
FDM Invalid Intersection report in Oracle FCC data managementHi All, We are having invalid intersection reports in FDM, would like to know how to implement the same in Oracle FCC data management. Also like to know how to invalidat…Prem Siva Kumar Reddy Rami Reddy 251 views 10 comments 2 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
How to schedule Automated Data import from Oracle Fusion to FCCSSummary: We import data from Oracle Fusion to FCCS every month, and we do this manually by executing a job from Data Management for each location separately. However, we…wojciech.furmanek 42 views 7 comments 0 points Most recent by Sinan_Koybasi Financial Consolidation and Close -
How can I leverage groovy to execute the Data Integration in FCCSSummary: I am trying to use groovy to run an integration using groovy in FCCS. I was able to do the same easily in EPBCS. Same is not working in FCCS. Appreciate thought…Srinivas Bobbala 32 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
NewLoadYTDClosingBalanceInput not working as expected with prior period movementsSummary: For a customer we are encountering issues with balance sheet accounts in combination with the NewLoadYTDClosingBalanceInput substitution variable (YTD Reversal …Tjeerd Huisman 82 views 3 comments 0 points Most recent by Camille Dhallenne Financial Consolidation and Close -
SAP source system is not able to maintain connectivity with Oracle EPM FCCS due to TLS version diff.The SAP source system is using TLS 1.2 and Oracle EPM Cloud application support 1.3 ( as per the Oracle docs ) due to which the SAP team is not able to setup the connect…
-
FCCS | Data Exchange - No acess to folders in file browserSummary: When we access Data Exchange > Actions > File Browser, we can´t see any folders, even though they were created. At the same menu but in Data Management, we can …Timestamp EPM Team 71 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Data Load Strategy Entity wise vs Region wise DLRs Best PracticeHello Oracle Experts, We are currently working on the data integration design for an Oracle FCCS implementation and are seeking guidance on the best approach for structu…Vijay_Babu 13 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Can we reconcile system transactions without using bank statement lines?Summary: Can we reconcile system transactions without using bank statement lines? Content (please ensure you mask any confidential information): Version (include the ver…Varalakshmi N 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
IPM Insight- How to start with testing for IPM Insight. Do we need to have different cube for IPM.Summary: Can anyone define the process for testing IPM Insight in FCCS. Content (please ensure you mask any confidential information): Version (include the version you a…SJ00793615 58 views 4 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Map Member in Data IntegrationI can't access dimension data when map membee in data integration because "Unable To Retrieve Members. Either The Target Is Unreachable Or You Do Not Have Permissions" I…
-
Is there any EPMautomate command to update period mappings in FCCS?Summary: Clients wants to update the period key under period mapping for one of the target application on everyday basis. They also want it to be automate. How can we do…Harshith J Rao 22 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is there a way to create the reports folder under the outbox folder in the Data management EPM FCCS?I have mistakenly deleted the reports folder in the outbox folder in the Oracle EPM FCCS data management. I was trying to delete the reports generated in the reports fol…RatnaMaruboina 41 views 6 comments 0 points Most recent by Vinay Gupta-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… -
EPM Platform Job Job Type for Planning Jobs to run integrationsHi, We have a requirement, where we need to run the integration/Data Load Rule present in EPBCS from FCC using Pipeline. Could you please me know if there is a way we ca…Prem Siva Kumar Reddy Rami Reddy 12 views 2 comments 0 points Most recent by Prem Siva Kumar Reddy Rami Reddy Financial Consolidation and Close
-
How to integrate secondary ledger of of Oracle ERP to FCCSSummary: There is a requirement in our project to integrate secondary ledger of Oracle ERP in FCCS. Is it possible to have a direct connection like Oracle primary ledger…Pooja Jain 11 views 1 comment 0 points Most recent by Preston Oakes Financial Consolidation and Close
-
Can we hold SO if customer is having past overdue invoices?Summary: While creating the sales order need to put hold if customer having any past due invoices Content (please ensure you mask any confidential information): Version …Varalakshmi N 15 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How can we remove shared entities from a Data Management extract?Summary: We need to generate a SOX control from Data Management. Content (required): The shared entities are duplicating the results. We have tried using mapping to filt…Michelle Wagner 106 views 9 comments 0 points Most recent by Michelle Wagner Financial Consolidation and Close
-
FCCS Import Data with member not allowedHi all, i'm trying to copy an application and i need to copy data, so i'm using import functionality. The import job is failing due to not allowed members (all reporting…MS. 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Integration> Load from FCCS to TAX fail due to COMMA in the Account nameSummary: Content (please ensure you mask any confidential information): Hi all Could someone please let me know how to go about this limitation: In Planning it is possib…
-
How to pull the data of a specific date from Oracle GL Average Daily Balance cube?Summary: Client wants to pull data of a specific date from Oracle GL ADB cube. They do not want to pull the data from last day of the month. For example, Today they want…Harshith J Rao 42 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
FCCS - File based FX rates load through Data Management best practice.Hi Team, We have recently set up the DataManagement process to load FX rates file to FCC. The steps we followed 1.Created FCC Rates target application 2.In target applic…
-
Pipeline email: is it possible to print the value of the substitution variable?Summary: The March 2025 update added pipeline variable definitions to the email notifications generated from pipelines (see Oracle Fusion Cloud Sales Planning March 2025…
-
How to Dynamically Pass Multi-Year Range from Pipeline to Business Rule in Oracle EPM?Summary: I am working with a pipeline in Oracle EPM where I have attached a business rule to the pipeline execution. The pipeline itself is configured to run over a spec…Deepthi G-Oracle 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
SDM Validation Unable to Retrieve FCCS Account Balance ValuesWe are currently facing an issue where, Supplemental Data Management validation process is unable to fetch account balance values from FCCS. Despite having the necessary…
-
Using Conditional Expressions in FCCS Import Format to Handle Empty ColumnsI need to perform an integration in Oracle FCCS where I have a third-party dimension. The issue is that from the source system (NetSuite), the information for this dimen…User_F8Z0S 22 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Data Exchange new dimension metadata refresh errorSummary: Content (please ensure you mask any confidential information): Hi All Under Data Exchange under the application section, there is an option to create additional…NK2025 47 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close