Data Integration
Discussion List
-
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…user3948450 511 views 6 comments 0 points Most recent by Jennifer Lin Financial Consolidation and Close -
Data Export to File from EPBCS pulls in Amount for Source Period in Data ExchangeSummary: Hi All, I am trying to do a data export to file from EPBCS in data exchange. I have the export working in FCCS correctly for actual data and need to create the …Karla McMillan IBM 11 views 2 comments 0 points Most recent by Odin Mjølsnes EPM Platform and Freeform
-
Direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS is failingI am trying to create a direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS. Extract and import steps are getting succeeded. Getting warning…
-
Invalid Credentials Error - Data Exchange (non-blocking)Summary: Since last update (25.07) we regurlary get an error in data exchange regarding credentials. Eventhough the error is there, the integrations run perfectly. I was…Pieter-Jan Vandendriessche 11 views 3 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Data Exchange how to load one cell to multiple cells in FCC ?Summary: In a data load file I have movements that needs to be loaded to both the FCCS_ClosingBalance_Input member and a specific movement member. How can I load to two … -
DELETE sql statement for on-prem databaseSummary: Has anybody found a way to run a DELETE sql statement before exporting data to an on-prem database using Data Integration? In Applications, there is field that … -
PTD data from Fusion into PCMCS in YTD by Data ManagementSummary Loading of Periodic data from Fusion into PCMCS in YTD by Data ManagementContent Hi, In order to perform monthly costing cycle, I want to load periodic data from…Khushbu Premlani 44 views 8 comments 0 points Most recent by NarayananS Profitability and Cost Management -
When testing strong ciphers with EPMAgent, 401 Unauthorized receivedSummary: We are in the process of testing our strong cipher set ups per the Oracle documentation here: How to Test with the Latest TLS Ciphers The documentation indicate…
-
Post the allocated result to next period to Oracle GLSummary: Hello everyone! It is about EPCM. But it is mainly about Data Integration/Data Exchange in Oracle EPM application. We have a situation: Data pulled from Oracle …GaryYip-Asc 31 views 4 comments 0 points Most recent by GaryYip-Asc Profitability and Cost Management
-
How can a POV or Period be locked in EPCM to block data update of any kind (Submit Data or DM)Summary: Publishing a POV (from Calcualtion Control) seems to only block any calculations being run, but data upload is still being allowed. We need to lock a POV once i…Itali Madhusmita 11 views 6 comments 0 points Most recent by Itali Madhusmita Profitability and Cost Management
-
FCC multi cubeSummary: FCC multi cube was trailed at KScope 24 as 'coming soon' but we can't see it on the road map now - what is the current status? Content (please ensure you mask a…Ben Walwyn 331 views 10 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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
-
The substitution variable DataLoadConsolMember is not working as expected.We have two DLRs: one for overrides and one for trial balance (TB) load from ERP. First, we load the overrides data, which successfully appears in FCCS. However, when we…Avani Makwana 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Issue while migrating file based data source application from one environment to another.Summary: Hello, I have registered a file as data source and have created a file based integration to import data into EPM application which is working as expected in the…Neha_R 21 views 5 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
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 41 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 293 views 10 comments 2 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
Budgetary control integration from EPM to ERP unexpected behaviorHello team, We are running into some difficulties while configuring Budgetary Control integration between EPM and ERP. As far as I understand, to be able to see the Budg…
-
EPMAT-1:EPMFDM-ERROR: 'periodName' parameter format is invalid.Summary: Content (please ensure you mask any confidential information): Hi all, As specified in the Oracle Documentation,I'm trying to use the periodName parameter in EP…
-
Scheduling job for cross application data mapsHi, With the recent support for cross data maps push to remote application, I am not able to see such data pushes under Data Maps in Jobs scheduler. Is there any securit…Loganathan Nachimuthu 41 views 4 comments 0 points Most recent by Loganathan Nachimuthu EPM Platform and Freeform
-
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 51 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 31 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle 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…
-
DM NZP: How to keep zero values and ignore blank valuesHello, During data integration, if I define NZP in import format, as expected it disabled zero suppression, meaning all zero values are imported from source. This also f…Vijay Mahantesh-Oracle 22 views 4 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform -
Data File rename in EPMDear Experts, We are moving file from SFTP to EPM application using REST API. As a next step we want to rename those files once it got moved to EPM overview. Is there an… -
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
-
Rest API queriesSummary: 1.Oracle recommendation on the most efficient way to export files via Rest API. We are planning to use Pipeline to export data (job setup to export data) - then…Muruges89 21 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 11 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Data Exchange Quick Mode Import Failing due to unknow membersHi, I am loading data using Quick Mode, but the job is failing due to unknown members. Since there are a large number of unknowns (around 5,000 records), it's not feasib…MohanJ 11 views 4 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform