Data Integration
Discussion List
-
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 52 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 683 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 44 views 4 comments 1 point Most recent by Ritesch Malhoe Financial Consolidation and Close -
Why is there a difference loading data with service administrator and user loads to FCCS app?Currently we are loading data at our client through data exchange. When we loaded our dec-23 data we found that the numbers in PL and BS were not the same when we loaded…Ritesch Malhoe 41 views 4 comments 0 points Most recent by Erringc Financial Consolidation and Close -
Pushing data from FCCS to client's on-premise HFM applicationSummary: The requirement is to push data from FCCS to client's on-prem HFM system. Requesting your recommendation/best practices regarding whether this integration (Data…Giridhar Kumar-280189 52 views 3 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close -
FCCS pipeline to run PCMCS rule setSummary: Hi Mike Casey, We are trying to find out the whether the FCCS pipeline can call PCMCS rule sets We have created connection in FCCS (for PCMCS) Created a pipelin…Sreekumar Hariharan 112 views 13 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Missing File When Using an Export Dimension by Name (EDMCS) Job Type in PipelineSummary: I am testing export Dimension by Name (EDMCS) Job Type in Pipeline. I created EDM connection: https://edmcs-test-domain.epm.****.oraclecloud.com/epm Parameter: … -
How to use Substitution Variables in Data Management-EPCMCSSummary: Hi All, Is this possible to use Substitution Variables in data load mapping?. Let say we already run 12 month data for working version and now we want to copy t… -
Customizing default integration with DFF (Flexfields) between EPM and PPMSummary: Is it possible to adjust "Import Project Actuals" (EPM side) to pick up 2 flexfields from PPM? Customer uses 2 flexfields into PPM (Oracle Project Management) t…HMMgl-Oracle 53 views 2 comments 1 point Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
FCCS Drill Through from PODSummary: I'm working with my Cyber security team and I'm building a case for a Web Server the architected defined to allow drill through to Oracle (OCI) PS tables via th…Jeff Gilliam 31 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close