Data Integration
Discussion List
-
Connection between FCCS and IBM Planning Analytics version 2.09.02Summary: We are now looking to see if FCCS can send data feeds into IBM Planning Analytics version 2.09.02 in real time. One of our branch is using this system to do rep…Hugo Bergeron 91 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
How to extract YTD data from Nonextended Dimentional FCCS applicationSummary: Hi Experts, We are trying extract YTD data from FCCS application to TRCS application via Data management. Source FCCS application is Non-Extended dimensional ap…KC-2109 121 views 21 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
FCCS - Movement dimension member mapping for Accounts in Data Management loadsHi Team, We are implementing new FCC application with ERP cloud as source. We set it up the Accounts dimension and assigned Movement dimension member as like below. In F…Ankamma 331 views 9 comments 0 points Most recent by GaneshN-Support-Oracle EPM Platform and Freeform
-
Quick modes export data to file fails when no recordshi Since today morning (23.12), quick mode Export data to file integrations FAILS while running the integration. So far it used to be run successfully with just the HEAD…
-
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …Sarah Paroya 31 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
DLR Export for Entity to only include direct entity and not [parent].[child] formatHi all, I've made a data load rule that pulls a bunch of data from FCCS into a csv file which gets put into another application. When pulling the entity dimension data, …Sarah Paroya 1 view 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPM - Data Integration - Is it possible to use a like operator in the filter condition?I have an integration between Oracle EPM (ARCS) and Oracle ERP Cloud. For one of the dimensions (the 'XX_AFF_00_S04" dimension), instead of retrieving all level 0 values…
-
Error: java.sql.SQLException: Protocol violation on EPM Integration agentSummary: https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/diepm/epm_agent_epm_zip_102x805297a3.html We used above doc to configured EPM int… -
How can we schedule pipeline?Summary: How can we schedule pipeline? Content (required): How can we schedule pipeline in Oracle FCCS? Version (include the version you are using, if applicable): 23.08Shelbi 181 views 17 comments 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Management in PBCSSummary: Content (please ensure you mask any confidential information): Looking for information on how/when files are deleted from the inbox in Data Management. I have s… -
data load by weeksSummary: I have actual data file which contains week level data and my application is a custom application where month is lowest granularity. I have created Weeks as a s…Ankita Roy-Oracle 31 views 1 comment 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform
-
FCCS Load failuresSummary: Hi We are seeing data load in to FCCS fails. Below is the error message. Can you please help us as this issue is in production? Error Message: HTTP POST on reso…Divya_Masoodi 81 views 13 comments 0 points Most recent by Divya_Masoodi Financial Consolidation and Close
-
DATAEXPORT is missing implied sharesSummary: We are using DATAEXPORT in an EPM Cloud Planning application for bulk data exports. When Accounts dimension is not specified in the containing FIX, implied shar…
-
Multi Period & Multi Year Integration-RowSummary: Hi All, In My flat file Year and Period are exist in ROW and there are multiple period and multiple year existing in the same file and I want to load the file i…Avtar 51 views 7 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Rename Snapshot - GroovySummary: Trying to Rename Snapshot using a Groovy BR , The URL for EPM as a connection for mandates '/HyperionPlanning' and Other web service provider does not mandate t…NarayananS 41 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Entity should not have intercompany with itself. How to restrict data load for these intersectionSummary: We wanted to restrict data entry to the intersections - Entity and intercompany itself. Content (please ensure you mask any confidential information): Version (…Kumara Surendra 11 views 3 comments 0 points Most recent by Ajay Kumaran-Oracle Financial Consolidation and Close
-
Dry Run on EPBCS applicationSummary: Dry Run on EPBCS application Content (please ensure you mask any confidential information): Hi Oracle, We tried running dry run in EPBCS and could not find opti…Ramsha Ansari 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to put validation to make sure that intercompany account is always tagged with ICP EntitySummary: We wanted to make sure that we always have Intercompany accounts being tagged with ICP entity so that the data in the Intercompany account will be eliminated pr…Kumara Surendra 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Multi Period & Multi Year Integration-RowSummary: Hi All, In My flat file Year and Period are exist in ROW and there are multiple period and multiple year existing in the same file and I want to load the file i…Avtar 21 views 1 comment 0 points Most recent by Gebril Abdellatif -Oracle Profitability and Cost Management
-
Set Global POV in System Settings screenIn the new System Settings screen in Data Exchange I set Global POV to 'Yes' and set a value in Default POV Period. But it doesn't seem to apply the setting. My work aro…
-
Can I execute a data map process through groovy using a diffent IDSummary: User need to run a data map but we cannot give them admin access Content (please ensure you mask any confidential information): We have a data map that is set u…
-
TRCS Hybrid model impacting DM Integrations which use Dynamic Calc Members on the Account DimensionSummary: After converting TRCS to the Hybrid model we are unable to use Dynamically Calculated Members from the Account Dimension in Data Management Integrations. Prior …Ivor Davies 41 views 1 comment 0 points Most recent by GaneshN-Support-Oracle Tax Reporting (Direct Tax)
-
Quick Mode - Accumulate Works!Summary: When running the Quick Mode load, only the Replace export mode is supported as per guided document but am able to do accumulate (EPM to EPM same app) Content (r…NarayananS 121 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
YTD PL Account can't be filtered when integrating from FCCS to PBCSSummary: I did integration from FCCS instance to PBCS instance. I already filter the dimension that I need (YTD data for BS and PL account). Unfortunately, the result is…
-
Write back to fusion ERP GL from EPCMSummary: Errored on the last stage of Importing Journal to GL Interface Table Content (required): Following is the error on the GL side. ORA-06502: PL/SQL: numeric or va… -
FCCS | Data Exchange - Export Data ErrorFCCS | Data Exchange - Export Data Error In Data Exchange > Workbench > Actions > Export Data: when tryinng to export mode online, the process ends with the error "Expor…Timestamp EPM Team 112 views 7 comments 0 points Most recent by Timestamp EPM Team Financial Consolidation and Close
-
FCCS Data Management job fails with tunnelling error messageSummary: We have jobs being run overnight with EPMAutomate used to extract data from our Oracle Fusion ERP and load into FCCS and EPBCS within 5 minutes of each the one …Jeremy Stubbs 31 views 4 comments 0 points Most recent by Jeremy Stubbs Financial Consolidation and Close -
EPM Integration Agent - Windows Services ErrorSummary: I have setup the EPM Integration Agent on our remote desktop and it works when I run it manually and can retrieve data from Snowflake just fine. However, trying…Erik_Olson 132 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
HCM to Strategic workforce planning integrationWe have exported the extracts from EPM instance and imported to HCM and able to configure integration. but when we run the integration we are getting errors. looking for…
-
Unable to extract data from FCCS with 4 decimal pointsSummary: We are trying to export data from FCCS to flat file using data target application for particular POV and we have specified data precision and data number of dec…ShubhamV 51 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close