Data Integration
Discussion List
-
pipeline, variables and a "prompt" to choose a versionSummary: Allow administrators, when running a pipeline, to specify which data "version" is contained in a load file—without requiring this information to be embedded wit…
-
Issues Importing Maps in Data Exchange/Management with Comma in Source ValueSummary: We have a number of maps that utilize commas within their Source Value definition. This has never presented as a problem, as wrapping them in double-quotes duri…
-
Data Management - Passing Start Period and End Period to Business RulesContent In Data Integration I have a business rule that performs calculations post load for the period range loaded i.e. DM POV Start and End Period range. In DM Cloud, …
-
How to pass POV as parameters in URL from EPM as drill through to FDISummary: Hi, We want to drill through to FDI using direct drill option from EPBCS and pass the FORM POV selection as parameters in the URL used in direct Drill. Users re…
-
Need to capture the start and end time of a Data load Rule(Data Exchange) in Groovy Rule.The Request is to get REST API output in json format like start time and end time of a Data load rule in Data Exchange. I have created groovy script to extract the log f…Radha Yerra 58 views 5 comments 2 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
oracle account reconciliation : how to delete data by locationSummary: I need to delete data from two location only and not from all the location Content (please ensure you mask any confidential information): Version (include the v…
-
Unable to Export Attribute Member Consolidated Data in EPBCSCurrently, in on-prem, we are exporting data using attribute members, which means we are getting consolidated data rather than associated members through a report script…
-
Configure Snowflake connection with EPM Integration AgentI am trying to connect to Snowflake via the EPM integration agent. I have followed the documented steps. I am using a File Credential Store. I am now receiving this erro…
-
Registering application and configuring connection for ARCS Transaction Matching's GL Data SourceWhen configuring ARCS Transaction Matching for AR to GL and AP to GL which data source should we use for the GL? I can see that there are available data sources for AR a…JML-820830 11 views 1 comment 0 points Most recent by Viorel "Van" Andritoiu-Oracle EPM Platform and Freeform
-
Drill thru to data management in FreeForm appSummary: I have a FreeForm app where during configuration Scenario dimension wasn't enabled. I recently setup a drill region for direct drill thru to the staging area of…
-
REST API to populate EPM Application with Forecast DataSummary: REST API to populate EPM Application with Forecast Data Content (please ensure you mask any confidential information): We are integrating PMIS (3rd party system…
-
Select Account from Target Dimension in Data MappingWe have to configure data load mapping in such a way where we need to map source to target based on condition that source member should exist in target otherwise all sou…
-
Failure in executing integration with "OWP_Incremental Process Data and Synchronize Definition" ruleSummary: I have executed an incremental file-based integration but whenever I am executing this integration by adding the rule in business rule section, it is showing er…
-
In Data Integration what is the difference between Target Period Year and Target Year?Summary: In Data Management/Data Integration, what is the difference between Target Period Year and Target Year in Period Mappings? Content (please ensure you mask any c…
-
Is new incremental file application mandatory if file has new columnsSummary: I have created an executed an incremental file adapatar based integration, now suppose I have new columns added in my file, do I have to create a new incrementa…
-
How to map missing values in integration in EPBCSSummary: I want to execute an integration wherein if the "Union" column is "APS" or "Unaffiliated" for example, then the "Salary Grade" field for it will be blank. I was…Suravi 41 views 10 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
2Pipeline Parent and Child Jobs MonitoringSummary: We want to monitor all the Parent/Child pipelines jobs for the status as part of automation, The REST response provides the GET of the pipeline but not all the …
-
Issue with Period Mapping in Data Management - Source-Period Column Showing Amount Instead of PeriodHello All, We are integrating data between two PBCS PODs. Our goal is to map data from the Jan-Dec periods to 'No_Month' in the target POD. To accommodate this, we have …
-
Data Load Rule "Date format for date data" ignored for User Preferences date formatSummary: The "Date format for date data" setting in a Data Management integration is being ignored and the user running the integration user preference date setting take…
-
How can I use one integration across more than one scenario?Summary: Suppose I have created one integration for actual category to load data into my reporting cube from financials, but I want the same integration to be used acros…Suravi 51 views 4 comments 0 points Most recent by Jeelan Banglewale-Oracle EPM Platform and Freeform
-
Can we increase the precision in data management data load file.Summary: We are running to load exchange rates from data management, however we came to a problem where we are trying to load 15 decimal, but it is loading only up to 6 …
-
Data Export to File from EPBCS pulls in Amount for Source Period in Data ExchangeSummary: Hi All, I am trying to do a data export to file from EPBCS in data exchange. I have the export working in FCCS correctly for actual data and need to create the …Karla McMillan IBM 13 views 2 comments 0 points Most recent by Odin Mjølsnes EPM Platform and Freeform
-
Direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS is failingI am trying to create a direct integration to pull a BI report from Oracle Cloud ERP and load it to ARCS. Extract and import steps are getting succeeded. Getting warning…
-
Invalid Credentials Error - Data Exchange (non-blocking)Summary: Since last update (25.07) we regurlary get an error in data exchange regarding credentials. Eventhough the error is there, the integrations run perfectly. I was…Pieter-Jan Vandendriessche 11 views 3 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Data Exchange how to load one cell to multiple cells in FCC ?Summary: In a data load file I have movements that needs to be loaded to both the FCCS_ClosingBalance_Input member and a specific movement member. How can I load to two …
-
DELETE sql statement for on-prem databaseSummary: Has anybody found a way to run a DELETE sql statement before exporting data to an on-prem database using Data Integration? In Applications, there is field that …
-
When testing strong ciphers with EPMAgent, 401 Unauthorized receivedSummary: We are in the process of testing our strong cipher set ups per the Oracle documentation here: How to Test with the Latest TLS Ciphers The documentation indicate…
-
Object Storage Large File SegmentingWe are looking to use Object Storage as a file staging zone for data extracts going to external systems that can readily retrieve files from Object Storage. To do this w…
-
The substitution variable DataLoadConsolMember is not working as expected.We have two DLRs: one for overrides and one for trial balance (TB) load from ERP. First, we load the overrides data, which successfully appears in FCCS. However, when we…Avani Makwana 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Issue while migrating file based data source application from one environment to another.Summary: Hello, I have registered a file as data source and have created a file based integration to import data into EPM application which is working as expected in the…Neha_R 22 views 5 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform