Data Integration
Discussion List
-
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…Jeoz 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 42 views 10 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform
-
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 16 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 12 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 28 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
-
Budgetary control integration from EPM to ERP unexpected behaviorHello team, We are running into some difficulties while configuring Budgetary Control integration between EPM and ERP. As far as I understand, to be able to see the Budg…
-
EPMAT-1:EPMFDM-ERROR: 'periodName' parameter format is invalid.Summary: Content (please ensure you mask any confidential information): Hi all, As specified in the Oracle Documentation,I'm trying to use the periodName parameter in EP…
-
Scheduling job for cross application data mapsHi, With the recent support for cross data maps push to remote application, I am not able to see such data pushes under Data Maps in Jobs scheduler. Is there any securit…Loganathan Nachimuthu 42 views 4 comments 0 points Most recent by Loganathan Nachimuthu EPM Platform and Freeform
-
Data Integration Pipeline feature in ARCSSummary: Availability of Data Integration pipeline feature for ARCS Content (required): Currently the data integration pipeline feature is not available in ARCS. Any ide…
-
DM NZP: How to keep zero values and ignore blank valuesHello, During data integration, if I define NZP in import format, as expected it disabled zero suppression, meaning all zero values are imported from source. This also f…Vijay Mahantesh-Oracle 15 views 4 comments 0 points Most recent by Vijay Mahantesh-Oracle EPM Platform and Freeform -
Data File rename in EPMDear Experts, We are moving file from SFTP to EPM application using REST API. As a next step we want to rename those files once it got moved to EPM overview. Is there an… -
Rest API queriesSummary: 1.Oracle recommendation on the most efficient way to export files via Rest API. We are planning to use Pipeline to export data (job setup to export data) - then…Muruges89 23 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Data Exchange Quick Mode Import Failing due to unknow membersHi, I am loading data using Quick Mode, but the job is failing due to unknown members. Since there are a large number of unknowns (around 5,000 records), it's not feasib…MohanJ 12 views 4 comments 0 points Most recent by Shanthi Subramanian-Oracle EPM Platform and Freeform
-
Process Monitor Report Customized as per Client Requirement from Data ManagementSummary: Process Monitor Report Customized as per Client Requirement from Data Management: Business Requirement : User have 2 categories Actual_JD and Actual_AM where so…