To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Account Reconciliation
Discussion List
-
In Account reconciliation can journals posted as adjustments can be pushed back to source system?Summary: We know that journals can be posted in ARCS but can those journal posted in form of adjustments in ARCS can be auto write back or pushed back directly to source… -
AI Features In Oracle ARCSSummary: ARCS is updated with version 25.11.72, I wanted to understand if AI features are available with this version and if yes what are those features? Content (please…
-
ARCS should auto-update related attributes when store attribute is changed in unmatched screenHello, After loading the data into the system, users can identify invalid stores in unmatched transactions. Only then can they edit and update the store value. If the st…
-
ssh sftpSummary: Using public key auth in copyFromSFTP RestAPI Content (please ensure you mask any confidential information): We are trying to use copyFromSFTP API to copy large…
-
Adding Additional Segments (Cost Center, Intercompany) in ARCS After Go‑LiveSummary: We are currently live in Production with two segments enabled in ARCS for reconciliation. Our client now wants to add two additional segments — Cost Center and …
-
Bulk Close Option Not ShowingWe would like to bulk close test reconciliations that came over to production. We are not seeing the bulk options in the Actions menu drop down on the reconciliations pa…
-
Can we add Journal Source/ Journal Category column/attribute in GL seamless integration to ARCS?Summary: Adding attributes in GL seamless integration for reconciliation compliance. Content (required): We have a requirement of adding a couple of columns/Attributes w…
-
Data Mapping Details for groupsIf in one group there are 10 combinations, out of which 2 combos never had any balances. When users prepare reconciliations, these 2 combos are not visible to them in th…
-
BIPJobExecutable Execution failed with javax.xml.soap.SOAPException: Read timed outSummary: When we call the ESS job to run some of Oracle BIP report we keep getting error due to Read timed out issue. Below is the error log for your information: ####[2…
-
Transaction Matching Balancing Report - confusing when multiple currenciesSummary: I am working on a proof of concept to test feasibility of a customer use-case: reconciliation is a Balance Comparison with Transaction matching, data from both …
-
List of email notificationsSummary: Content (please ensure you mask any confidential information): Hi, Happy new year and thank you for previous support :) Two questions today Question 1: Is there… -
Blank Groups searchBusiness request some re-assignments from one Group to another Group. Sometimes after reassignments group still exist as blank in reconciliation. Is there any way/filter…
-
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…
-
Update ARCs profiles due to COA Name and No change.Summary: When COA names & no. are updated in the ERP system, what is the most effective way to update the corresponding ARCs profiles to reflect these changes while ensu…
-
DFFs not displayed when mapping adjustments from ARCS to a context-sensitive DFF for GL journalsSummary: DFFs not displayed when mapping adjustments from ARCS to a context-sensitive DFF for GL journals Content (please ensure you mask any confidential information): … -
Feedback on Account ID format when source GL accounts that contain dashesSummary: Feedback on Account ID format when source GL accounts that contain dashes Content (please ensure you mask any confidential information): We're currently undergo… -
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 …
-
ARCS new feature for creating pipelinesSummary: Can we create a pipeline for importing pre mapped transaction for reconciliation compliance? Content (please ensure you mask any confidential information): Vers…
-
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…
-
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…
-
Can we import comments in ARCS so that preparers don’t need to enter comments individually for eachCan we import comments in ARCS so that preparers don’t need to enter comments individually for each reconciliation? This would allow them to bulk upload their comments f…
-
Many to Many or Many to 1?I need help deciding whether my rule should be Many‑to‑Many or Many‑to‑1. Scenario: GL Side ID field = TCH Date = same day There are multiple GL transactions for that ID…
-
Is there a report (or list) of all auto-reconciliation rules assigned to each format/all formats?Summary: Our Auditors have requested that we provide them with a report from ARCS (not a screenshot) that shows the relationship between Account -> Profile -> Format -> …
-
Create a new date data attribute under the match type.This attribute should be derived from the existing day attributes :Bank Transaction Date and CH fields. The new data attribute, Grouped Date, should be calculated as fol…
-
Oracle ARCS-archive ARCS to third party archival softwaresSummary: Hi all, We are looking to download data from Oracle ARCS, like Recons, Profiles, Attachments, etc. and archive them to a third party archival softwares like Inf…
-
How to have ARCS rules apply to multiple currency balances within single currency bucket?Summary: For the Entered Currency bucket, a number of reconciliations have multiple currencies that appear in that bucket. For example, in the attached screenshot this r…
-
ARCS Match Rules Help Critical (GL vs Bank)Summary: We are trying to build a Match Rule to match detailed transactions from GL with Bank data. The rule goes as below: Many GL to 1 Bank: GL side : If uid= PAC and …
-
Changes in FX Rates are not reflected in Balance ExplanationsSummary: Reporting Currency for Balance/Variance Explanations do not automatically update when FX rates change Content (required): We have noticed that if there is a bal…
-
Implementing ARCS for first time. Need Help/AdviceSummary: We are wanting to implement ARCS for the first time. Curious if other clients have all used Implementation Partners to complete this or were able to implement b… -
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…