Data load
Discussion List
-
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 275 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 22 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 15 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 25 views 2 comments 0 points Most recent by Subramanian Karunamoorthi Account Reconciliation -
We are getting "No data exists for data load rules" warning for GL_FCCS job despite successful FCCSSummary: We are getting the following warning after running the GL_FCCS job: "No data exists for data load rules: GL_FCCS_FUNC, GL_FCCS_RPTG. Confirm that Data Integrati…
-
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 24 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 26 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 12 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 32 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 …
-
Historical Data from Blackline into ARCSSummary: Hello, I would like to understand the leading practices for migrating historical data from BlackLine to ARCS. Specifically, I am looking for guidance on: Recomm…
-
In ARCS how to load bank statement file for these format Swift MT950 , MT942, MT199,MT900/MT910.Summary: In ARCS how to load bank statement file for these format Swift MT950 , MT942, MT199,MT900/MT910. Currently ARCS works with BAI/BAI2/Swift MT940 & CAMT0.53 files…
-
Is there any option in Oracle EPM DM or Data Exchange to skip the import or mark the import successSummary: Hello EPM Experts, Is there any option in Oracle EPM Data Management or Data Exchange to skip the import or mark the import as successful when there is no data …
-
ARCS Drill through not showing correct valuesSummary: Hi, We are doing balance comparison rec between GL and Fixed Asset. Both the integrations are direct integration to GL. But when we are doing drill through, it …