Data load
Discussion List
-
Retrieve "Invalid Mappings" file after Data loadSummary: We are trying to retrieve the "Invalid mappings" file using REST API which will be available below the Result column after doing "Import Data" for a period. Do … -
Loading Daily Balance from GLSummary Automatically scheduling Daily load of balances from GL to ARCS -Balance ReconcilitationContent Hi All Need your suggestion on the configuration Scenario- Client…Som_Mukherjee 100 views 9 comments 0 points Most recent by Vaishnavi Laguduva Account Reconciliation -
Need help with "Map Members" for Dates coming in blankSummary: I am needing assistance mapping a new date column for one of our Transaction Matching sources. I believe I am getting an error due to dates coming in as null an… -
RPAD Function in Data ExchangeSummary: RPAD Function not working in Data Exchange Content (please ensure you mask any confidential information): Hi All, Has anyone successfully used the RPAD function…
-
Functional Currency showing USDSummary: We have a client that wants to load their rec compliance balances into the functional bucket in ARCS. On the rec the functional EUR is blank but the Functional …
-
What is the most efficient way to clear "bad" transactions from TM Module?Summary: We need to determine the most efficient way to clear "bad" Transaction data in the Transaction Matching module for reloading good data so that we don't have to …
-
Add Transaction Matching Target in Data ExchangeSummary: I see in Data Management Transaction Matching is a Target but I don't see this option in Data Exchange. How can I add a TM target in Data Exchange? Content (ple…
-
How to Drill to Subsystem in ARCS?Summary: I'm able to drill to General Ledger in ARCS, however, when I try to drill to Fixed Assets Subsystem, I'm getting 'Error fetching drill url' Where do you setup t…
-
Data load mapping: Two lines showing under All mapping type instead of Like- how did that happen?Summary: We use "Like" mapping type for all of ARCS. Two lines have appeared under type "All" for one of the administrators. How did that occur? We always go to like tab…Nicola Leonard-233642 21 views 1 comment 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
How can I use wildcard in a multi dimension data load mapping?Summary: In Data Management, I want to define the value of the 'Profile' dimension based on two other dimensions (the dimensions 'Segment 4' and 'Segment 8'). Content (p…
-
Drill through from Group Details is showing multiple records instead of only one lineSummary: Drill through from Group Details is showing multiple records instead of only one line, It is showing all transaction contributing to balance available on summar… -
Is there a way to delete matched transactions?Summary: We need to initialize and clear all data from ARCS. Is there a way to delete matched transactions or all the data in the application. Thanks! Content (please en… -
EBS Inventory Subledger to ARCSHi We are trying to load EBS Inventory to ARCS via the Integration Agent and have developed the below query. Similar queries work well enough (we think) for AP, AR and F…
-
How to query ARCS TM Database directly to retrieve warning messages from ARCS TM Job log filesSummary: Hi Team, How to query the ARCS TM (Transaction Matching) Database directly in order to retrieve warning messages from the ARCS TM Job log files. Our aim is to a…Devaraju sabbithi-Oracle 103 views 3 comments 0 points Most recent by Devaraju sabbithi-Oracle Account Reconciliation
-
Need to find GL record count sent to ARCSSummary: Is there an ability to locate the record count from Cloud GL that is sent to ARCS for data load/integration completeness check? Content (please ensure you mask …
-
What are the ARCS standards for loading amounts for transaction matching?.Summary: We are moving Account Reconciliation process from T-Recs to ARCS Oracle EPM. T-Recs handles all amounts as positive and have a field to determine if amount has …
-
ARCS - Data Load Rule Error "DEBUG [AIF]: Error opening Data file"Summary: Data Load Rule Error upon importing file from Inbox Content (required): Hi everyone, I am currently trying to manually import .csv file through Data Load Rule I…
-
Profile Description field is not updating via workato Rest API callSummary: Profile Description field is not updating via workato Rest API call. Source Code: Rest API call entry But ARCS account reconciliation "description" field was no…Srinivas Nuthi 21 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Seeking solution to Data Integration.... where date filed may contain character.Summary: Working on data integration and I'm running into an issue where the Date field may contain characters throwing the error "ORA-00911: invalid characters". Has an…
-
ARCS Data Validation for Source System with ERP for SOX ControlSummary: ARCS Data Validation for Source System Balance with ERP for SOX Control Content (required): Hello Everyone, I would like to ask what best practices are you foll…Karan Varshney 76 views 3 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
integrating balances from Planning cube to ARCS monthly reconciliationswe would like to know if the balance from the any Planning cube can be integrated/reflected in the subledger balance in the ARCS ME reconciliation so that users don’t ha…
-
Generation of log errors for Failed task using EPM automateSummary: I am trying to load data using EPM automate for one of my clients, implementation of Intercompany reconciliation - Transaction matching module, for them the tas…
-
Unable to add transactions - Adjustments to Source systemsSummary: New transactions icon is disabled in Adjustments to source system so user is unable/not allowed to add a transaction. Profile is still Open with Preparer and it…
-
Open Reconciliation Job taking around 12 HrsSummary: We are working on RC project with 300K profiles , The Open reconciliation job triggered after open period and create reconciliation is taking 10+ hours. Content…
-
Loading BAI Files from ERPSummary: Content (required): Hi All, My client is utilizing cash management to reconcile all bank accounts but one, which will be done in ARCS. They are loading BAI file…
-
ARCS Production to test Backup and cloning questions:Summary: ARCS Production to test Backup and cloning questions: Content (required): Our EPM instances are being migrated to a new data center so we have been asked to do …
-
How to calculate Net Accounted Column from Source Data?Summary: Hello All, We are working on AP to GL reconciliation. We have integrated the AP Invoices and AP Payments data successfully. While Integrating GL Data, Source Da…
-
How can we apply a filter when loading balance to reconciliation complianceSummary: We are trying to filter out some of the data in the csv file and load the rest of the data as the balance for a account in Reconciliation compliance. Content (r…
-
EPM ARCS - Data Rule is getting warning statusSummary: Hi Team, In EPM ARCS, After the August patch, In test instance, while executing the data load rule in the Data Management for one "CIP" Location, It is processe…Sesha Sailini 31 views 4 comments 0 points Most recent by Randa-Support-Oracle Account Reconciliation