Data Integration
Discussion List
-
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 52 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 31 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
-
How do you obtain last modified date for a data integration within data exchange within Freeform?We only see the last executed date within the data exchange screen and we our audit report does not pickup any modifications we made to the data integration. Looking to …C Vincent 21 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Set Administration Mode in PipelineSummary: Set Administration Mode in a Pipeline fails Content (please ensure you mask any confidential information): Has anyone been able to set up an Administration Mode… -
Historical Rate disappears after data reload from DM using the replace modeSummary Historical Rate disappears after data reload from DM using the replace modeContent Hi all We are experiencing a strange behaviour from FCCS to which we would lik…NKW 49 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS Dummy dataSummary: Request for FCCS Dummy data for testing purposes. Content (please ensure you mask any confidential information): I do require sample multi-periods trial balance…Sarwar 51 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Sign Flip based on Account attributeSummary: Hi, I'm writing a SQL map in Accounts to flip the sign of data being imported based on value of an account attribute. If the value for the attribute says 'Flip'…Neha_R 54 views 7 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform