Data Integration
Discussion List
-
Default Movements Enabled - FCCS_Retained Earnings child accounts creating out of balanceSummary: Balance Sheet out of balance is system generated by children input accounts under FCCS_Retained Earnings in new year. The Default Movements rule is enabled and …TAMMY_L 81 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Multi Period Data LoadingNeed to know whether multi period (multi column) data loading (12 separate columns for each month) available in FCCS when loading flat files.
-
Is there a way to load adjustments from Oracle ERP to FCCS in different data source members of FCCS?Is there a way to load Period 13, Period 14 and Period 15 adjustments from Oracle ERP to FCCS in different data source members of FCCS? Basically I am looking to load p1…Ashif 31 views 4 comments 0 points Most recent by Ravi Akula Thimmaiah Financial Consolidation and Close
-
Registering application and configuring connection for ARCS Transaction Matching's GL Data SourceWhen configuring ARCS Transaction Matching for AR to GL and AP to GL which data source should we use for the GL? I can see that there are available data sources for AR a…Jmlopez 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Drill thru to data management in FreeForm appSummary: I have a FreeForm app where during configuration Scenario dimension wasn't enabled. I recently setup a drill region for direct drill thru to the staging area of… -
REST API to populate EPM Application with Forecast DataSummary: REST API to populate EPM Application with Forecast Data Content (please ensure you mask any confidential information): We are integrating PMIS (3rd party system…
-
Select Account from Target Dimension in Data MappingWe have to configure data load mapping in such a way where we need to map source to target based on condition that source member should exist in target otherwise all sou…
-
Failure in executing integration with "OWP_Incremental Process Data and Synchronize Definition" ruleSummary: I have executed an incremental file-based integration but whenever I am executing this integration by adding the rule in business rule section, it is showing er…
-
In Data Integration what is the difference between Target Period Year and Target Year?Summary: In Data Management/Data Integration, what is the difference between Target Period Year and Target Year in Period Mappings? Content (please ensure you mask any c…
-
Is new incremental file application mandatory if file has new columnsSummary: I have created an executed an incremental file adapatar based integration, now suppose I have new columns added in my file, do I have to create a new incrementa…
-
How to map missing values in integration in EPBCSSummary: I want to execute an integration wherein if the "Union" column is "APS" or "Unaffiliated" for example, then the "Salary Grade" field for it will be blank. I was…Suravi 42 views 10 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
Issue with Period Mapping in Data Management - Source-Period Column Showing Amount Instead of PeriodHello All, We are integrating data between two PBCS PODs. Our goal is to map data from the Jan-Dec periods to 'No_Month' in the target POD. To accommodate this, we have …
-
Data Load Rule "Date format for date data" ignored for User Preferences date formatSummary: The "Date format for date data" setting in a Data Management integration is being ignored and the user running the integration user preference date setting take…
-
How can I use one integration across more than one scenario?Summary: Suppose I have created one integration for actual category to load data into my reporting cube from financials, but I want the same integration to be used acros…Suravi 51 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Automated Task for Pipeline execution in FCCS NOT WORKINGHello, I am trying to schedule pipeline automated tasks using task manager in order to schedule the integrations using holiday rules. Even after the start data and start…Ashif 41 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we increase the precision in data management data load file.Summary: We are running to load exchange rates from data management, however we came to a problem where we are trying to load 15 decimal, but it is loading only up to 6 …
-
Executing IPM Insights in EPCM - EPMAutomate/Groovy/RESTSummary: Automation and scheduling IPM Insights in EPCM using either EPM Automate, Groovy or REST API Content (please ensure you mask any confidential information): I am…Andy Das 91 views 7 comments 1 point Most recent by Don Bean-Oracle Profitability and Cost Management -
IGNORE Mappings in SQLSummary Error exporting to FCCS when mapping to IGNORE utilizing SQL scriptingContent Was hoping someone could help with this. I setup Data Load Mapping using SQL script…user3948450 510 views 6 comments 0 points Most recent by Jennifer Lin Financial Consolidation and Close
-
Data Export to File from EPBCS pulls in Amount for Source Period in Data ExchangeSummary: Hi All, I am trying to do a data export to file from EPBCS in data exchange. I have the export working in FCCS correctly for actual data and need to create the …Karla McMillan IBM 13 views 2 comments 0 points Most recent by Odin Mjølsnes EPM Platform and Freeform