Data Integration
Discussion List
-
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 124 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… -
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
-
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 43 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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…
-
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
-
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… -
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 106 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Error in Initializing Step to HCM Cloud from Data Integration screenDears, We have a custom Workforce Planning Cube in EPBCS. We are trying to directly connect with HCM cloud. The connection was established successfully but is failing in…
-
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…
-
Copy file from Object StorageHello all! I'm not able to configure properly my EPM instance to copy a file from Oracle Object Storage to 'inbox' in my Pipeline. 1- I created a Connection named Object… -
Netsuite source period mapping not working with FCC data integrationSummary: Hi please can anyone help with defining the source period mapping using Netsuite as a data source and bringing data into FCC via data exchange? I have added the…
-
Pipeline Limitation - Combination of Static and Substitution VariablesHello, When submitting a Pipeline with a combination of static and substitution variables, say StartPeriod of Jan-23 and EndPeriod of &SubVar(Value is another period), t…
-
How to access data management load rule log file using EPM REST APISummary: We are using REST API to trigger a data lod rule and we are able to expose the output as a REST API CSV content but we need to access the corresponding log file…NarayananS 117 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Downloading file from OCI sub-directory using Pipeline Object Store JobsSummary: Using EPM Pipeline - Object Store Jobs, I tried downloading a file from root folder of OCI bucket, it worked fine. I need to download the SOURCE file from sub-d…Mohit Sharma-73954 91 views 14 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
Where i can find sequence option available on Target application in DM in Data ExchanageDear Experts, I want to change order/ sequence of processing order for dimention in data load mapping. Earlier Squence option was available in DM target App screen now i… -
Metadata load from Data Management fails for Replace in Import and Export modesSummary: Metadata load from Data Management fails for Replace in Import and Export modes, it works for Replace and Merge when executed from Pipeline. Error is 'Plan type…
-
Warning status in Data ManagementSummary: In Data Management, processes can finish successfully with a warning indicated by a yellow icon. This usually happens when there are no records imported from th…
-
Import Fusion Supporting References in EPMSummary: Is there a way to import Fusion Journal Supporting References as attributes/use them as LOOKUP mappings in EPM applications (FCC)? Content (please ensure you ma…