Data load
Discussion List
-
Balance Load from ERP is Intermittently Loading Blank ValuesSummary: Automated job to load the previous month's balance data is sometimes loading blank balance information into the mapped recs which causes them to re-open once al… -
Hyperion - Can I use NZP to enable zero for multi-currency-based auto-reconciling issues?Summary: Tool: Hyperion Account Reconciliation Manager Hi, I'm trying to understand how I can use the NZP expression to disable zero suppression in a subledger field. Cu…
-
Restrict Data Exchange / Data Management for power UsersSummary: Is it possible to restrict data exchange or data management for users with power roles? We do not want to grant data exchange or data management permissions to …
-
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 254 views 18 comments 0 points Most recent by Kevin, george Account Reconciliation
-
Workato API data load job failed with Invalid MappingsHi All, We are using Workato Rest API call to upload the GL data from Netsuite to OCI ARCS application. Suddenly job got failed with "Warning:Invalid Mappings" issue. af…
-
Why SYSDATE Parameter is not working in Data Management to pull TM balances till date?The Clients wants to have a Daily Load of Reconciliation Compliance and Transaction Matching profiles. (Format used is Account analysis with Transaction Matching). The R…
-
Transaction Matching Data load replace instead of incremental dataSummary Need to figure out how to replace data loaded into target match type instead of Incremental data loadContent Hey There, So we are trying to load some data into o…
-
Account Mapping doesn't have impact on the profile mappingSummary While Ignoring some accounts in the Account Mapping, Do we need to ignore the same Accounts in profile while doing the profile mapping?Content Please consider yo…Subramanian Karunamoorthi 61 views 9 comments 0 points Most recent by Bharath R Account Reconciliation -
How many match types can be reasonably handled in ARCS?Summary: We have a requirement to have Transaction Matching for several accounts in ARCS, and I'm wondering if this requirement is reasonable. Content (please ensure you…
-
Is there any way to be notified of completeness errors/warnings in ARCS Data loads?Summary: When we perform a data load into ARCS, we are getting some "completeness errors" that are only visible if you go into Periods -> Import Data then view the data …
-
How to get automatch rule status via REST APISummary: Need a way to know whether automatch for all records are successful. How to downloags logs of automatch rule Content (please ensure you mask any confidential in…
-
Fusion ERP Receivables adaptor in Data ManagementSummary This is a short tutorial on using the Fusion ERP Receivables adaptor in Data Management, which was released in 19.10.Content Attached documentThejas Shetty-Oracle 113 views 6 comments 3 points Most recent by Thejas Shetty-Oracle Account Reconciliation -
ImportBalances -EPMAT-7:Invalid or missing parameterI have previously used the ImportBalances EPM Automate command. I am working on an ARCS integration that has daily reconciliations so the ARCS periods are configured as …
-
Multiple DLRSummary: Multiple DLR in Transaction Matching Content (please ensure you mask any confidential information): We have EPM automate scripts for different DLRs for Transact…
-
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 106 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 105 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 …