Data load
Discussion List
-
ARCS There was an error downloading the ESS job log file from UCMSummary: Running fixed asset subledger import from Fusion ERP to ARCS. There is an error downloading the ESS job log file from UCM Content (please ensure you mask any co… -
ARCS transaction matching integrations - how to map period to transaction dateWe have a source file that does not contain a reliable transaction date column. We want all transactions in the file to map to the same date, which would also be the per…
-
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 45 views 5 comments 0 points Most recent by Subramanian Karunamoorthi Account Reconciliation -
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…
-
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 21 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 22 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 158 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 13 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