Data load
Discussion List
-
Is there a way to delete pre-mapped balances that have been imported?Summary: I'm testing out functionality related to importing pre-mapped balances in one of our ARCS test regions. It seems like once I've imported a pre-mapped balance, I… -
What are the best practices for creating profiles when there are invalid mappings?Summary: When we run a data load and have invalid mappings, we download the invalid mapping account IDs and then send an Excel spreadsheet for the profile data to our bu…Steven Woods 18 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
How to download Data Exchange or DM log file using EPM AutomateSummary: How to download Data Exchange or DM log file using EPM Automate we are using EPM Automate to load balances in ARCS Application, this process complete successful…
-
Is it possible to pass multiple values to Oracle ERP Cloud from ARCS Data Management?We have a Oracle Cloud ERP custom BI report with parameters that accept more than one value. When creating a connection to this custom report, I used the following param…Marco Antonio Rossodivita 63 views 6 comments 0 points Most recent by Randy Miller Account Reconciliation
-
How to prevent transactions from being imported twice or arriving twice in ARCSI have a connection that brings data from Oracle Fusion to ARCS to Transaction Matching aplication, the client wants to import the data every two hours, but only to brin…Steven Ballen Pelayo 11 views 3 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Has anyone received an email for Import Transaction for Match Type finished with errors?Summary: I received a new email from no.reply@epm.oraclecloud.com that an import transactions job failed. Has anyone else began receiving these emails? Where are the set… -
how to schedule the data load rules to load the data from GL(ERP cloud data source) in ARCS?Summary: Hello Experts, Since "Scheduling" functionality has been deprecated in Data Management in test ARCS in 24.09 update, how to schedule the data load rules to load…Swathi Kemburu 152 views 4 comments 0 points Most recent by Mike Casey-Oracle Account Reconciliation
-
Has somebody implemented the Exchange Rate pull from Cloud ERP to ARCS?In an event in April 2024, there is mention of a direct way to import the exchange rates from Oracle ERP Cloud to ARCS. The presentation slides have a mention to it, but…Marco Antonio Rossodivita 54 views 6 comments 0 points Most recent by Marco Antonio Rossodivita Account Reconciliation
-
No Period Activity Rule for Balance Comparion MethodSummary: Auto-submit if no Period Activity for Balance Comparison Method Content (please ensure you mask any confidential information): Hi All, There is one requirement …Usha_Ramsinghani 32 views 2 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
Limit on the transactions that can be imported into ARCS using Data exchangeSummary: OTBI report extracts the data from ERP has a limit of 2.5m the total number of records is over 5M. I understand that the OTBI report can be run multiple times t… -
Is any way can we load multiple data loads at same time for same period with different integrations?Summary: there is any way that we can load multiple data loads at the same time for same period with different integrations? The reason for asking is we have a business …Saritha Mannnajirao 31 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
How to switch decimal symbol in Data Integration for amount?Summary: Hello, Client is producing reconciliation balances CSV files with semicolon as a separator and comma as a decimal symbol for amounts. Basically client is reques…
-
Data integration for transaction matching exports successfully, but no data is pushed into accountHi, We have a few file-based data integrations that are showing as successful data loads in Data Exchange, including a full import/validate/export process. But, no data …
-
Can we add more than 60 attributes in application under data exchangeWe need to pull data from BIP Report to ARCS and BIP report contain more than 60 attributes but not able to add more then 40 attributes and 20 UD in the application unde…SAI SAKETH KANCHERLA 21 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
How to connect ARCS to databaseSummary: How to upload data into ARCS without generating csv file but using a custom table to connect to it directly to load data. (of course by mapping all attributes a… -
Is there any limit for number of invalid mappingsSummary: Is there a limit to the number of invalid mappings shown after the load period in the application (Periods -> Import Data -> Invalid Mappings)? Does the warning…
-
Drill Through on Ending Balance Fails with "Could Not Find Period key for given parameters"Summary: After loading data to an application in ARCS, I'm getting an error when I drill on the Ending Balance in Reconciliation after the load, screenshot below. I have…
-
There is any epmautomate command to know the status of data load ?Summary: Is there is any epmautomate command to know the status of data load. We need a epmautomate command to add in script to know the status of data load . Content (p…Saritha Mannnajirao 31 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Account Reconciliation
-
Source System Balances do not show in RC Recons.Apologies if this is a very Basic question, I am new to ARCS and need help understanding the background process involving . I have setup RC reconciliation for an account…
-
SmartView is not allowing Japanese Characters to be loadedTrying to do pre-mapped data load using SmartView with data which has Japanese characters but it is failing with an error. How to tackle this special character requireme…
-
Limit on adding members in data load rule filters in account dimensionDear Experts, We are fetching data from Fusion ERP. Over there we have to pull some unique account and that count is near about 93. When we are adding 94th member it's n… -
is there a way to load a specific profile/reconciliation and not reload all datawe often book journals well past when users start reconciling accounts. in the past this has caused the users to lose work as completed recs revert back to open status (…
-
When loading Reconciliation transactions we need to filter the data loadedSummary: The load file contain transactions that should not be loaded to ARCS. In the file I have an attribute containing the Status with values: Approved, Canceled or A…Gert Hvarregaard 41 views 7 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
Merge option for data load in ARCSSummary: Has anyone tried the newly released MERGE option for loading data into ARCS? Content (required): I am trying to use this functionality but it's not working for … -
Locking a period for importing of dataSummary: Hi We have had a few issues where we in mistake loaded data to the incorrect period. We would like to be able to lock a period for importing data (data exchange… -
ERROR: Field Is Restricted when using NetSuite with DMSummary: Hi, We are trying to load from a saved search in NetSuite to Data Management for NSAR. We created a custom text field for the Location to retun None if the fiel…
-
Passing Period to On-prem Oracle EBS DB using EPM On-Prem Agent from ARCSSummary: Passing Period to On-prem Oracle EBS DB using EPM On-Prem Agent from ARCS Content (required) We plan on using Agent as shown in https://us.v-cdn.net/6034893/upl…
-
Conversion from monthly periods to daily periodsWe have an application enabled for both Reconciliation Compliance and Transaction Matching. We are currently using monthly periods where we are loading BAI transactions …Sonali Bhatia 21 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Delete/update a period with Data Management dataSummary: Unable to delete /update Application period with Data management data. Content (please ensure you mask any confidential information): After configuring the appl…
-
ARCS and Netsuite Data Integration/Management using the NSAR Saved SearchesWe have configured the connection between ARCS and Netsuite and can successfully load data to Data Integration/Management Workbench) using the NSAR Saved Searches in the…