Data load
Discussion List
-
Automatch matches same profiles mutiple timesSummary: We have set up an automation that runs the automatch each hour. But now I see that in the job logs, the same profiles are matched each hour (see logs attached).…Pieter-Jan Vandendriessche 21 views 2 comments 0 points Most recent by Harry Zhu Account Reconciliation -
Creation of SubSystem Adjustment DLR Fails with Internal Server ErrorSummary: On creating a data load rule to import subsystem transaction adjustments, when we go to save the integration after defining dimension mappings, the save hangs i…
-
Locations not Available for Data Load in ARCSSummary: We have creating a data load to load Balance Adjustments in ARCS. However, after testing and successfully running the Data Load Rule, we are unable to create a …
-
How to migrate the historical reconciling items from a 3rd party systemSummary: We are about to start our Oracle ARCS project. We are currently using a 3rd party solution to perform the GL and SL Recons. We been using our system from past 1…Madhu Chalamalasetty 22 views 2 comments 0 points Most recent by Madhu Chalamalasetty Account Reconciliation -
Pros/Cons of using FCC to Load ARCSHi - can anyone tell me what they have found to be pros/cons of using FCC balances to load ARCS?
-
Monitoring EPM Integration Agent healthSummary: Hello, I'm looking for a tool or method that proactively checks the health of the EPM Agent before running a Data Exchange integration. We use the EPM Agent to … -
DM Logic Accounts: need to prevent summarization of identical rowsSummary: We are duplicating transactions 1-by-1 using logic accounts and everything was working as expected, except with a recent load file that contained 5 rows which w…
-
Map 2 Source Amounts to Target for ARCS AP subledgerSummary: In Oracle ARCS, AR subledger Integration Setup/ Import Format maps source " FUNCTIONALAMOUNTREMAINING " to target "Amount". This works for existing account 1210…
-
ARCS DM Special Character ? only works when "Apply to Rule" is used. Why?Summary: ARCS DM Special Character? only works when "Apply to Rule" is used. Why? Content (please ensure you mask any confidential information): I had been exploring som…Conner Nations - Finacial Systems Manager 22 views 1 comment 0 points Most recent by BillHack-Oracle Account Reconciliation -
How to pass SYSDATE parameter to OnPremise database using EPM Integration AGent select queryHello, I have a question regarding EPM Data Exchange EPM Agent integration with On Premise Database where we are trying to load incremental data from ERP On premise to A…
-
Export Data management configurations - ARCSSummary: DM configuration export. Identify DLR for reconciliation balances with * to * mapping Content (please ensure you mask any confidential information): Is there a …
-
BAI Transactions Imported with Statement Date instead of Transaction DateSummary: BAI Transactions are currently imported with Statement Date which should be using Transaction Date Content (please ensure you mask any confidential information)…
-
EPM Data Management query to Accounting Foundation (AFCS) tablesSummary: EPM Data Management query to Accounting Foundation (AFCS) tables: how do it? Content (please ensure you mask any confidential information): Version (include the…
-
[ARCS] How to filter out other currency data in Reconciliation's Source System Ending BalanceWe have created an integration for our source system ending balance with ERP GL as our source. When we try to re-execute the Integration, we noticed that in some of our …
-
Bank verification issue with BAI file that does not contain currencyHi, We have a BAI file that does not contain currencies in the 03 records. When we run the integration with the "Verify Statement Balances" option enabled, it says "Appr…
-
pass variable with epm aSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
Will Results be added back to the dataload execution window?Summary: Notice that with the May 2025 release pushed to test environments last weekend, the Result section no longer shows on the Dataload Execution window when accesse…
-
Hi Everyone - I am getting an error message when I am importing data in Transaction Matching.Summary: I am getting the error message "reconciliation is not valid for this type of match" when I am importing transactions into Transaction Matching. Does anyone have…
-
How to reference a field loaded as an AttributeSummary: My General Ledger balance file is loaded with several fields as attributes, such as "ENABLED-FLAG", "Unit Desc", and others. However, I cannot select these fiel… -
Timing issue for assigning periods to auto-loaded filesSummary: We are setting a cash reconciliation flow in ARCS. Daily, a lot of files are loaded trough OIC into EPM. The issue is because the files often contain data of pr…Pieter-Jan Vandendriessche 11 views 2 comments 0 points Most recent by Pieter-Jan Vandendriessche Account Reconciliation
-
Data Load is missing records even though ESS Job file had it in themSummary: We created BIP report which was used as ESS Job to pull data to ARCS. File loaded all the records when we manually load it into ARCS, however it ignore lines wh…Wilson Chelakadan 11 views 4 comments 0 points Most recent by Wilson Chelakadan Account Reconciliation -
ARCS Data management : Data Load MappingSummary: We have a scenario in data management/Data exchange to map the members as follows: Scenario1: Currently we are using Multidimensional mappings (where company is…
-
Account Profile Mapping is not working in DMSummary: Account Profile Mapping is not working in DM Content (required): Reconciliations have been created to individual Accounts lets say 110-209900 to 200-209900 but …Sivakumar Chowday K 33 views 5 comments 0 points Most recent by Conner Nations - Finacial Systems Manager Account Reconciliation
-
Data Source is not validSummary: In ARCS, I had a working set up where I load data from a file into a transaction matching data source. I might have done some adjustments to the matchtype and n…Pieter-Jan Vandendriessche 21 views 2 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Seeking correct way to migrate newly created data integration from PROD to TEST...My 1st question to the 3C... "Hello!" By utilizing the Migration tool within ARC, I'd like to find documentation, an external link, or direction on the specific objects …
-
Subledger Transaction data can be used for both Transaction Matching and Balance Comparison(Recon CoSummary We have periodic Transaction level data extract for all subledgers(AP,AR,FA,Cost,Cash), can we use same extract for both Transaction Matching and reconciling the…Venkatraj Bhat 67 views 9 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Is there a way to delete pre-mapped balances that have been imported?Summary: I'm testing out functionality related to importing pre-mapped balances in one of our ARCS test regions. It seems like once I've imported a pre-mapped balance, I…
-
Epmautomate to export data from data management for particular locationSummary : Epmautomate to export data from data management for particular location
-
Limit to DLR for a location in DM (ARC)Summary: We would like to know if there is limit to number of DLR that can be created for a given location in ARC Content (please ensure you mask any confidential inform…Vaishnavi Laguduva 21 views 6 comments 0 points Most recent by DavidPieczonka17 Account Reconciliation
-
When Exporting Transactions like Balance Explanations, Does this Replace ALL Transactions Loaded?Summary: If Transactions for something like Balance Explanations are loaded, does this replace ALL Transactions for that Period previously loaded, or only the ones for t…