Category 117
Discussion List
-
ARCS configurationGood morning, I should configure a reconciliation environment with oracle account reconciliation cloud service. Is anyone who knows the environment willing to take away … -
ARM to ARCS migration issueLooking for some help in resolving migration errors I am trying to migrate from ARM to ARCS Import Step 1:The "Common" node artefacts were imported successfully (did not…
-
How to export Views from Reconciliations Page to Data Exchange FolderIs there a way to export saved "Views" from the Reconciliations Page and have it sent outbound to a SFTP Folder using data exchange or otherwise. The goal is to automate…Ketan Kashliwal 11 views 1 comment 1 point Most recent by Komala Reddy-Oracle Account Reconciliation
-
One (1) Data Source Process not providing matchesSummary: I am creating a Transaction Matching Recon between GL and Bank with following Match Processes: - Match Process 1: Betweeen GL and Bank (One to One Mapping) - Ma… -
How do we filter out some matched transactions from balance explanations in custom solutionSummary: How do we fix this issue? We are using a custom solution so that we can match on transactions using functional currency. So, we are using a query and report of …
-
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…
-
How do we match open tolerance adjustments with the GL adjusting journal entries once booked?Summary: We have identified our unreconciled amount in a transaction-matching account is the result of tolerance adjustments that have been made in ARCS that need to be … -
Update number format in ARCSSummary: I have a user whose default number format is ###.###,000 but they need to enter the values in ARCS as ###,###.000. I can't find a number format setting in ARCS.…Jocelyn Hillman 31 views 3 comments 0 points Most recent by Ryan Lunde-Oracle Account Reconciliation
-
Is there any automation for support/Un support transactions in ARCS transact matchingSummary: The requirement is to automatically support transaction with age more than 60 days. Content (please ensure you mask any confidential information): Version (incl…PrinceKumar 51 views 5 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
How to connect ARCS to databaseSummary: How to upload data into ARCS without generating csv file but using a custom table to connect to it directly to load data. (of course by mapping all attributes a… -
Is there any limit for number of invalid mappingsSummary: Is there a limit to the number of invalid mappings shown after the load period in the application (Periods -> Import Data -> Invalid Mappings)? Does the warning…
-
Drill Through on Ending Balance Fails with "Could Not Find Period key for given parameters"Summary: After loading data to an application in ARCS, I'm getting an error when I drill on the Ending Balance in Reconciliation after the load, screenshot below. I have…
-
How to send files as encrypted to EPM ARCS using epmautomate?Summary: How to send files as encrypted to EPM ARCS using epmautomate? Content (please ensure you mask any confidential information): We have a requirement to send files…
-
Is it possible to have matched in Transit transactions details in custom report output?Can we configure a custom report in ARCS that gives output of matched in transit transactions.SAI SAKETH KANCHERLA 11 views 1 comment 0 points Most recent by Kedar Mahajan-Oracle Account Reconciliation
-
Unable to export GroupSummary: Hi. Good day! In 'Manage Groups' tab, the 'Export to CSV' button is not available even if I have already selected the group to be exported. How to enable the bu…
-
There is any epmautomate command to know the status of data load ?Summary: Is there is any epmautomate command to know the status of data load. We need a epmautomate command to add in script to know the status of data load . Content (p…Saritha Mannnajirao 32 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Account Reconciliation
-
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… -
Trying to create a custom calculated AttributeTrying to create a custom calculated Attribute with the below conditions: Attribute : Item Sub-Type Condition 1 : When Item Class is set to Type A, then the Item Sub Typ…
-
Feasibility to automate standard roles and application-level access in ARCS using Rest APISummary: For standard/predefined role (Service administrator, Power User, User, Viewer) access, currently user is manually added to respective AD groups in GAM. For ex- …Sakshi Agrawal 11 views 1 comment 0 points Most recent by Lakshmi Narayana Metla-Oracle Account Reconciliation
-
"Period deleted" in audit logSummary: When I review the Audit logs, I see records which say Period is deleted by Administrator. There is no impact of this action on the recons. I am wondering what i…
-
SmartView is not allowing Japanese Characters to be loadedTrying to do pre-mapped data load using SmartView with data which has Japanese characters but it is failing with an error. How to tackle this special character requireme…
-
Possible to use ARCS to reconcile statistical account balances between ERP and ASO reporting cubes?Summary: Can 'STAT' be added as a currency in ARCS for reconciling statistical account balance between the ERP Financial General Ledger and an ASO reporting cube? Conten… -
Many to Many rule does not function, please helpSummary: Many to Many rule does not function Content (please ensure you mask any confidential information): I tried the auto rules 1 to 1, 1 to many and many to 1. All f… -
Limit on adding members in data load rule filters in account dimensionDear Experts, We are fetching data from Fusion ERP. Over there we have to pull some unique account and that count is near about 93. When we are adding 94th member it's n… -
is there a way to load a specific profile/reconciliation and not reload all datawe often book journals well past when users start reconciling accounts. in the past this has caused the users to lose work as completed recs revert back to open status (…
-
Can VPN be enabled to access the EPM Cloud URL for e.g. ARC(Account Reconciliation) applicationCustomer has a requirement to restrict the ARC application to certain IP addresses for security purposes. Is there a way to restrict the ARC application access to certai…
-
Role provision report returning date for provisioningSummary: The requirement is if the role has been provisioned in EPM ARCS application, e.g. "Data Loads-Manage" then where the "provision date" and "provisioned by" data …
-
Invalid period mappingWhen I try to import balances using "Periods" I get the following error message: "Invalid period mapping. Make sure the period is defined in Data Management Period Mappi…Steven Ballen Pelayo 140 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Encryption EPM Automate/ARCSSummary: How does EPM Automate and ARCS handle encrpted files? 🔒️ Content (required): We have transaction matching files coming in from a cloud service into an SFTP. To … -
could we connect PowerBI directly to Oracle DB via "DirectQuery" to help alleviate some ETL concern?Summary: One of the initial activities involves compiling and dashboarding ARCS data to analyze and present particular findings utilizing Power BI. working with Reconcil…