Data load
Discussion List
-
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 42 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…
-
ARCS Netsuite Integration - Issue with 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…
-
How to access core ARCS tables using API's or any other available way ?Summary: As a BIA team need to create a data lake in Azure cloud for all the ARCS data i.e. reconciliations and all.. so want to have all base tables of ARCS in data lak…
-
Are the Account Reconciliation saved searches in Netsuite available for Oracle ARCS to use?Summary: We are implementing ARCS for reconciliation of Netsuite data (also Planning has already been impleneted and alongside the ARCS imlementation we are also impleme…
-
Error on extracting data using DLR from Fusion ERP into ARCSWe are trying to run data load rule for group reconciliation to extract data from ERP into ARCS. We have changed source filters for Intercompany dimension to use level 0…
-
Data load for a locked period in ARCS applicationHi, In our current data load process, we are loading data for one closed period(Dec) and current open period(Apr). Since, the period (Dec) is closed for data loads to ha…
-
Pulling in Accounts Payable (AP) and Accounts Receivable (AR) transaction detail into ARCSSummary Trying to load AP and AR Subledger Transactions into ARCS systemically via Data ManagementContent I am attempting to leverage the systemic ability to load subled… -
ARCS - Direct Connect with Oracle Cloud ERP SubledgersSummary We are able to Direct Connect to the Oracle Cloud ERP General Ledger. But can we Direct Connect to the Oracle Cloud ERP Subledgers (AR, AP, FA)?Content We have 3…Ed Bennett 249 views 5 comments 1 point Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Do we have out of box subledger reports in ERP to extract data and load in ARCS to perform GL/SubSummary: Content (required):Do we have out of box subledger reports in ERP- Fusion to extract ending balances and load in ARCS to perform GL/Sub in reconciliation compli…Neha Talati-267028 82 views 4 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Can you push currency exchange rates from FCCS to ARCS? Is there a workaround?Summary: Looking for a way to push/pull/load currency exchange rates from FCC to ARCS. Content (required): We currently use the FCC and Planning applications and are in …Connor Butler 123 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Updates to Fusion ERP Cloud Data Adapter in 21.10Summary: Updates to Fusion ERP Cloud Data Adapter in 21.10 Content (required): Attached file demonstrates how to link a custom ESS Job encapsulating a BIP Report in Fusi…Thejas Shetty-Oracle 61 views 2 comments 1 point Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
What methods are available to extract ARC data tables?Summary: Are there any methods, outside of custom reporting, to extract data from the tables within ARC? Content (required): Our business users have a desire to be able …Braxton Sowell 96 views 6 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Outbound NACHA/ACH file exportHi, Does ARCS have the ability for an outbound integration of a NACHA or ACH file? The file would consist of balances/transactions pulled from ARCS to send externally to…
-
Why do I not see sub-system balances in Balance Summary after running the data load and import jobs?Summary: No sub-system balances in Balance Summary. Content (please ensure you mask any confidential information): I ran the data load, and the sub-system in the Workben… -
FCCS to ARCS - Change 'Entity Currency' to Entity's currency codeSummary: Pulling data from FCCS to ARCS for Intercompany reconciliation compliance balances via data integration - need to map currency code to each entity to translate … -
Direct integration from Fusion ERP for reconciliation compliance transactionsSummary: Direct integration from Fusion ERP for reconciliation compliance transactions Content (please ensure you mask any confidential information): Hi all, we need to …
-
Reconciliation between balances (ERP) and workbench data (FCCS)Summary: I would like to know the best way to set up a reconciliation between ERP ending balances and a workbench data file from FCCS in order to ensure that mapping bet…Karolina Kawecki 63 views 10 comments 1 point Most recent by Karolina Kawecki Account Reconciliation
-
ARC top level members drill down : Getting error unknown member 1260046Summary: In ARC, we have configure ERP import format such that we are pulling segment values at top level only instead of All descendents. But, whlie Trying to drill thr…DRishabh 52 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Account Reconciliation
-
Is it possible to export excel from data load log/ warning from period screen using APIsSummary: Is it possible to export excel from data load log/ warning from period screen using APIs (Invalid Mappings, Unsupported currencies, etc) Content (please ensure …