Data Integration
Discussion List
-
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 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…
-
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 790 views 33 comments 0 points Most recent by User_MBRQQ Financial Consolidation and Close
-
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…
-
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…
-
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 23 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 107 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…
-
FCCS Exchange Rate Load to Rates Cube – Post-Load RulesHello everyone, I have a question regarding the exchange rate integration process in FCCS. We are loading exchange rates into the Rates cube through a data exchange inte…Timestamp EPM Team 35 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Bulk delete folders in data exchange file browser or Data ManagementSummary: How to delete multiple empty folders at once in the file browser in Data Exchange? Content We have setup an openbatch pipeline which processes all files placed …Jeroen Goudvis 61 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
User Settings under Data ExchangeSummary: The Log Level under System Settings is currently set to "3". Now a user, set his Log Level to "5" under User Settings. We did re-run the data load rule to get a…Kenneth John Asper-Oracle 35 views 5 comments 0 points Most recent by Anand Thota Financial Consolidation and Close -
SDM Validation Unable to Retrieve FCCS Account Balance ValuesWe are currently facing an issue where, Supplemental Data Management validation process is unable to fetch account balance values from FCCS. Despite having the necessary…
-
Does Data Exchange Pipeline job copyToSFTP support privateKey and passphrase secure parametersWould like to use the Data Exchange Pipeline job copyToSFTP with a privateKey and passphrase. Built the application connection with and without the parameters along with…