Data Integration
Discussion List
-
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 679 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
-
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 51 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 111 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 52 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
-
How to load parent member (store data type) with dynamic cal children account?Summary: I did integration from FCCS to PBCS but always failed to load parent member (store data type) with dynamic cal children account. FYI In FCCS the parent account …
-
Data Management Loading Differently for Power Users vs. AdminSummary: Data seems like it is loading differently for Power User's vs. and Admin into FCCS. Content (required): We have recently loaded data into FCCS using a Power Use…Matthew Gregory-137392 141 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Load Oracle Fusion GL to FCCS - P13 DataSummary: Content (please ensure you mask any confidential information): I'm trying to load P13 Trial balance data from Fusion GL to FCCS as normal using data integration…
-
Data Management : Unknown Member [Company] used in querySummary: We are in Data Management and we are importing data from ERP Cloud to FCCS. Import does not run if i set a single source company on Data Load Rule Filter. Conte…Stefano Francese 81 views 2 comments 0 points Most recent by Stefano Francese Financial Consolidation and Close -
FDMEE artifact migration issues since 24.02 patchSummary: Since the 24.02 patch we are unable to import snapshots without errors for the FDMEE artifacts. The process we took was: Overview -> Remove application Import f… -
Importing data records surrounded by quoteHello. I'm trying to import data into FCC and the records, while comma delimited, are surrounded by quotes. They look like this: "Account,CostCenter,Amount" So the whole…ericerikson 21 views 4 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
GL to EPCM inbound integration failing with Replace modeSummary: GL to EPCM inbound integration failing with Replace mode for Entity dimension members only. Error message says failing to clear data for Entity members which ar…Bala Vishwa Gautam 51 views 9 comments 0 points Most recent by Pratap Ball EPM Platform and Freeform
-
Unable to get "Parent Currency" expression in Data Export to File option in FCCS Data ManagementSummary: Data Load Rule has been created to export all the data in FCCS to flat file and in DLR filter, Against currency dimension, "Parent Currency" is used. When we ge…Harshith J Rao 11 views 2 comments 0 points Most recent by Harshith J Rao Financial Consolidation and Close
-
Data Integration Pipeline Administration Mode failingSummary: I am adding the Administration Mode As per documentation regarding pipeline, but it keeps failing, we have Type: EPM Platform; Job Type: Administration Mode; I …Vero Ortiz 81 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can a pipeline validate metadata in FCCS?Summary: Can a pipeline validate metadata in FCCS? Content (please ensure you mask any confidential information): I'm building an automation using EPM pipeline to load m…Handel Zhuang 21 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Extract Data with the Full Qualified Name for All AccountsSummary: Content (please ensure you mask any confidential information): Hi All, We are extracting data using the data export feature in data integration and it is extrac…Ayeshan 52 views 3 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform