Data Integration
Discussion List
-
Direct API based integration between Microsoft Dynamics 365 and Oracle TRCSSummary: We would like to have an API based integration between Microsoft Dynamics 365 and Oracle TRCS. Which does not involve EPM Integration agent. Content (required):…mraghav93 475 views 4 comments 1 point Most recent by Jeelan Banglewale-Oracle Tax Reporting (Direct Tax) -
Is Position Tree Code a mandatory selection in Loading Oracle HCM Cloud Metadata to EPMHello Experts, Hope you are doing well. As per the Oracle documentation it is mentioned that Position tree is needed to bring position metadata to EPM. Please confirm if…
-
SAP S/4 Hana Connector to EPM applications (FCC/EPBCS)Summary: Does Cloud EPM (FCC/EPBCS) have SAP S/4 Hana Connector to pull data & drill through features? Content (please ensure you mask any confidential information): Ver…
-
Building Reports Against the Data Integration SchemaThe Administering Data Integration documentation has a section that provides details of the data integration tables to help build reports. Here is the link to the sectio…ppant ppant 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Unlock by Location does not work in CLOUDSummary: I'm unable to unlock a single location once a period is locked. Steps are as follows: 1) In DM, under Application Settings, choose Target Application and then L…Debbie Schwind 1 view 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
What hampers performance of DLR (data load rule in data exchange)Summary: What hampers performance of DLR (data load rule in data exchange), there are only 6 rows of data.. but it takes 30 mins to push the data Content (please ensure …Subhojyoti Chakraborty 11 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Does 'Calculate Model' pipeline job create POV if it's not created?Summary: Just wanted to know if I pass new POV (which is not created in the application) will it throw an error or will it create new POV automatically in the applicatio… -
Data Integration can only select first 6 target Plan typesSummary: We have a Freeform application with 8 Plan Types. When creating a new data integration to load from a file we can only see the first 6 of them in the target Cub… -
How to export the Data Management/Data Exchange job details using EPMautomate?Summary: How to export the Data Management/Data Exchange job details using EPMautomate? Content (please ensure you mask any confidential information): Client wants to mo…Harshith J Rao 21 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
RestDataGrid error in integration Fusion - EPMSummary: This month, the system gave an error in the transfer of data from ERP to EPM. The error is "RestDataGrid_XXXXXXXX is invalid". I saw other people having the sam…Pieter-Jan Vandendriessche 11 views 4 comments 0 points Most recent by Pieter-Jan Vandendriessche Financial Consolidation and Close
-
Why do the data load process steps vary?Summary: We've noticed that the five steps in the data load process vary. The last step sometimes says "consolidate data for consolidation application mmm-yy" and someti… -
FCC REST API GET Approval unit StatusSummary: Dear Community, We are currently setting up an Oracle EPM FCC instance and need the ability to read the Approval Unit Status for our planned Data Integration. O…Andreas Otto 92 views 7 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
EPM Agent SQL parametersWe have this source query which is working well (see below), but we need to add a bit to update the period value. For example, if the EPM period (~Period~) is 02 then @P…
-
Data Management Mapping question - when two different categories of mapping for the same dimensionI need to set up a Data Management Load rule to transfer data from CPX to FIN cube in a custom Planning application. The source of the mapping must vary based on whether…Partha Sikdar 11 views 3 comments 0 points Most recent by Patrick Northcraft EPM Platform and Freeform
-
What are the recommended steps to follow for closing business operations from one countryHi All, Our client based out from US and is planning to close the UK operations. Can someone please provide what are the recommended steps to follow to close out all the…
-
ORA-00001: unique constraint violated ERRORSummary: We found this error on FCCS Data Integration with ERP CLOUD Content (please ensure you mask any confidential information): From FCCS Data Exchange > Application…Stefano Francese 21 views 2 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close -
Data Management Issue – TB Files Deleted & Mappings RevertingSummary: Is anyone experiencing issues in Data Management where TB files that were uploaded into a folder are being deleted unpredictably, and mappings are unexpectedly …B.Bhandari 21 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
FCCS tables for data similar to HFMSummary: Hi, We have one audit requirement requesting for FCCS schemas, tables, and databases in FCCS which contains data in backend. Do we have anything as such for fcc…Sud VJ 41 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can I use the 'Description' field in a Mapping with SQL Script?Summary: I'd like to use the 'Description' field (available in the workbench) in a SQL script for the mapping. Content (please ensure you mask any confidential informati…
-
Data with natural sign in FCCS (No Flip sign in data management)Hi All, We have a requirement to keep natural sign in FCCS rather than flipping the sign in data management. but the challenge is, If we don't flip the sign, data won't …Ashok_Yadav 21 views 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close
-
Data Management connection with Active Directory UserSummary: Is there a way to user Active Directory User or SSO user to configure data management connection ? Content (please ensure you mask any confidential information)…VineetPathak 12 views 2 comments 0 points Most recent by Jeelan Banglewale-Oracle Financial Consolidation and Close