Data Integration
Discussion List
-
Create drill regionSummary: Hello, now that we've migrated our EPM environment to Gen 2, I am unable to find the option to enable "Create Drill Region", as this is no longer available from… -
How FCCS calculates Periodic data if we are loading YTD values?How FCCS calculates Periodic data if we are loading YTD values from ERP? Is there any calculations we need to consider ensuring that the data rolls over correctly for ea…Jmlopez 81 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
What options are there for exporting calculated data (ie:parents and member formulas) from ASO cube?Summary: We have a fairly large ASO database, with one of our dimensions containing 193k members. Many of these members are shared members for alternate hierarchies with…Chad Alexander 81 views 10 comments 0 points Most recent by Chad Alexander EPM Platform and Freeform
-
Data Management - Essbase Error(1260046) introduced on non-Gen1 ScenariosSummary: An issue appears to have been introduced into EPBCS last night which caused a lot of our Data Management Rules to fail (these have previously been running with …Alan Davey 41 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Open Batch - Processed file does not appear anymore in the process id's post completionSummary: We are using Open batch to execute certain data loads. Post the data load completion, the files (that are uploaded in open batch folder for data loads) were app…NarayananS 11 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
Error Export data to budgetary Control FusionSummary: Hi, I have an error issue when exporting data from PBCS to Budgetary Control. Could you please help me to solved this issue? I have attached the full log as wel…Ruosidah 41 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Email setup and subject setup for email notificationsSummary:We have a requirement where we need to setup an email inbox as a recipient of all emails from the ARCS cloud. We would also need help on setting the subject for …
-
Data Exchange Integration - Map one source coulumn to multipleSummary: I am loading data from HCM to Workforce: AS seen below, I want to map Assignment Start Date to OWP_Start Date (employee Start Date), OWP Start Month (Employee S…Ravinder Singh-63390 11 views 5 comments 0 points Most recent by Stu G-Oracle EPM Platform and Freeform
-
Data Management recalculate showing in POVWe are noticing a recalculate icon in Data Management production and test environments for Oct only. We have reloaded some prior periods and do not get the recalculate d…
-
Direct Data push from EPCM to GL creates records in GL for debit and creditSummary: Direct Data push from EPCM to GL creates records in GL for debit and credit. On what basis are these records created in GL? Need Logic was differentiate debit a…Subhojyoti Chakraborty 11 views 1 comment 0 points Most recent by SureshM-Oracle EPM Platform and Freeform
-
How to set up Explicit period mappings vs Default?Summary: Setting up alternate period mapping for specific DLR Content (please ensure you mask any confidential information): I have a requirement to load prior period re…
-
Custom Date column addition in EPCM to GL write back interfaceIs it possible to add a custom date column which represents last date of accounting period in the JDBI extracted .csv file? Another requirement is to get the new date co…Aashish Kumar-248418 41 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Profitability and Cost Management
-
Groovy script:restricting the usage of data load for common dataruleSummary: Looking for solution via groovy in FCCS : if user one has trigger the remote dataload pipline from FCCS for PCMCS then the process should be locked for rest of …Sreekumar Hariharan 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Open batch Archive filesSummary: Files Placed in Open Batch files are processed but does not land into Archive folders after processing. Content (required): Files Placed in Open Batch files are…
-
Oracle EPBCS Integration Option with Azure DatabricksSummary: General questions on available functionality between Oracle EPBCS Data Integration and Azure databricks Content (required): Specific questions regarding the fun…
-
Is it possible to build dimension named "Highest Education Degree" in WFP reporting cubeSummary: Is it possible to build dimension named "Highest Education Degree" in Workforce Planning reporting cube (for demographics) via Data Exchange. I am thinking of p…Ravinder Singh-63390 21 views 7 comments 0 points Most recent by Stu G-Oracle EPM Platform and Freeform
-
Data Exchange - Data Export Planning ErrorSummary: Client wants a data export from a custom RevCOGS cube. They want account and period in the rows, and the DATAEXPORT business rule command requires a dense dimen…Nicholas Ho 101 views 15 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Data Load rule vs Quick Mode Data RuleSummary: Data Load rule vs Quick Mode Data Rule not behaving same in REST API executions Content (please ensure you mask any confidential information): We are using Quic…
-
Disable check step in Data managementSummary: We are looking for a way to disable the check step in Data Management. Content (please ensure you mask any confidential information): In the Data Management Wor…Alyssa Longo 21 views 3 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Financial Consolidation and Close
-
Groovy CreateFileWriter bug/defect? File generated not located in Outbox.Summary: The Groovy documentation for CreateFileWriter method (https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/groov/oracle/epm/api/script…Chad Alexander 51 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
TRCS - Import Oracle ERP applicationsSummary: We want to create a connection between TRCS and Oracle ERP Cloud. We successfuly created the connection. However, when doing the import of the applications, som…Julie Belurier 31 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Tax Reporting (Direct Tax)
-
Extracting YTD data from FCCS using Data ManagementSummary The attached document explains how to extract YTD data from FCCS using Data ManagementContent The current Essbase implementation for FCCS includes the view dimen…Mike Casey-Oracle 684 views 12 comments 3 points Most recent by Manjunath M P Financial Consolidation and Close -
Is there a way to extract manual consolidation journal entries using a data load rule?Hi, Our business clients currently post some consolidation journal entries at a parent entity member level and I was wondering if there was a way to extract those entrie…Sarah Paroya 41 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can we integrate EPBCS with Accounts Payable in a way that drill through would work from EPM to APSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Snapshot/Clone incomplete, does not include data management workbenchContent workbench content is not included as part of clone/snapshot migration this is an issue when we need to clone an FCCS LIVE environment to troubleshoot the integra…User_2025-03-07-20-48-43-319 43 views 4 comments 1 point Most recent by Ritesch Malhoe Financial Consolidation and Close