Data load
Discussion List
-
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 15 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 42 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 439 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 32 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 1 view 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 2 views 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