Data load
Discussion List
-
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 24 views 2 comments 0 points Most recent by Bill Stevens - 1234 Account Reconciliation
-
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.
-
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 40 views 6 comments 0 points Most recent by Rajesh Krishnam-Oracle Account Reconciliation
-
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…
-
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 414 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…
-
Importing balances using EPM AutomateSummary importbalances command does not workContent Hi I am trying to load GL Balances from EBS into ARCS using EPM Automate. EPM Automate is installed on my client lapt…
-
ARCS Transaction Matching Data Volume LimitWe are doing a TM implementation with a potentially huge volume of records for monthly matching for one of our insurance customers. We are currently dealing with 3+ mill…Loganathan Nachimuthu 39 views 3 comments 0 points Most recent by Loganathan Nachimuthu Account Reconciliation
-
Duplicate Profile Field in ARCS "Reconciliation Compliance Balance" ApplicationSummary: I’ve opened a ticket with Oracle Support regarding a duplication issue affecting the Profile field in ARCS under Reconciliation Compliance. The root cause remai…
-
In Direct integration pass entities dynamically in DM via EPM automate scriptSummary: In transaction matching we are loading data for one data source through direct integration from Fusion GL. entities are defined in Filter option in DLR. To miti…Neha Talati-267028 4 views 1 comment 0 points Most recent by Neha Talati-267028 Account Reconciliation
-
Balance Attribute to include all the chart of field in Drill through URLIn the recent Balance attribute (to calculate periodic activity) release, the drill through functionality now requires the inclusion of all the Chart of Account fields, …Vaishnavi Laguduva 1 view 1 comment 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
Balance Explanations doesnt allow to load more than 500K records - that too without Merge/AppendSummary: For an Inventory Account using Account Analysis method, while trying to import balance explanations (which are more than a million each month), the Load rule fa…
-
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…
-
Camt.053 xml Balances file period mapping to ARCSSummary: We have a requirement to load CAMT.053 bank file balance data into ARCS Reconciliation compliance .We have selected the Out-of-box adapter to configure the data…
-
Question on BAI Format Bank Files feature in July 2025 releaseHi Everyone, I was testing the July 2025 release feature on "Length of Bank Text Column Increased to 1200 Characters When Using BAI Format Bank Files". It is mentioned a…
-
Place to specify journal source as filter and out of box adaptor for GL transaction from Fusion?We want to add journal source as filter which is only visible at application registration option only. I do not see that option in integration. Is there any other place …Hitesh Magnani 2 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle Account Reconciliation
-
CAMT.053 file (.xml) formats load into ARCS reconciliation complianceSummary: Hello, I have a requirement to load the .xml bank file(CAMT.053) into ARCS Reconciliation Compliance. Could you please help me that Is there way I can load this…
-
What is the best way to automate monitoring data load process details from Data Integration?We have a large number of data load jobs running each day, and we need a more efficient way to monitor the success of these jobs than scrolling through the Process Detai…
-
EPM Automate command or function to update accounting date source filter value in data load rule FDMContent We have configure the FDMEE interface to extract the daily balances from GL to ARCS and also created the EPM automate script to execute the load. If we execute w…
-
Business wants the ERP GL Journals import latest in ARCS applicationHello Everyone, In the current configuration the data load runs daily once from ERP (GL Journals) to ARCS through OIC job run, Business wants the ERP GL Journals import …
-
P13 adjustment data load Mode in ARCSSummary: Hi, We are using Oracle E-Business Suite (EBS) as our source system, which follows a P13 calendar. We are attempting to load P13 adjustment data (ending balance…
-
ARCS Transaction Matching data load errorTrying to load GL transaction lines from source for transaction matching only profile. From the data exchange it says failed with error. however in the job section data …