Data load
Discussion List
-
ARCS Data Management CAMT.053 Load Fails.Summary: We are loading a CAMT.053 bank statement XML file into ARCS Data Management and encountering the following error: Caused by: org.xml.sax.SAXParseException; line… -
Combining GL and SL transactions to create a custom report in the ARCS applicationSummary: We need to combine the GL and SL transactions to generate a custom report. Will it be an appropriate approach for the combined output for the unmatched transact…Subramanian Karunamoorthi 10 views 0 comments 0 points Started by Subramanian Karunamoorthi Account Reconciliation -
ERP OOB Reports for ARCS SL IntegrationHi All, We’re looking for guidance on the best approach for Subledger (SL) integration with Oracle Account Reconciliation Cloud Service (ARCS)—specifically whether to re…Ravali Moramshetty 15 views 1 comment 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
How do match the transactions between GL and SL when GL having both Debit and CreditSummary: We need to match transactions between GL and SL where we are having debit and credit transactions in GL side and SL there is no signage involved in the amount. …
-
Drill through URL from ARCS Data Integration to ERP GL Trial Balance ReportSummary: We have implemented the GL Trial Balance Extract report in Dec 2025, now client is asking for drill through option. I see in the event documentation we have the…
-
Drill through URL from ARCS Data Integration to ERP reportsI need some guidance on what is missing or incorrect in my Drill URLs. I am working on the drill through from ARCS Data Integration to the an out-of-the box ERP report n…
-
Why does the balancing attribute of my data source not appear in the integration mappings?I am using ARCS (Account Reconciliation Cloud Service) specifically for Transaction Matching. I created a Match Type with two data sources, and during the setup of each …Gabriela Fernandez R 25 views 4 comments 0 points Most recent by Gabriela Fernandez R Account Reconciliation
-
ARCS Source Number of Record limitSummary: ARCS Source Number of Record limit Content (please ensure you mask any confidential information): We need to define our integration for ARCS Oracle Subledgers. …
-
How to View Subledger Balance DetailsSummary: I have connected our A/P Trial balance and successfully imported the trial balance report. But even though the overall balance appears on the reconciliation, ho… -
ERROR_INVALID_PERIOD.............. Invalid period specified in the file.I get the following error message when I am trying to execute the data load into Reconciliation Compliance Transactions. From what I have read online, I do know this is …PratikshaBudhwant 149 views 5 comments 0 points Most recent by Sachin Yadav D M 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… -
Configuring Period Mappings to Load BAI Daily but Reconcile MonthlySummary: Configuring Period Mappings to Load BAI Daily but Reconcile Monthly Content (please ensure you mask any confidential information): I'm currently working on deve… -
How to change filename in data load rule in ARCSHi Everyone, We are working on automating data load process through different files daily, we have explored some options but I could not find any option where I can pick…
-
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… -
Source System Balances do not show in RC Recons.Apologies if this is a very Basic question, I am new to ARCS and need help understanding the background process involving . I have setup RC reconciliation for an account… -
Can we bring in data from SAP Datasphere into ARCS?Can we bring in data from SAP Datasphere into ARCS? From what i found in the web, it looks we have to export into flat file and then import it into ARCS. What other opti…
-
Invalid Start Period Error. Period not showing up for Start Period ParameterSummary: Hi All, We are facing an issue while running a Data Load Rule for pulling Balances from Source:Fusion ERP to Target:Reconciliation Compliance Balances. I tried …
-
Transaction Matching\Data Management ExportSummary New Transaction matching export from DM failing on Amount AttributeContent Hello, I'm running into an snag with the Export of Data for transaction mapping from D…
-
Multiple string operations in SQL for Data Exchange failsSummary: Transaction matching process: one of the columns coming from a data source needs some transformation. I need to transform a text value from AAAAAA-BBB format to…Daniela Alexandru-Oracle 11 views 2 comments 0 points Most recent by Daniela Alexandru-Oracle Account Reconciliation
-
ARCS Artifact updatesSummary: ARCS not logging all the data load mapping changes for the Artifact 'Data Load Mapping' updates, we do the data load mapping changes on daily basis, but in few …
-
Is there a limit to number of mappings allowed in Data Exchange?Summary: Is there a max number of mappings allowed by Data Exchange? Content (please ensure you mask any confidential information): Transaction matching process where tr…Daniela Alexandru-Oracle 11 views 3 comments 0 points Most recent by Mike Casey-Oracle Account Reconciliation
-
$START_PERIODKEY$ uses calendar dates, not fiscal.Summary: We use a fiscal calendar in Global Period Mapping, and the Period Key is derived from that fiscal calendar. ARCS is integrated with Oracle ERP reports executed …
-
Discrepancy between workbench data and TDATASEG tableHi Team, I am trying to generate a report for a location. However, while validating the amount values I am seeing 4 cents discrepancy between workbench and TDATASEG tabl…
-
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 2 comments 0 points Most recent by Rimjhim Gupta-Oracle Account Reconciliation
-
Match Type text attribute distorts characters while loading dataSummary: We have several transaction matching daily loads coming from ERP. In these loads, we have text fields such as PO description in which users can pretty much type…
-
How do i properly format this file for data exchangeSummary: Trying to properly map my input file, WIP inventory into the correct accounts. Content (please ensure you mask any confidential information): The input CSV file…
-
ARCS Data load with Snapshot modeSummary: We’re facing a data load issue as described below: Day 1 file: Account ‘12345’ has value 500 Day 2 file: No value for Account ‘12345’ When we load Day 2, the Da…