Data Integration
Discussion List
-
EPM data Integration - How to map the source members to Alias instead of member names?Summary: Is there any way we can map the source members to alias (target) instead of member names in data integration ? -
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 55 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error in initializeFsGLCloudSource even with user Role GL_RUN_TRIAL_BALANCE_REPORT_PRIV assignedHi Expert's Summary: Error during GL data import in FCCS – “Unable to find text data file for essRequestId” Content (please ensure you mask any confidential information)…Michel Miotto Barbosa 103 views 3 comments 0 points Most recent by rahul shinde Financial Consolidation and Close -
Is it possible to use Members from Dimension (dynamically) on Pipeline Variable?Summary: Hi, is it possible to use members from a dimension in pipeline variables in the same way as it prompts in the rules??, or is it only possible by adding them man…
-
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 63 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
What is the best recommended way to extract SHARED data from FCCS?Summary: What is the best recommended way to extract SHARED data from FCCS? is it Data Exchange? Code Snippet (add any code snippets that support your topic, if applicab…NarayananS 24 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
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 45 views 4 comments 0 points Most recent by Peter Doyle - Equator EPM EPM Platform and Freeform
-
2Pipeline Parent and Child Jobs MonitoringSummary: We want to monitor all the Parent/Child pipelines jobs for the status as part of automation, The REST response provides the GET of the pipeline but not all the …
-
Exporting data such as smart list, date, text using data Data IntegrationSummary: Hello Team, I am trying to export data set with different types such as numeric, smartlist, and date in file using Data Export to File in Data Integration. Howe… -
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…
-
document data integrationSummary: Hi, can anyone recommend a tool - assuming there is nothing built in - that will facilitate creating documentation from an export of PCM's Data Integrations. Co…Erisia 12 views 1 comment 0 points Most recent by Mike Casey-Oracle Profitability and Cost Management -
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…
-
data load rule with PipelineSummary: file based FCCS data load rule in Pipeline fails saying "Error opening Data file" Content (please ensure you mask any confidential information): File based FCCS…Raj N 12 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EPM to Oracle cloud writeback for actual dataSummary: Hello, I am trying to load back some adjustment data from Oracle FCCS to Oracle Cloud GL using Data Integration. I am successfully able to send data for a singl…Anindya N-Oracle 16 views 0 comments 0 points Started by Anindya N-Oracle 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 843 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 14 views 1 comment 0 points Most recent by Lakshmi V-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…
-
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… -
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…