Data Integration
Discussion List
-
Power Users to access Process Details and Lock LocationsSummary: We have provisioned Power users with the Data Integration - Create role and enabled Location Security in our environment. As part of the location security setup…Saraiya Daisy Dhanesh 8 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Email Notifications via Pipeline to Multiple UsersSummary: What is the best approach in the Oracle FCCS pipeline for sending email notifications to multiple users when a distribution group email address is not available…Saraiya Daisy Dhanesh 20 views 2 comments 0 points Most recent by Bhavishya Edula Financial Consolidation and Close
-
DATAEXPORTCOLHEADER Please provide a valid dense dimension name to be used as the column headerFor the Version 26.06.73 (June 2026 EPM Monthly updates)that was released on Friday 06/05 - we are now getting error on FCCS to Planning data integration (integration is…Anne-Marie M 802 views 34 comments 0 points Most recent by Ashley Barrett Financial Consolidation and Close
-
epm data exchange integration, can we fetch start year and end year from fileSummary: In data exchange integration from file to EPBCS, need to fetch year period directly from file irrespective of what we select while running a DLR Say in the file…
-
Opening balances load approachWhat is the best practice approach for loading opening balances to a new FCCS application. I am planning to load local subsidiary currency balances to "Opening Balance A…S Kumar-Oracle 4 views 1 comment 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
Data load Rule for File Export FailsPrior to the June patch the following parameter worked in the export data load rule: inbox\AMCFCC_EXPORT\AMCFCC_EXPORT_ACTUAL.csv. This placed the file exported in the c…Russ 23 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Difference Fusion trial balance and GL BalancesSummary: We're designing an integration between FCC and Fusion. We're able to connect with Fusion following the Oracle EPM Cloud documentation. However, we're now face w…
-
Data Exchange: Extract Year and Period in single columnSummary: Data Exchange Integration: We are extracting data in a file in data exchange. This file has year and period in 2 different columns as we have 2 dimensions years…
-
Do EPBCS and FCCS support OAuth2 connections to ERPSummary: OAuth2 connections from Cloud EDM to ERP and now supported. https://docs.oracle.com/en/cloud/saas/enterprise-data-management-cloud/dmcaa/oauth2_authentication.h…
-
In EPBCS Data integration pipeline, unable to copy/move file from Outbox/logs folder to inbox folderSummary: In EPBCS data management pipeline, I am trying to copy/move log file from "outbox/logs/" folder to "inbox" folder. It is throwing an error that file not found. …
-
Usage of AIF_TARGET_APPL_MEMBERS in FCC CloudHello, We have a requirement to get member alias in data exports & currently we have used AIF_TARGET_APPL_MEMBERS to solve this problem in Non-Consolidated report. We ha… -
secondary audience for the EPM Cloud ServiceSummary: Getting 401 Unauthorized error when starting the Integration Agent after updating to 26.07 Content (please ensure you mask any confidential information): I foll…
-
Drill Through to Oracle ERP Cloud not appearing on the Action MenuSummary: I have recently enabled an actuals integration to create drill regions for data sourced from Oracle ERP Cloud. Based on Oracle documentation, not much has to be…
-
Configure Snowflake connection with EPM Integration AgentI am trying to connect to Snowflake via the EPM integration agent. I have followed the documented steps. I am using a File Credential Store. I am now receiving this erro…
-
How to Configure Integration Agent and Data Exchange to Select Queries at the Integration LevelHi. I have installed and configured the EPM Integration Agent so that it can run a SQL query that has been defined in the application. I now would like to modify the app…Peter Doyle - Equator EPM 22 views 2 comments 0 points Most recent by Peter Doyle - Equator EPM EPM Platform and Freeform
-
Unable to run integration between TAX - Source with Planning - Target - Period mapping failureSummary: Content (please ensure you mask any confidential information): Hi TAX team We are doing a live integration between 2 EPm cloud TAX as source and Planning cloud … -
Not able to download "Artifact Snapshot" in parallel for multiple EPM Pods after EPMAutomate UpgradeSummary: After updating EPM Automate to version 26.06.49 where Oracle has changed behaviour for "downloadFile" command. Since the files are written to single folder, we …Prateek Mohan 24 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
SubVar for Data Export IntegrationSummary: SubVar for Data Export Integration to use with SubVars Content (please ensure you mask any confidential information): We have Data Integration Quick Mode to ext… -
Data Exchange Mapping member mappingSummary: EPBCS Data Exchange Mapping, if member present in Employee dimension then it should be mapped to * to * else default member, without explicitly mapping employee…
-
DI - Clear Data Scope for promoted Approval GroupSummary: I am looking for clarification on the scope of data cleared from the FCCS application when running a Data Integration in Export Mode Replace. In particular, I w…Andreas Otto 101 views 12 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close -
oracle epm pipeline integration with smart split job, is there an option to bypass refresh members?Summary: oracle epm pipeline integration with smart split job, is there an option to bypass refresh members? Content (please ensure you mask any confidential information…
-
Cannot perform cube view operation. Essbase Error(1270001): Memory allocation failedSummary: While executing DLR from PBCS reporting cube to PCm, facing error Error: Cannot perform cube view operation. Essbase Error(1270001): Memory allocation failed Co…
-
Data masking for required data combinationsWe need to have access control on data so that no one should be able to view the data of other users. For e.g. Employee compensation information. Business should have co…