Data Integration
Discussion List
-
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… -
EPM Integration Agent: Connection Timed outHi Everyone, We are currently facing an issue at the client side with the EPM integration Agent. When attempting to connect to the cloud we are getting the "connection t… -
Is there any EPMautomate command to update period mappings in FCCS?Summary: Clients wants to update the period key under period mapping for one of the target application on everyday basis. They also want it to be automate. How can we do…Harshith J Rao 32 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Is there a way to create the reports folder under the outbox folder in the Data management EPM FCCS?I have mistakenly deleted the reports folder in the outbox folder in the Oracle EPM FCCS data management. I was trying to delete the reports generated in the reports fol…RatnaMaruboina 41 views 6 comments 0 points Most recent by Vinay Gupta-Oracle Financial Consolidation and Close