Data load
Discussion List
-
Hi Everyone - I am getting an error message when I am importing data in Transaction Matching.Summary: I am getting the error message "reconciliation is not valid for this type of match" when I am importing transactions into Transaction Matching. Does anyone have…Bill Stevens - 1234 21 views 2 comments 0 points Most recent by Bill Stevens - 1234 Account Reconciliation -
Data load for a locked period in ARCS applicationHi, In our current data load process, we are loading data for one closed period(Dec) and current open period(Apr). Since, the period (Dec) is closed for data loads to ha…
-
Pulling in Accounts Payable (AP) and Accounts Receivable (AR) transaction detail into ARCSSummary Trying to load AP and AR Subledger Transactions into ARCS systemically via Data ManagementContent I am attempting to leverage the systemic ability to load subled… -
ARCS - Direct Connect with Oracle Cloud ERP SubledgersSummary We are able to Direct Connect to the Oracle Cloud ERP General Ledger. But can we Direct Connect to the Oracle Cloud ERP Subledgers (AR, AP, FA)?Content We have 3…Ed Bennett 238 views 5 comments 1 point Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Do we have out of box subledger reports in ERP to extract data and load in ARCS to perform GL/SubSummary: Content (required):Do we have out of box subledger reports in ERP- Fusion to extract ending balances and load in ARCS to perform GL/Sub in reconciliation compli…Neha Talati-267028 71 views 4 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation
-
Can you push currency exchange rates from FCCS to ARCS? Is there a workaround?Summary: Looking for a way to push/pull/load currency exchange rates from FCC to ARCS. Content (required): We currently use the FCC and Planning applications and are in …Connor Butler 121 views 3 comments 0 points Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
Updates to Fusion ERP Cloud Data Adapter in 21.10Summary: Updates to Fusion ERP Cloud Data Adapter in 21.10 Content (required): Attached file demonstrates how to link a custom ESS Job encapsulating a BIP Report in Fusi…Thejas Shetty-Oracle 61 views 2 comments 1 point Most recent by Arjun Kumanduri-Oracle Account Reconciliation -
What methods are available to extract ARC data tables?Summary: Are there any methods, outside of custom reporting, to extract data from the tables within ARC? Content (required): Our business users have a desire to be able …Braxton Sowell 81 views 6 comments 0 points Most recent by Tim Gaumont-Oracle Account Reconciliation
-
Outbound NACHA/ACH file exportHi, Does ARCS have the ability for an outbound integration of a NACHA or ACH file? The file would consist of balances/transactions pulled from ARCS to send externally to…
-
Why do I not see sub-system balances in Balance Summary after running the data load and import jobs?Summary: No sub-system balances in Balance Summary. Content (please ensure you mask any confidential information): I ran the data load, and the sub-system in the Workben… -
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 … -
Direct integration from Fusion ERP for reconciliation compliance transactionsSummary: Direct integration from Fusion ERP for reconciliation compliance transactions Content (please ensure you mask any confidential information): Hi all, we need to …
-
Reconciliation between balances (ERP) and workbench data (FCCS)Summary: I would like to know the best way to set up a reconciliation between ERP ending balances and a workbench data file from FCCS in order to ensure that mapping bet…Karolina Kawecki 61 views 10 comments 1 point Most recent by Karolina Kawecki Account Reconciliation
-
ARC top level members drill down : Getting error unknown member 1260046Summary: In ARC, we have configure ERP import format such that we are pulling segment values at top level only instead of All descendents. But, whlie Trying to drill thr…DRishabh 41 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Account Reconciliation
-
Is it possible to export excel from data load log/ warning from period screen using APIsSummary: Is it possible to export excel from data load log/ warning from period screen using APIs (Invalid Mappings, Unsupported currencies, etc) Content (please ensure … -
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 231 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…
-
Workaround to schedule data loads in ARCS applicationSummary: Hello EPM Guru's!! Is there any workaround to schedule data loads in ARCS application? We have a use case to schedule the data loads in Linux servers for GL & S…
-
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 105 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 …
-
Load sum of two columns as amountSummary: Hi All, We have a report(flat file) as shown below which has two types of assets. We need to load sum of those assets as amount into Reconciliation Compliance t…