Data load
Discussion List
-
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… -
ARCS Transaction Matching Data Volume LimitWe are doing a TM implementation with a potentially huge volume of records for monthly matching for one of our insurance customers. We are currently dealing with 3+ mill…Loganathan Nachimuthu 87 views 5 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Ability to create groups in ARCSContent Currently, Client is using the blackline, most of the reconciliation is like they have created groups in black line and they can add any of the accounts they hav…
-
Hi Oracle Support, EPM Automate jobs schedule and Server TimeHi Oracle Support, we would like to seek clarification on an approach that we are currently evaluating. In our current setup, the server where the EPM Automate scripts a…
-
Drill through into the fusion moduleSummary: Consider a scenario where an AP user in Fusion has access to the corresponding AP reconciliation within ARCS. The requirement is not only to drill down to balan…Subramanian Karunamoorthi 43 views 2 comments 0 points Most recent by mohit_mjain Account Reconciliation -
Error in Passing Parameters to a custom BI report through Data ManagementSummary: Unable to integrate ARCS with Fusion using ESS job integration Content (required): Hi All, We are trying to integrate ARCS with Oracle Fusion to pull a custom B…Nilakshi Sarma-194684 273 views 20 comments 0 points Most recent by Kunal Baikar Account Reconciliation
-
How to change the date format in ARCSSummary How to change the date format in ARCSContent Hi All, We are using Data Management to connect to "GL/Fusion" to bring the "PayablBalanceReport" and load into ARCS…
-
Workbench display issueSummary: Workbench display issue after latest EPM update. Content (please ensure you mask any confidential information): After the latest update, records in Workbench ar…Anita Szulc 21 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
ARCS integration with Oracle Fusion Account Analysis ReportWe are using the seeded Account Analysis Report in Oracle Fusion as a source for subledger details, which are integrated into Oracle ARCS. The integration is working as …
-
Maximum Count of Balance Explanations can be loaded into the ARCSSummary: We would like to confirm the maximum number of balance explanations that can be loaded into the ARCS application using the following two approaches: Method 1: U…SAI SAKETH KANCHERLA 19 views 1 comment 2 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Duplicate Balance line item in the balance drill throughSummary: We are currently loading balance data into ARCS in both Entered Currency and Functional Currency. The data load completes successfully; however, when we perform…Subramanian Karunamoorthi 21 views 2 comments 0 points Most recent by Subramanian Karunamoorthi Account Reconciliation
-
Does any one integrate the cash management bank statement and system transactions to the ARCS?Summary: To streamline the reconciliation process, we plan to centralize our data sources within Oracle EPM ARCS. Since bank statements are already uploaded to Oracle ER… -
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. …Asif Mohammad 333 views 4 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Replace newline and special character in DM expression for Transaction matchingSummary: We are currently loading data into Transaction Matching, and the data load process is completing successfully. However, upon reviewing the transactions within t…Subramanian Karunamoorthi 33 views 4 comments 0 points Most recent by Arun Raj Account Reconciliation
-
Forecast data from EPM to GL ScaSummary: Hi, We require to get the forecast data from PBCS - EPM and push it to the scenario i have created in under GL . How can we do this Content (please ensure you m…
-
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 …
-
Can ARC calculate a value in currency on a loaded source balance?Summary: Hi Thank you for all previous support on questions and issues. Question of the day: Can ARC calculate a value in currency on a loaded source balance? Example: I…Ketil Bolstad 25 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Is there a REST API available in ARCS that can identify the Data Load Rule currently being executed?Hello Experts, We are currently facing an Account Locked issue while updating the GIT Tagging column through the ARCS Transactions REST API: URL/arm/rest/v1/dataSources/…
-
With ESS jobs, can we assign only a single value to the parameters configured in the Fusion reports?Summary: We are currently sourcing transactions for ARCS reconciliations through Fusion reports. As part of this requirement, we need the ability to pass multiple values…Subramanian Karunamoorthi 17 views 1 comment 0 points Most recent by Jack Diaz Ponce Account Reconciliation
-
How currency conversation handle in ARCSSummary: In the context of Accounts Payable, vendors may raise invoices in non‑USD currencies, and at month‑end the outstanding liabilities are revalued in the GL. For A…
-
Data load successfully in Exchange but not on to the profileSummary: Most of the accounts profiles are with formats of Account Analysis. Data loads successfully and also assigns the profile in the Data Exchange but I don't see th…Wilson Chelakadan 24 views 3 comments 0 points Most recent by Wilson Chelakadan Account Reconciliation -
How to handle unmatched transactions whose match is a historical transaction not in ARCS?For Transaction Matching, if a transaction is unmatched, and its match exists in historical data not loaded to ARCS, what is best practice for dealing with the unmatched…Steven Woods 31 views 2 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
FCCS Rates to ARCSSummary: Hi, I'm following a video, that shows how to pull FX rates from FCC to ARCS, but I'm having issues, 1- Created the FCC connection in ARCS Data Exchange: 2- Crea…
-
Period Mapping in ARCS for loading FCCS balanceWe are setting up data load rules on the ARCS end to source the balance from FCCS. The rule is querying the source FCCS correctly for the period however its not able 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…
-
FCCS to ARCS - Change 'Entity Currency' to Entity's currency codeSummary: Pulling data from FCCS to ARCS for Intercompany reconciliation compliance balances via data integration - need to map currency code to each entity to translate … -
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 …