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
-
Loading Bank Balances questionContent Hi, Client wants to load bank balances to perform GL to Bank balance comparisons. They are not using Transaction Matching. Is it possible to use the pre-built BA… -
Duplicate Transactions in Transaction Matching ModuleSummary Is there a way to avoid duplicate transactions loading into the systemContent Presently, if the transactions are already loaded for the day, than in case there i… -
Removing duplicate data loaded into TMSummary Best practice to remove duplicate data from TMContent Hey Guys, Is there any best practice to remove duplicate data loaded into Transaction matching? We have 1-2…
-
Matching Incremental Transactional Reports vs Snapshot Reports using TMSummary Matching Incremental Transactional Reports vs Snapshot Reports using TMContent Hi, This may have a solution already or may become a new feature in the future rel… -
Did you know that you can embed Account Reconciliation artifacts in other systems like ERP Cloud andSummary With direct links, you can add EPM Cloud artifacts to other source system pages; enriching existing processes.Content Use direct links to embed EPM Cloud content… -
Change in Preparer End date(actual) and Reviewer end date(actual)Content Hi all, We are facing an issue with Preparer end date(actual) and reviewer end date(actual) displayed on the reconciliations screen (where all the reconciliation…
-
Importing Organizational UnitsSummary Import CSV file to load Organizational unitsContent Good afternoon, I would like to import a csv file containing Organizational Units instead of entering them ma… -
Bank Cash Account ReconciliationContent Hi Gurus, I have few rudimentary questions related to bank cash account reconciliation. Appreciate if anyone can assist. 1) Do I need to select format as "Bank R…
-
Loading Sub system balances for Group profilesContent Hello ARCS Experts, I am trying to load sub system balance for group profiles using the pre mapped load option but its not allowing me to do that. It just shows …
-
ARCS Transaction Matching “Calculated Attributes” are not showing under "Data Target" in ARCS Data MSummary ARCS Transaction Matching “Calculated Attributes” are not showing under "Data Target" in ARCS Data ManagementContent Hi Team, When we tried to add ARCS Transacti…
-
Posting Adjustment Journals from TM to Oracle FusionContent Hi Team, We have requirement to push the adjustment journals from TM to Oracle Fusion. Based on document available we have completed all configurations in Data M…
-
Recons are getting re opened with reviewer after every Data loadContent Hi, Our closed recons are getting re opened with reviewer 1 every time we run the data loads. We also checked if there was any change in the balance but didn't s…
-
Using Date Condition in Transaction Matching Custom ReportSummary Using Date Condition in Transaction Matching Custom ReportContent I want to restrict the data by a condition like "Transaction Created Date = SYSDATE". How can I… -
Auto reconciliation requirementSummary Key auto recon requirements converting Blackline to ARCSContent * Prevent Auto-submit or Auto-reconciliation if the Unexplained Difference is $1000 OR Greater th…
-
Analyzing Transaction Matches in ReportsSummary Analyzing Transaction Matches in ReportsContent Hi all, on the Account Reconciliation certification the page highlights the topic "Analyzing Transaction Matches … -
EPM Automate command to generate audit reportSummary EPM Automate command to generate audit report in ARCSContent Is there any EPM Automate command in ARCS that we can use to automatically download the audit report…
-
Match Types in Transaction MatchingContent Hi All, I have a general question about the way transaction matching rule types work. Currently, I have the following rule types configured in this order: Many t…
-
NZP for Transaction Matching Import FormatContent Hi All, Has anyone used NZP for a transaction matching import format? My client is missing 46,000 rows in their transaction matching reconciliation because it is…
-
P13 Setup in ARCS - Our Customer has year end adjustments in Period 13(Oracle Fusion Financials) DoContent Hello, P13 Setup in ARCS - Our Customer has year-end adjustments in Period 13(Oracle Fusion Financials) and want to pull over data into ARCS for reconciliation. …
-
Copy forward Prior Ending balance($Total) for Account Analysis recons to Current PeriodContent Hello, I see there is an option to copy forward transaction for Account Analysis recon from the Prior period but it does by an individual transaction. Is there a…
-
Prior Quarter balance % ChangeContent I've created a calculated attribute for Prior Period balance % Change which takes (current period source system balance - prior period source system balance)/ pr…
-
Getting P13 ( CFP ) period data in ARCSSummary Getting P13 ( CFP ) period data in ARCSContent Hi All, I have a query : In ERP I have one period as P13. ( December 31) I want to import P13 in arcs. Solution : …
-
Unexplained Difference Exist , however ARCS shows You have no unexplained differencesSummary Unexplained Difference Exist , however ARCS shows You have no unexplained differencesContent Hi Everyone, Even though an un-explained difference exists the syste…
-
New Cloning FunctionalityContent Hi Team, I tried cloning the prod environment to test using the new cloning functionality but it got failed with message that application version mismatch. So is…
-
Rule to pull forward Balance Explanations based on end dateContent We would like to create a rule that pulls forward all balance explanations if the end date is AFTER the period start date or reconciliation start date. Is there … -
Auto Approve and Auto Submission Rules in Variance Analysis formatSummary Close out Reconciliations when the difference between Current period balance and Previous period balance falls within a particular rangeContent Hi All, We have s…
-
Manually Enter Subledger DetailsContent Hi All, My client has Balance Comparison reconciliations that are grouped with a subledger balance that is entered manually. They would like to manually enter mu… -
Passing Adjustment should not impact the Unexplained differenceSummary Passing Adjustment should not impact the Unexplained differenceContent Hi All, I have a requirement in the Reconciliation Compliance module. Recon has 1.Ending b…
-
Drillback not working properly and contains unnecessary rows of balancesContent I am setting up a direct integration with the Oracle ERP Fusion GL to ARCS. The drillback on balances on the Summary tab of the reconciliation displays the Java …
-
Calculated DatesSummary DATE_DIFF can use 'NOW' or 'TODAY' but can DATE?Content Has anyone had luck creating a calculated attribute in transaction matching using DATE? I'm trying to get…