Data load
Discussion List
-
In ARCS application There are two different region and they want to lock the period independentlySummary: In ARCS application There are two different region and they want to lock the period independently Content (please ensure you mask any confidential information):…Sanjay Kumar Patel 25 views 4 comments 0 points Most recent by Sanjay Kumar Patel Account Reconciliation -
Drill through to landing page from ARCS mapping advice neededSummary: How should dimensions be mapped when trying to implement drill through to Data Integration Landing Page for ARCS? Content (please ensure you mask any confidenti…
-
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 64 views 7 comments 0 points Most recent by Dave Jesky-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 …
-
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…
-
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 23 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 171 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 12 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 …