Data Integration
Discussion List
-
Automate creation of Integration (Data Exchange)Summary: Is there a way to automate creation of DLR / Integration (Data exchange) - FCCS Content (please ensure you mask any confidential information): More than 500 DLR…Jai Prakash 13 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
No Data being loaded to FCCS to specific new accountsSummary: Despite correct data loading map from ERP, there is no data being loaded to FCCS for these newly created accounts: 150300006 EQUITY INVESTMENT IN JV – MMP 15810…Martha Pauline Malaluan 65 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Map Monitor Audit Report data retention?Summary: We have enabled map audit. Client is asking how long will the FCCS system retain this mapping audit information? Version: Service: Enterprise Performance Manage…Shawn Paperwala 84 views 1 comment 0 points Most recent by Chansouda-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…
-
Valid Intersections Causing Large Performance Issues with Data ManagementSummary: With valid intersections enabled, a 7000 line file times out at 30 minutes; with them disabled, it takes 5 minutes. Content (please ensure you mask any confiden…Dale Joosten 24 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Integration Pipeline - EPM FCCS Job - Clear Data not working for power userSummary: We created a pipeline in FCCS to execute jobs, one of which is the "Clear Data" job. The pipeline must be run by a Power User. When executed with System Adminis…Gayatri Vurukuti 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
MDX Descendants function - Exclude Level 0 baseSummary: How do we design the MDX Descendants function to return parent members only and exclude level 0 base members? Content (please ensure you mask any confidential i…Jacalyn Munyon 24 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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… -
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/…
-
Data Input at Parent EntitySummary There is requirement where we have to enter data at parent level Entity.Content Hello All, There is requirement in FCC where we have to enter data through custom…Tushant Pandey-151106 448 views 10 comments 0 points Most recent by Hari Nagumalli - Oracle EPM-Oracle Financial Consolidation and Close -
NewLoadYTDClosingBalanceInput not working as expected.Summary: The documentation says "When this substitution variable is set to True, Financial Consolidation and Close reverses the YTD closing balance from the prior period…Zenithz 225 views 5 comments 1 point Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close -
Runtime error FCCS pipeline and EPBCS pipelinesSummary: We are running different integrations using pipeline, and it is failing at export stage for one specific integration. Rest integrations work fine, it is failing…Priyesh P. Rane 160 views 20 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
BS Account at FCCS_ClosingBalance Drill-Through not workingSummary: I am configuring the Drill Through in FCCS and when drilling through a Balance Sheet Account at FCCS_ClosingBalance intersection it is giving a default error th…Kenneth John Asper-Oracle 93 views 14 comments 0 points Most recent by Kenneth John Asper-Oracle Financial Consolidation and Close -
drill through to source from FCCS to Planning is generating an errorSummary: Content (please ensure you mask any confidential information): HI all While trying to drill through from FCCS to Planning we are getting this error: Error: ====…
-
Run Data Exchange (Pipeline) ConcurrentlyWe built some data management rules and pipeline to enable multiple users to run the pipeline (or data exchange) to load different ledgers' TB from Fusion to FCCS. Howev…ESST 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Problem to edit multi dimension mapping via Data IntegrationSummary: Unable to edit Multi Dimension mapping via Data Integration Content (please ensure you mask any confidential information): Our Implementation Partner has added …Ilse De Vries 11 views 5 comments 0 points Most recent by Sarah Dow Financial Consolidation and Close -
Drill Through Error - EPMFDM-140138:No valid scenario could be found for the passed category:nullSummary: Getting error message as "EPMFDM-140138:No valid scenario could be found for the passed category:null" Content (please ensure you mask any confidential informat…PratikYadav 46 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
"POV Period" is RTP to Business rules doesn't change value based on the Period the integration"POV Period" is selected as a parameter for RTP and POV Period is "Feb-25" (running an integration for Feb-25 load) Data Integration log file shows show it correctly : B…MKhade 21 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
can you load data to an account with a member formulaSummary: We are attempting to load data for an account that has a member formula. For this account, one scenario should be calculated with a formula and another scenario…Michelle Kellogg 53 views 8 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close -
Period is not showing correctly in Data ExchangeIn my integration, I have mapped period to period in 'Map Dimension' But when I export the data, it is not showing my periods Any help is greatly appreciatedJames Coles 2 views 1 comment 0 points Most recent by JAGADISWAR-Oracle Financial Consolidation and Close
-
Can we load data in FCCS to Parent currency(USD) via DM so that it does not translate by default forSummary: We have a requirement where we are pushing consolidated data from FCC at parent currency level and then the allocations are calculated in PCMCS and then the dat…Kasi1981 65 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Do we need to establish new countries when creating new entitiesSummary: When creating completely new entities for the FCC that involve new countries, is it necessary to establish a specific reporting currency for these entities in t…Sanjana Soni 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
ERROR: Drill Region was not created/updated. No valid data rows exist in TDATASEG for Process IDWe are calling same dataload rule from the pipeline in sequential way, We have enabled Drill region. In FCCS we get error while running Dataload rule , but with similar …SrikanthReddy-Oracle 91 views 4 comments 0 points Most recent by SrikanthReddy-Oracle Financial Consolidation and Close
-
Partial Export of data into FCCS with failure in DMHi, We are testing changing the source of some locations in DM in a test environment. They are failing on the export step due to 2 rows of data flagging an invalid inter…Alyssa Longo 21 views 4 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS - Error: Invalid Journal file format. Importing consolidation journals.Summary: We are trying to upload a consolidation journal into FCCS. We are getting an format error, which we havent had before. Content (please ensure you mask any confi…Pieter-Jan Vandendriessche 92 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to select entity alias in custom drill urlSummary: In FCCS, we have added a custom drill URL to drill into FDI report. When we hardcode the URL with a specific entity alias, it correctly lands on the desired pag…AishShirke 11 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
DataCopy with FCCS on-demand rulesSummary Is it possible to use DATACOPY in FCCS on-demand rulesContent Hi all, just have a question regarding the usage of Essbase DATACOPY from within FCCS on-demand rul…User_2025-02-03-23-55-06-250 90 views 3 comments 0 points Most recent by Sidd Mandal Financial Consolidation and Close -
support for exclusion in options->filters for an integrationWe have a very specific requirements for filter criteria for data export integration which is requiring us to hard code 100's of members in a filter. It would be great i…MKhade 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 41 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 82 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close