Data load
Discussion List
-
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 12 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 31 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 65 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 23 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…
-
loading multi-column Numeric data as amountSummary: loading multi-column Numeric data as amount Content (please ensure you mask any confidential information): We have a source file with a receipt and payment colu…
-
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 …
-
Oracle ARCS - Creating a sub-folder in the #agentinboxIn Oracle ARCS, when trying to import a file from a subdirectory of the agent's inbox, the agent uploads the file to the inbox instead of to the data folder. Once that h…
-
300 character maximum for fields while importing BAI fileHi, we are having trouble bringing in more than 300 characters for a field when importing using a BAI transactions application. We have tried various substring logic on …
-
Transaction Matching Invalid Account - Default SettingsSummary: Understand cause and effect of Default settings for Transaction Matching to exclude Invalid Accounts Content (please ensure you mask any confidential informatio…Vaishnavi Laguduva 25 views 2 comments 0 points Most recent by Vaishnavi Laguduva Account Reconciliation
-
CAMT053 Export Data completes with Error status instead of Warning with Zero transactionsSummary: When ARCS receives CAMT.053 bank statement files with all zero entries/transactions, the job will fail when loading to ARCS. This seems to be a misleading Error…Jacalyn Munyon 24 views 1 comment 1 point Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
IGNORE mappings causing data load errorSummary IGNORE mappings for reconciliation compliance are causing a data load error during the "import data" step within the ARCS UIContent We have mappings that are Lik…
-
Purpose of Location Attribute Functional Currency vs Category Mapping vs Currency Dimension MappingSummary: What is the purpose of the Location Attribute "Functional Currency" when Category Mappings and Dimension Mappings exist within Data Exchange? Content (please en…
-
integrating balances from Planning cube to ARCS monthly reconciliationswe would like to know if the balance from the any Planning cube can be integrated/reflected in the subledger balance in the ARCS ME reconciliation so that users don’t ha…
-
Issue Transaction Matching when import from data managementSummary: I have two periods: December 14th and 15th. The reconciliation for Profile XYZ on December 14th is submitted (closed), and the period for December 14th is locke…Alberto Parisella 22 views 1 comment 0 points Most recent by James Yesudass-Oracle Account Reconciliation -
How to load a .dat file with Fixed length formatSummary: Hello everyone, I have .dat file with a fixed length format which i would like to use it as a data source. So far i have been unsuccessful since the "Fixed - Al…
-
How to delete folder File Browser in EPM ARCSWe have some folder which were created but now we would like to delete them since it is no longer needed. I couldn't find the option even I have the role as Service Admi…
-
How is period mapping related to periods in the ARCS application?How is period mapping related to periods in the application? I have created periods in the application as part of a yearly activity and set up period mapping in the data…
-
How to avoid duplicate loads of Bank fileSummary: Hi Oracle team We are reaching out regarding an issue we've encountered with ARCS and Data Management. Currently, there is no mechanism in place to prevent the …
-
When setting up a summary reconciliation filter, what does "Balance Exists" represent?I'm setting up a summary reconciliation filter for a Variance Analysis reconciliation (screenshot below). One of the filter options is "Balance Exists." What does "Balan…
-
How to pass 12 months forecast in time format 2024M10 - 2025M09 in one process to DWSummary: Hi all, We are on a monthly basis reporting a 12 months rolling forecast to a Datawarehouse (DW) through the EPM Integration Agent. Date format in DW is like th…Bo Løve Langhorn 23 views 2 comments 0 points Most recent by Al Marciante-Oracle Financial Consolidation and Close