Data Integration
Discussion List
-
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 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…
-
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
-
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…
-
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: … -
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 51 views 2 comments 1 point Most recent by M. Kyle Goodfriend-Oracle EPM Platform and Freeform
-
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 M. 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
-
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 24 views 3 comments 0 points Most recent by M. Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Data Exchange - Clear Region broke after Jan-24 UpdateHi, Unable to select members from the hierarchy in the 'Clear Region' option in Data Exchange on all DLR's. Anyone else notice this? Our last successful run was Jan 19th…Hyperion_Junkie 61 views 8 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform
-
Pipeline Move from Outbox OR Download/Upload File OperationSummary: Pipeline as per 23.09 includes 'Move' from Inbox. Could we know about 'Move' from Outbox? OR Download/Upload File operation availability? Content (required): Pi…
-
Pipeline Start and End Period failing though REST API but successful when executed manually.Summary: Pipeline variables for start and end period work properly when executed manually but fail whenever the job is executed through a REST API call. Content: I've cr…
-
DLR Members Selected if no Source Filter GivenI have a DLR which is pulling data from an FCCS application to a TRCS application. The DLR has no Source Filter specified for the dimension Data Source. The structure of…annaschmult 51 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform
-
How to view update details for report querySummary: How to view update details for report query Content (please ensure you mask any confidential information): The query for our Process Monitor Report was updated …Ryan DeFilippi 91 views 5 comments 1 point Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Data Management file to FCCS - Power users unable to export the data.Hello, We have a group of people as Power Users in FCCS, even though their access to the dimension is fine, while trying to load the file data in Data Management (DM), t…yanni vossos 255 views 9 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform -
Is it possible to generate .dat to .csv in DM?Summary: In data management, Is it possible to generate .csv instead of .dat ? Content (please ensure you mask any confidential information): Version (include the versio…Subhojyoti Chakraborty 41 views 4 comments 0 points Most recent by M. Kyle Goodfriend-Oracle EPM Platform and Freeform
-
Pipeline option to pull a file from third party serverSummary: Currently in data load Automation script, we have a third party server for maintaining the file (loading the file based integration) from e.g. like PeopleSoft. …
-
How to extract data file with date timestamp in data managementSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…Subhojyoti Chakraborty 31 views 2 comments 0 points Most recent by Subhojyoti Chakraborty EPM Platform and Freeform
-
How to ignore Header and Footer rows in Flat Files for Data IntegrationHi team, Using the new UI of Data Integration. How do you ignore header and footer rows of a flat file? I know with multi-column load you can have it in the expression, …Peter Joelson 706 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
How to set pipeline substitution variable for Week Period combinationSummary: Our PBCS application period holds data in a different way. I.e in Weeks format. Eg: 01/05/2023 01/12/2023 11/02/2023 We have started integrated EPM with Snowfla…Praveen Reddy 101 views 8 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Need information regarding EPM AgentSummary: Hi , we are using EPBCS , we are getting salary data from a view and it’s a multi column data for account, in a file integration , we can define the import form…
-
Customize Data Management Log FileSummary: If any errors in data load rule running, the log file will show the error message. But the file is too tech with coding words. Is there any way to customize the…Xu, Angela Menglei 11 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
How to Import data in HFM application from FCCSSummary: Is there any out of box integration available to import data in HFM application from FCCS Content (required): Hi Team, We have a requirement where parent entity…
-
Pipeline Copy from Object Store File NamesSummary: We're currently trying to set up the pipeline to import current period trial balances for specific locations into FCCS data manager via the Pipeline Copy from O…
-
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
-
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…
-
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…