Data Integration
Discussion List
-
Is there a check reports to set a condition for data load via Data Integration / Management?Summary: Content (please ensure you mask any confidential information): Hi all in FDMEE we could use this check report: https://docs.oracle.com/en/applications/enterpris…NK2025 21 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Copying select data from one scenario to another complicated by journalsSummary: I want to copy a subset of data from one scenario to another scenario. Using the Data Copy function, the problem I'm having is with the journals. If a journal h… -
Frequency of quarterly data loads from Oracle Fusion Cloud ERP GL to FCCSSummary: Hi all, We have a request from the business to load financial data for the quarter into FCCS from ERP GL every hour instead of the current frequency of every 3 …Irfan Ali Gangjee 21 views 1 comment 0 points Most recent by Payal Vaidya-Oracle Financial Consolidation and Close
-
Unmapped records failing load despite account being mapped to IGNORESummary: Has the solve order changed such that ALL members must be mapped, even if one of them maps to IGNORE? Content (please ensure you mask any confidential informati… -
How to access Map Monitor Audit Reports within Data ExchangeSummary: Currently within Data Management, there are a series of audit reports that we regularly run for Audit and Controls purposes (See Data Management > Workflow > Re…John Herbert-271036 65 views 3 comments 3 points Most recent by Tbian7577 Financial Consolidation and Close
-
DM Update 19.06, Producing Flat-File Extracts out of Cloud Data ManagementSummary As an EPM Administrator or Implementation Specialist, we have all had that moment when someone comes to us and asks for the dreaded extract out of an Enterprise …User_2025-01-30-05-17-11-782 71 views 2 comments 2 points Most recent by Neha Talati-267028 Financial Consolidation and Close -
Connection between FCCS and IBM Planning Analytics version 2.09.02Summary: We are now looking to see if FCCS can send data feeds into IBM Planning Analytics version 2.09.02 in real time. One of our branch is using this system to do rep…Hugo Bergeron 94 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - Movement dimension member mapping for Accounts in Data Management loadsHi Team, We are implementing new FCC application with ERP cloud as source. We set it up the Accounts dimension and assigned Movement dimension member as like below. In F…Ankamma 308 views 9 comments 0 points Most recent by GaneshN-Support-Oracle EPM Platform and Freeform
-
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …Sarah Paroya 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …Sarah Paroya 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How can we schedule pipeline?Summary: How can we schedule pipeline? Content (required): How can we schedule pipeline in Oracle FCCS? Version (include the version you are using, if applicable): 23.08Shelbi 183 views 17 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Load failuresSummary: Hi We are seeing data load in to FCCS fails. Below is the error message. Can you please help us as this issue is in production? Error Message: HTTP POST on reso…Divya_Masoodi 81 views 13 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
Entity should not have intercompany with itself. How to restrict data load for these intersectionSummary: We wanted to restrict data entry to the intersections - Entity and intercompany itself. Content (please ensure you mask any confidential information): Version (…Kumara Surendra 11 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Dry Run on EPBCS applicationSummary: Dry Run on EPBCS application Content (please ensure you mask any confidential information): Hi Oracle, We tried running dry run in EPBCS and could not find opti…Ramsha Ansari 32 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to put validation to make sure that intercompany account is always tagged with ICP EntitySummary: We wanted to make sure that we always have Intercompany accounts being tagged with ICP entity so that the data in the Intercompany account will be eliminated pr…Kumara Surendra 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
YTD PL Account can't be filtered when integrating from FCCS to PBCSSummary: I did integration from FCCS instance to PBCS instance. I already filter the dimension that I need (YTD data for BS and PL account). Unfortunately, the result is…
-
FCCS | Data Exchange - Export Data ErrorFCCS | Data Exchange - Export Data Error In Data Exchange > Workbench > Actions > Export Data: when tryinng to export mode online, the process ends with the error "Expor…Timestamp EPM Team 101 views 7 comments 0 points Most recent by Timestamp EPM Team Financial Consolidation and Close
-
FCCS Data Management job fails with tunnelling error messageSummary: We have jobs being run overnight with EPMAutomate used to extract data from our Oracle Fusion ERP and load into FCCS and EPBCS within 5 minutes of each the one …Jeremy Stubbs 31 views 4 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
Unable to extract data from FCCS with 4 decimal pointsSummary: We are trying to export data from FCCS to flat file using data target application for particular POV and we have specified data precision and data number of dec…ShubhamV 45 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Setup EPM Agent (Additional?)Hello all, How do you get the EPM agent to pull data from an additional data source? How or where is it configured? We have a single EPM which pulls data into our FCC/AR… -
SubVar DataLoadConsolMember set to TRUE is not workingSummary: We add this subvar DataLoadConsolMember to TRUE to prevent data amount override being cleared during export data to FCCS using Replace Method, but don't know si…J Mahero L 124 views 20 comments 0 points Most recent by Joost Mellegers Financial Consolidation and Close
-
Data Load Rule Data Not Populating FCCSHi all, We are trying to directly integrate FCCS and OAC, so we have set up a data load rule that extracts the data from FCCS and puts it in an excel file that gets pick…Sarah Paroya 43 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Drill through from FCCS to Cloud ERP redirecting to a different URLSummary: Drill through from FCCS to Cloud ERP redirecting to a different URL Content (please ensure you mask any confidential information): A connection is setup in Data…
-
Downloading file from OCI sub-directory using Pipeline Object Store JobsSummary: Using EPM Pipeline - Object Store Jobs, I tried downloading a file from root folder of OCI bucket, it worked fine. I need to download the file from sub-director…Mohit Sharma-73954 31 views 2 comments 0 points Most recent by Mohit Sharma-73954 Financial Consolidation and Close
-
Import Data using a text file by a Power User or UserHi all, In our application we have users with the Power User and User role. These users need to load data in the application using a text file. After creating the Data I…Stefano Guida 52 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Is FCCS able to connect ERP daily cube to get Average Daily Balance (ADB) for creating dashboard?Summary: Is FCCS able to connect ERP daily cube to get Average Daily Balance (ADB) for creating dashboard? Content (please ensure you mask any confidential information):…Sukittima Siwapetcharakorn 32 views 5 comments 0 points Most recent by Sukittima Siwapetcharakorn Financial Consolidation and Close
-
Data Management and Data Integration Setup Security for Role "User"Summary: Is there something that need to be setup for Role "User" to access Data Management and Data Integration. I have enabled "Location Security" and have assigned us…J Mahero L 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to Extract data in FCCS_YTD?Summary: I want data extract in FCCS_YTD, however I am getting Extract in FCCS_Periodic . I changed the Source Option as "FCCS_YTD", still result is showing FCCS_Periodi…Sneha Mallick 21 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Question related to format number - Custom ApplicationSummary: Question related to format number - Custom Application Content (required): HI All, in my FCCS Application, I created a specific Custom Application in order to h…Antonio Barbaro 41 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
loading exchange rates - Entity is locked.FCCS newbie here. I have been tasked with loading exchange rates to FCC. I have an integration pulling data from a ERP BI Publisher report and loading to the rates cube.…