Data load
Discussion List
-
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 43 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 2 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 1 view 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 …
-
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 226 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 21 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…