Data Integration
Discussion List
-
Can we load data if period and year are in rows and columns"This is the file format, and I want to load the data into the respective year and period. Could anyone please assist me with this?" -
Java Version for EPM Agent and DriversSummary: I am trying to find out how the EPM Agent assigns the JAVA_HOME variable and if it will require a higher version of Java after the TLS 1.3 update, as well as wh…
-
Issue with Data Management MigrationSummary: I am receiving the below error when trying to migrate an Application from Test to Production Content (please ensure you mask any confidential information): I am…Matthew Gregory-137392 65 views 9 comments 0 points Most recent by Ramaguru B EPM Platform and Freeform
-
Substitution variable for period reference is not working in fccs pipelineHas anyone used substitution variable for period reference in fccs pipeline? I am trying to do it but it fails. My variable is &Period_Year with Feb-24 as value. When I …
-
Member formula performance after DSO MigrationHi everyone! I am looking for some advice. We have several member formulas on the Account dimension that we used prior to the DSO migration that used to run less than a …
-
FCC to Planning Data ExchangeWe are trying to transfer journals from FCC to Planning using an integration. It is all working except for the load to Planning where we see the following error in the l… -
HCM Integration with Oracle EPCMCSWe have been trying to load Headcount data to EPCMCS by Integrating with Oracle HCM. There is no documentation available to load data to EPCMCS from HCM. I would like to…P Avinash 21 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Profitability and Cost Management
-
DATA COPY ISSUE SummaryRequirement: As per the client requirement we need to copy from aggregated parent members to base level stat members for 4 dimension(Account, Profit Center, Functional A…Jayshree Maloo 31 views 8 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
Drill Through between EPM Cloud: Planning to FCCS using Smartview Drill through optionSummary: Content (please ensure you mask any confidential information): Hi all We have an integration set up EPM Cloud and ERP and that works fine, but now we want to us… -
Add "Is Like" Mappings to Data Maps for Cross Application DataSummary: We are trying to simplify our export process from our Planning application to our Essbase application. Currently, we use data integrations to create export file…
-
Change from decimal separator to comma from dot in FCCSSummary: Currently FCCS system is designed with default decimal separator as dot(.), However we would like to update it to comma(,) as the decimal separator. In simple w…Venky55 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we setup different email IDs to be sent in case of pipeline failure and Pipeline success in FCCSCurrently, we are not able to setup different emails for success and failure. SEND_EMAIL variable gives the following options- On failure, On Success, No, Always, and ba…Jayshree Maloo 31 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Exchange Source Expression - How to Concat + Transform the same column?Hello, Currently, we have a client who is migrating from HFM to FCC, and they used to rely on FDMEE scripts to transform data during the import process Now, in Data Exch…Guixdx 21 views 3 comments 0 points Most recent by Mike Casey-Oracle Financial Consolidation and Close
-
Data Exchange: Check member in target application before mappingSummary: Data Exchange: Check if the member exists in target application before mapping. Content (please ensure you mask any confidential information): I'm looking for a…
-
Oracle-provided Google Cloud adapter available to facilitate direct interaction with GCPIs there an Oracle-provided Google Cloud adapter available to facilitate direct interaction with GCP services? Alternatively, is it necessary to purchase Oracle Integrat…SuneelKanthala 21 views 1 comment 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Using API Key Instead of Basic Auth in FCC Connection to Call OIC EndpointProblem Summary: We are triggering an Oracle Integration Cloud (OIC) REST endpoint from FCC using a Groovy script and a connection configured via the "Other Web Service …Vijay_Babu 51 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Mapping Audit ReportIn FDM we used to have custom reports for audit mappings. How do we create custom reports in FCCS? The standard mapping audit report in data management is formatted in a…Brian Duncan 21 views 2 comments 0 points Most recent by Brian Duncan Financial Consolidation and Close
-
Data Exchange SecuritySummary: Need the ability to set up location security for a user to be able to run certain integrations, but then only view others. Content (please ensure you mask any c…Matthew Gregory-137392 21 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Can we use OTBI Reports to integrate the ERP application with EPM?Summary: Can we use OTBI Reports to integrate the ERP application with EPM instead of BI publisher to load the data from ERP to EPM Content (please ensure you mask any c…Santiago Belaus 51 views 5 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
Data Integration PipelineSummary: Hello all, I am creating a pipeline in data exchange. I want to send emails at the end of execution of pipeline to multiple users using "Send to" variable. I ha…Mehandi Ali Nandoliya 32 views 5 comments 0 points Most recent by TarunG-Oracle EPM Platform and Freeform
-
audit log changes property of accountSummary: We want to track the changes on the property for the account members in the audit logs. Content (please ensure you mask any confidential information): When upda…Silvia Vilchis 71 views 14 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to export Period and Years dimension values from PBCS to ADB (EPM Integration Agent)Summary: Hi, I'm trying to create an integration in order to write back data from PBCS to ADB using the following procedure: https://docs.oracle.com/en/cloud/saas/enterp…
-
Configure EPMAgent to work with HTTPSSummary: Configure EPMAgent to work with HTTPS Content (please ensure you mask any confidential information): Currently the EPMAgent in the Cluster is connecting to the …Shantan Kumar-Oracle 31 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform