Data Integration
Discussion List
-
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 32 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 341 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 12 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 22 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 303 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 21 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 -
Process Monitor Report Customized as per Client Requirement from Data ManagementSummary: Process Monitor Report Customized as per Client Requirement from Data Management: Business Requirement : User have 2 categories Actual_JD and Actual_AM where so…
-
Planning data exchange power user with Administrator role cannot run integrationSummary: Content (please ensure you mask any confidential information): Hi all We have applied to the Power user the new Integration role of Administrator so we can run … -
Linking Source Documents in Cell text – Transferring and Using Document URLs from Source SystemsSummary: We’re currently exploring a scenario where, in addition to transferring numerical data from our source systems, we also transfer hyperlinks pointing to the unde…Bjoern Schumacher 11 views 1 comment 0 points Most recent by Bjoern Schumacher EPM Platform and Freeform
-
How to export data from TPROCESSLOG table data managementIm trying to create a process with sql qurey on maintenances tables (Like TPROCESSLOG, TPARTITION and others) to export data to a file . This is to get process details h…
-
How Does Data Integration Order Columns for Load?Summary: How does Data Integration order the columns for load? Content (please ensure you mask any confidential information): We are integrating some data from an on pre…