Data Integration
Discussion List
-
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 -
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…
-
Creating Integration in EPM to extract data to FDISummary: We are trying to following this Doc: https://docs.oracle.com/en-us/iaas/analytics-for-applications/doc/managing-data-connections.html#FAWAG-GUID-A3EDE603-BF95-4…Sera Hager 41 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
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 62 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…
-
How to update time zone on email sent by no.reply@epm.oraclecloud.comwe have built pipelines which sends email on completion, but the emails it sends is showing different time(GMT) though we changed user preference for service account tha…