Data load
Discussion List
-
Data load failed due to invalid sub-segment values in the source data?We have an integration from SAP to ARCS which was working fine from the past few years until the 16th of May. The data format, the integration setup has not been modifie…Patrick Pontillas 222 views 15 comments 1 point Most recent by Ryan Lunde-Oracle Account Reconciliation -
Oracle Cloud ERP subledger balance auto feed to ARCSSummary: Is there a way to automate the feed from Oracle Cloud ERP subledgers AR, AP, Fixed Assets into ARCS in 2023? Content (required): We are currently manually enter… -
Oracle Cloud Subledger Integration with ARCSContent Hi All We have Oracle AP, AR, and Cash subledgers and need to integrate them with ARCS application. Is there any way that we can have a direct integration from t…
-
MapLoaderTemplateSummary: I need to load Bulk mappings for our Group Recon Profiles. I am trying to use the delivered "MapLoaderTemplate.xls", but I am not able to successfully upload. N…Madhu Chalamalasetty 11 views 1 comment 0 points Most recent by Matt Greenjack Account Reconciliation -
Adjustment File is getting extracted under Jobs but there coming Run time exception errorSummary: When I am running the integration set up which export journal entries for adjustments for Match Type, Adjustment File is getting extracted under Jobs but there …
-
BI Publisher Report Connection Failing IntermittentlySummary: We have recently configured a direct connection from ARC to Oracle ERP to call a BI Publisher report to pull in transaction details for a reconciliation. We are…
-
Oracle Netsuite YTD balances to ARCSSummary: We are currently having Oracle NetSuite as our Source System and we are trying to load balances into ARCS system in YTD . We have configured our connection with…
-
Is there a way to use EPMAutomate to post annoncements to ARCSHello, we are just starting to use ARCS, and users are asking us to post an announcement in the announcements area once data from the various sources have been loaded. W…
-
Performance Impact from Loading 700+ bank Files dailySummary: We are currently loading over 700 bank statement files (CAMT.053 format) daily, into EPM ARCS. As a result, the Process Details section is taking a long time to…Pieter-Jan Vandendriessche 22 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
New Date Format and Decimal Separator feature in Data Loads creation in ARCS after May'25 patch.Hello Everyone, After the May'2025 patch update, there are two new fields which have to be selected while creating the data loads in the ARCS. It also changed the existi…
-
Can we enter filter conditions based on member description under source filters in DLR?We are creating an integration with GL where we want to filter out "product" on the basis of "product description" by using the condition : if contains "variable". Expla…
-
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…
-
How do we restrict subsystem balance to be loaded to Account analysis profilesContent We have profiles today that are marked as Account analysis but when we do a data load there are some account ids which are coming from Subsystems and also Source…User_2025-02-11-00-22-34-536 55 views 5 comments 1 point Most recent by Tim Gaumont-Oracle Account Reconciliation -
ARCS Data Load Information in Overview Gone After May UpdateSummary: After the May update, we notice that the information normally displayed on the Data Loads tabs in the Overview section is no longer there. Content (please ensur…
-
Automatch matches same profiles mutiple timesSummary: We have set up an automation that runs the automatch each hour. But now I see that in the job logs, the same profiles are matched each hour (see logs attached).…Pieter-Jan Vandendriessche 22 views 2 comments 0 points Most recent by Harry Zhu Account Reconciliation
-
Creation of SubSystem Adjustment DLR Fails with Internal Server ErrorSummary: On creating a data load rule to import subsystem transaction adjustments, when we go to save the integration after defining dimension mappings, the save hangs i…
-
Locations not Available for Data Load in ARCSSummary: We have creating a data load to load Balance Adjustments in ARCS. However, after testing and successfully running the Data Load Rule, we are unable to create a …
-
How to migrate the historical reconciling items from a 3rd party systemSummary: We are about to start our Oracle ARCS project. We are currently using a 3rd party solution to perform the GL and SL Recons. We been using our system from past 1…Madhu Chalamalasetty 21 views 2 comments 0 points Most recent by Madhu Chalamalasetty Account Reconciliation
-
Pros/Cons of using FCC to Load ARCSHi - can anyone tell me what they have found to be pros/cons of using FCC balances to load ARCS?
-
Monitoring EPM Integration Agent healthSummary: Hello, I'm looking for a tool or method that proactively checks the health of the EPM Agent before running a Data Exchange integration. We use the EPM Agent to … -
DM Logic Accounts: need to prevent summarization of identical rowsSummary: We are duplicating transactions 1-by-1 using logic accounts and everything was working as expected, except with a recent load file that contained 5 rows which w…
-
Map 2 Source Amounts to Target for ARCS AP subledgerSummary: In Oracle ARCS, AR subledger Integration Setup/ Import Format maps source " FUNCTIONALAMOUNTREMAINING " to target "Amount". This works for existing account 1210…
-
ARCS DM Special Character ? only works when "Apply to Rule" is used. Why?Summary: ARCS DM Special Character? only works when "Apply to Rule" is used. Why? Content (please ensure you mask any confidential information): I had been exploring som…Conner Nations - Finacial Systems Manager 21 views 1 comment 0 points Most recent by BillHack-Oracle Account Reconciliation -
How to pass SYSDATE parameter to OnPremise database using EPM Integration AGent select queryHello, I have a question regarding EPM Data Exchange EPM Agent integration with On Premise Database where we are trying to load incremental data from ERP On premise to A…
-
Export Data management configurations - ARCSSummary: DM configuration export. Identify DLR for reconciliation balances with * to * mapping Content (please ensure you mask any confidential information): Is there a …
-
BAI Transactions Imported with Statement Date instead of Transaction DateSummary: BAI Transactions are currently imported with Statement Date which should be using Transaction Date Content (please ensure you mask any confidential information)…
-
EPM Data Management query to Accounting Foundation (AFCS) tablesSummary: EPM Data Management query to Accounting Foundation (AFCS) tables: how do it? Content (please ensure you mask any confidential information): Version (include the…
-
[ARCS] How to filter out other currency data in Reconciliation's Source System Ending BalanceWe have created an integration for our source system ending balance with ERP GL as our source. When we try to re-execute the Integration, we noticed that in some of our …
-
Bank verification issue with BAI file that does not contain currencyHi, We have a BAI file that does not contain currencies in the 03 records. When we run the integration with the "Verify Statement Balances" option enabled, it says "Appr…
-
pass variable with epm aSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…