Data Integration
Discussion List
-
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 91 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…
-
Period name - Source filter in Data load ruleSummary: The EBS on-premise data base is integrated with FCC using the EIA agent . We have used the EBS adaptor for the integration which internally uses two parameters …
-
How to lock/unlock periods in Data ExchangeSummary: Looking for the functionality in Data Exchange that exists in Data Management to Lock/Unlock locations by Period. Content (please ensure you mask any confidenti…Stephanie Philopoulos 103 views 6 comments 0 points Most recent by Mike Casey-Oracle EPM Platform and Freeform
-
EPM Integration Agent encryptionSummary: EPM Integration encryption Content (required): Client's network security team requires to know how EPM Integration Agent secure the data transfer and protect th…Gary-consultant 61 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
FDMEE Error: ExtractBalanceData:Error::Cannot perform cube view operation. Essbase Error(1260046)Summary: Hi, in FDMEE, using: Data Source: ERP Cloud Target: EPM Local Clicking on the import phase, the system returns no "fishes" (image below) and the log returns the…
-
Pipeline Migration MethodSummary: Is it supported to migrate pipelines by exporting via a snapshot and importing to the Target? Content (please ensure you mask any confidential information): We … -
Data Export to File does not workSummary: Hi Team, In FDMEE, when using Data Export to File as Target, the first step of the Data Load Workbench (Import+Validate) does not load any data! I tried to use …DavidePacilio 81 views 9 comments 0 points Most recent by Kumaresh Sankar-Oracle EPM Platform and Freeform
-
Data Exchange screen not renderingSummary: For some users, when they go to Data Exchange, the screen is completely blank. The pane doesn't load. Have tried with different browsers, but same behaviour. Ha…
-
ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGESummary: ROWS COMING WITH "BLANK" FLAG FOR DATA LOADS in DATA EXCHANGE Content (please ensure you mask any confidential information): Hi Team, We are trying to load data…
-
ARCS Snowflake Query - Make period name parameter instead of hardcoding monthSummary: I am trying to pass in period name to my Snowflake query in ARCS. I am not sure what I should be trying to use in the Query when setting this up. I have tried t…Erik_Olson 13 views 3 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Data Management - Multi Column IntegrationSummary: Import format dimension not visible or mapped in Workbench Content (please ensure you mask any confidential information): I've configured a multi-column all dat…
-
Conditional in Source/Target expressionHello there! Where I can find all the possibilities for the Conditional statement in Source/Target expression? In the documentation, there is only one example with the t…
-
Replacement of Data Management features by Data IntegrationStarting in release 23.07 (July 2023) we will begin to incrementally turn off features in Data Management and direct users to use the similar features in Data Integratio…Mike Casey-Oracle 1.4K views 76 comments 5 points Most recent by Al Marciante-Oracle Enterprise Performance Management Resource Center -
Using SSO Users or Oauth2 for Connections in Data Integration Planning CloudSummary: We are not allowed to use Native users - SSO from corporate Azure servers are the company policy. Is there a way to use an SSO user also for the connections/ ta…
-
Object storage namespaceHi I'm interested in using the new Pipeline feature to move files to and from Object Storage. How do I find out the namespace for my respective tenancy? I read the docum…
-
Drill through to GL Essbase cube using custom data load processSummary: We have decided to proceed with a custom data load process and not use the standard GL adapter to source GL balances. This has led for us to consider a custom d…
-
Data integration job between Workato Rest API to EPM Cloud not working.Summary: Data integration job between Workato Rest API to EPM Cloud not working. Content (required): We recently migrated ARCS classic to Cloud. now we are establishing …Srinivas Nuthi 21 views 7 comments 0 points Most recent by Omar Shubeilat. EPM Platform and Freeform
-
Removal of Custom ApplicationsSummary: Removal of Custom Applications Content (required): Hi Team, When will the Custom applications be completely removed in FCCS. Please let us know the timeline pla…
-
How to load mutiple currencies from Fusion to EPBCS?Summary: Loading multiple currencies from Fusion to EPBCS Content (required): Hi, we need to load different currencies from Fusion to EPBCS. Can someone assist on how th…
-
How to add a prefix to specific members in Data Load MappingSummary: Having trouble mapping a prefix and no prefix while loading employee data. Content (required): I am trying to load employee data using employee number. In our s… -
The member [NONE] does not exist for the specified cube or you do not have access to it.Summary: The member [NONE] does not exist for the specified cube or you do not have access to it. However, there is nothing in the data load workbench with that value. C…
-
There is no Fusion Hierarchy Top Node in Options tab in Data Integration ? (Metadata Integration)Summary: There is no Fusion Hierarchy Top Node in Options tab in Data Integration Content (required): Hi , I Would to integrate metadata fusion to pbcs, but there is no …