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
-
can we populate Reconciliation RAG from transactions RAG.Summary: Hi, We have to populate Reconciliation RAG from transactions RAG. Scenario 1: Difference is zero, no explanation needed. Reconciliation RAG: Green. Scenario 2: … -
Please ignore this issue is fixed I am not getting option to deletePlease ignore this issue is fixed I am not getting option to delete
-
In ARCS transaction matching, is there a way to view unmatched transactions from a specific date?In ARCS transaction matching, is there a way to go back to a point in time to see what transactions were unmatched at that specific point in time? i.e. Is there a way to…
-
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…
-
Ability to get "Actual" start/end date of next month in ARCSIs there any way to get "Actual" start/end date of next period in ARCS when running certain rules in current period. We do have EDATE function; however it returns value …
-
Issue with Duplicate Balance Display in Reconciliation ViewSummary: Issue with Duplicate Balance Display in Reconciliation View We are experiencing an issue in Oracle Fusion Cloud EPM Account Reconciliation where the balance app… -
Show reconciliation due dates by working day of the monthSummary: Is there a way to see (in report or view) the reconciliations' due dates by working day (e.g., what is due on working day 1, working day 2, etc.) Users would wa…
-
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… -
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 …
-
How to prevent saving a rec with variance explanations in multiple currencies?Is there a way to build a rule that would prevent a user from saving a variance explanation on the primary ledger bucket if they're trying to save it with a different cu…
-
create alert when transaction amount gets updated by preparer in Account Analysis Recs in ARCSHi, We want ARCS system to trigger a notification to users, if the preparer updates the amount for the transactions in the Balance explanation tab. Example: the preparer…
-
Debit & Credit Amounts not populating for an EJ created for amortized balance explanationSummary: I'm encountering an issue when creating an Enterprise Journal from a Balance Explanation that is an amortized entry—specifically, the debit and credit amounts a… -
Profile Segments cannot be created, updated or deleted because profiles exist.Summary: The below warning occurs while we are trying to restore the purged period reconciliations. Could someone please help me if the warning? "Profile Segments cannot…
-
ARCS reconciliations opened without any change in balancesSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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…
-
Unable to generate Custom report in CVS formatted in Transaction matching with total records 221,000Summary: Unable to generate Custom report in "CVS formatted" in Transaction matching with total records 221,000 but report is working fine for csv ..We have total 17 col…
-
What is the transaction size we need to train the modelSummary: We are training the models in the ARCS and getting completion status. We viewed the log and it showed that the sample size is insufficient. What is the transact…
-
Suggestions to handle transactions matched with amount tolerance in Balance Comparison with TMSummary: Hi Experts, I need suggestions to handle matched with tolerance records in Balance Comparison with TM. For Example - GL is $1000 and SL is $995 and matched with… -
Performance Goals consider as an organizational goals while adding through Add New Goal->Library GoaSummary: Hi all—has anyone seen this behavior in Goal Center, and can you help us resolve it? Issue: The same library goal is being classified differently depending on h…
-
Normal Balance Indicator for Consolidated AccountsSummary: Is it possible to add the normal balance indicator at each individual division level instead of just the profile level. For example, if our consolidated account… -
Automate Manual MatchSummary: We are working on setting up environment for AI Agent testing and to prepare the environment we need minimum 2500 matching done. We have list of transactions re…
-
FIELD_ID labels from ARM_HISTORYSummary: Does anyone know how to get the labels (names) for FIELD_ID from the ARM_HISTORY table? The reference doc for ARM_HISTORY mentions: “The field ID which states w… -
Can we configure a custom report in ARCS that gives output of matched in transit transactionsSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t…
-
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…
-
Clarification on numeric codes used in the CREATOR_USER_ROLE column in the FCM_SCHEDULER_JOBS tableSummary: Clarification on numeric codes used in the CREATOR_USER_ROLE column in the FCM_SCHEDULER_JOBS table in Account Reconciliation Cloud. We need the mapping of nume… -
Prevent Editing of Transaction Start Date for Carried-Over Breaks/AdjustmentsSummary: Hello Team, We have a business requirement related to the handling of Transaction Start Date for Carried-Over Breaks/Adjustments. When a transaction (break/adju…
-
SQL query for Fusion Subledger Accounting Hub with Channel Revenue ManagementSummary: Hello, we need to create an SQL query where we have ChRM Program details, Accrual, Claims and Journal Transaction Details: Debit/Credit from Accounting Hub. Can…
-
Source system balances loaded in ARCS from 2 data exchange locationsSummary: For the month of Dec-25, we loaded the usual TB balances as Source System balance. Reconciliations were performed for Dec and closed. As part of P13 a few of th…
-
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…
-
Converted versus Total Currency Type as a filter for interfacing GL balances to ARCSSummary: Converted versus Total Currency Type Content (please ensure you mask any confidential information): We have built a direct integration between ARCS and GL for s…