Data Integration
Discussion List
-
Is it possible to use @UDA function in source filter in DLR - EPBCSI would like to use @UDA function in source filter of DLR? Is it possible? If yes, can you please provide the detail info. -
Load to FCCS_ClosingBalance_Input Replace mode creating reversal in first period for Expense AccountSummary: Expense account is set up under FCCS_Acct Receivable parent. When loading data for the first period of the new fiscal year, if the amount is missing, a reversal…KimJenkins 35 views 7 comments 0 points Most recent by Anand Thota Financial Consolidation and Close
-
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… -
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
-
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…
-
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 41 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
-
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 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 15 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
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…NK2025 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 53 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Reference Attribute values in Mapping ScriptSummary Reference Attribute values in Mapping ScriptContent Loading GL balances data using a file into FCCS. I want to flip the sign of Liability (L), Owner's Equity (O)… -
EPM agent is getting StuckSummary: EPM agent is getting stuck/Freeze Content (please ensure you mask any confidential information): Dear all, One year ago, we configured an EPM Agent and it was w…Ethien Eid 41 views 8 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close
-
How to copy rate using pipeline?Summary: Error while executing pipeline to copy rates from P12 to P13 Following steps were followed to copy the rate from P12 to P13 using Pipeline: Create a copy rate p…SAJ 102 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Split Adjustment Periods for BS and PL in Data Integration?Summary: Need to load different adjustment periods for BS and PL accounts from Oracle ERP Cloud GL to FCC using Data Integration, but limited by the single-source-applic…ShanqiDaFu-Oracle 21 views 1 comment 0 points Most recent by ShanqiDaFu-Oracle Financial Consolidation and Close
-
Job scheduling in FCCS for first 10 days in a close cycleSummary: We want to trigger the data load pipeline daily from the 1st to the 10th of each month. How can we achieve this using job scheduling in FCCS? We do not want to …AishShirke 21 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
View member FCCS_YTD_Input does not behave correctly when importing dataSummary: View member "FCCS_YTD_Input" does not behave correctly when importing data from Application\Overview\Actions\Import data. The YTD values in the file are stored …Arild Bjorsvik 31 views 3 comments 0 points Most recent by Arild Bjorsvik Financial Consolidation and Close
-
FCC: Restrict Security for Users in Data IntegrationSecurity Setup to restrict users in Data Integration is msissing. Our business case foresees users who need to trigger a data integration and access the Data Load Workbe…Andreas Otto 32 views 3 comments 0 points Most recent by Andreas Otto Financial Consolidation and Close -
Conditional Source Expression with Concatenation as outputSummary: We are migrating HFM Import scripts to cloud. I am planning to leverage Conditional expression to achieve similar functionality but it is not working. Basically…SrikanthReddy-Oracle 1 view 1 comment 0 points Most recent by Guixdx Financial Consolidation and Close
-
SAP S/4 Hana Connector to EPM applications (FCC/EPBCS)Summary: Does Cloud EPM (FCC/EPBCS) have SAP S/4 Hana Connector to pull data & drill through features? Content (please ensure you mask any confidential information): Ver…
-
How to export the Data Management/Data Exchange job details using EPMautomate?Summary: How to export the Data Management/Data Exchange job details using EPMautomate? Content (please ensure you mask any confidential information): Client wants to mo…Harshith J Rao 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
RestDataGrid error in integration Fusion - EPMSummary: This month, the system gave an error in the transfer of data from ERP to EPM. The error is "RestDataGrid_XXXXXXXX is invalid". I saw other people having the sam…Pieter-Jan Vandendriessche 11 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close
-
Why do the data load process steps vary?Summary: We've noticed that the five steps in the data load process vary. The last step sometimes says "consolidate data for consolidation application mmm-yy" and someti… -
FCC REST API GET Approval unit StatusSummary: Dear Community, We are currently setting up an Oracle EPM FCC instance and need the ability to read the Approval Unit Status for our planned Data Integration. O…Andreas Otto 72 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
What are the recommended steps to follow for closing business operations from one countryHi All, Our client based out from US and is planning to close the UK operations. Can someone please provide what are the recommended steps to follow to close out all the…