Data load
Discussion List
-
Incremental Load in Transaction Matching - Same Records can prevail in each roundsSummary: We are loading data from Oracle ERP to ARCS Transaction matching for every 1 hour. This is a BIP Report integration where period is setup as param. In the Round… -
Retrieve "Invalid Mappings" file after Data loadSummary: We are trying to retrieve the "Invalid mappings" file using REST API which will be available below the Result column after doing "Import Data" for a period. Do …
-
How to decouple Data Load (full refresh) locations on ARCSSummary: How to decouple Data Load (full refresh) locations on ARCS Content (please ensure you mask any confidential information): On ARCS, I sometimes need to reload da…
-
Generate a summary report from workbench dataSummary: Generate a summary report from workbench data Content (please ensure you mask any confidential information): I'm looking to create a report that displays a summ…Saraiya Daisy Dhanesh 18 views 1 comment 0 points Most recent by Mike Casey-Oracle Account Reconciliation
-
$START_PERIODKEY$ uses calendar dates, not fiscal.Summary: We use a fiscal calendar in Global Period Mapping, and the Period Key is derived from that fiscal calendar. ARCS is integrated with Oracle ERP reports executed …
-
Drill Through to Source and Open Source Document is not working in ARCSDrill Through to Source and Open Source Document is not working in ARCS. For Drill through - we are seeing Error in Fetching details For Open Source Document - The downl…
-
While loading Transactions in ARCS in replace mode the data is getting aggregated.In ARCS Data Integration the Export mode "REPLACE" is not working. When I am using replace, data is getting aggregated with the existing data so how can I load the data …
-
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 …
-
Multiple Adjustment Periods for the same period in Data Management for ARCS Data LoadSummary: Hello Everyone, I am working on ARCS Data Loads using Data Management and would like to check if anyone has experience with configuring multiple adjustment peri…
-
Fusion ESS Job for Subledger Closing Balance Taking More Than 1 Hour – Performance IssueHi All, We are using the Subledger Closing Balance report (ESS job) in Fusion to extract balances into ARCS. The job is currently taking more than 1 hour to complete in …
-
How can I use "fill=EuroToUS" with attribute balance?Summary: How can I use "fill=EuroToUS" with attribute balance? Content (please ensure you mask any confidential information): Hi, I am using attribute balance (Type: "Nu… -
calculate amount column in data load mappingSummary: Requirement is to calculate the amount dimension as * to 1/Amount in FCCS data load integration. Kindly help me in sharing knowledge on the efficient way to han…PrinceKumar 11 views 5 comments 0 points Most recent by Vijay Mahantesh-Oracle Account Reconciliation
-
OOB AR and AP Transactions fieldsI’m currently working on a basic AP-to-GL and AR-to-GL transaction matching reconciliation for a demo we’re building for a client. To ensure accuracy, I would like to kn…
-
How do you overwrite a system translated balance in ARCS?For testing purposes, we are trying to import reporting balances (USD), from a different system, into ARCS. We are importing balances for individual and summary reconcil…Bill Stevens - 1234 52 views 6 comments 0 points Most recent by Bill Stevens - 1234 Account Reconciliation
-
what is the relevance of column sequence while configuring transaction matching target application?what is the relevance of column sequence while configuring transaction matching target application? How to know what numbers to be entered into column sequence?
-
Period Mapping in ARCS for loading FCCS balanceWe are setting up data load rules on the ARCS end to source the balance from FCCS. The rule is querying the source FCCS correctly for the period however its not able to … -
How can I check the jod history in Oracle ARCS for imported rate data?In Oracle ARCS, I would like to verify the history of jobs that were executed when importing rate data. Could you please let me know how I can check whether the rate dat…
-
Can we use OTBI report in ARCS data integration to load balanceWe can load data to ARCS using BIP reports. Can we also use OTBI report for the same.
-
Daily TM with Monthly Recons - Period ConfigurationI feel like I have done this at past clients and either I am either mis-remembering or missing something entirely. It has been a while since I set this up and my mind is… -
Loading GL Revaluation Journals into ARCSCurrently, we are loading GL Revaluation Journal entry lines into ARCS as an Adjustment to source system. The recons that are already auto closed are reopened as expecte…
-
ARCS Data Load error after May2025 Patch"Data load failed due to invalid sub-segment values in the source data. Ensure the sub-segments do not contain the dash character (-)." After applying May 2025 patch, ou…
-
ARCS FA Subledger report integrationSummary: Issue with period parameter in OOB FA sub ledger report. The period value is the period name and not in a standard date format. Content (please ensure you mask …Debargha Biswas 51 views 6 comments 0 points Most recent by Rajesh Krishnam-Oracle Account Reconciliation
-
Period Mapping for Balance Explanations – Fusion GL Date Outside Period RangeSummary: I am bringing in balance explanations from Fusion into Account Reconciliations. For this example, my Fusion period is JUN-FY-25. In Account Recs, my period mapp…
-
ARCS Data Export - Pipeline to export workbench dataHi team, Do we have any option in pipeline to export workbench data in ARCS?
-
Is it possible to import only certain pieces into ARCS from Data Integration Artifact MigrationSummary: We recently built new integrations in Data Management/Data Integration that we would like to import into Production, but it doesn't appear to allow us to select…
-
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 453 views 9 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
Debit amount and Credit Amount to Net TotalSummary: In the transaction matching integration, we have a column for Dr Amount and another for Cr Amount; however, there is no net amount provided in the file. I need …
-
Workaround to schedule data loads in ARCS applicationSummary: Hello EPM Guru's!! Is there any workaround to schedule data loads in ARCS application? We have a use case to schedule the data loads in Linux servers for GL & S…
-
Data Exchange running smoothly previously and now 1 line is missing from workbenchSummary: Data Exchange running smoothly previously and now 1 line is missing from workbench. The process successfully run and validation is complete no errors. Content (… -
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…