Data Integration
Discussion List
-
Data Integration with no corresponding source dimensionI am using data integration to move data from Planning to EPCM, can someone please tell me how to set up mapping to a member of a target dimension when there is no corre… -
Bulk delete folders in data exchange file browser or Data ManagementSummary: How to delete multiple empty folders at once in the file browser in Data Exchange? Content We have setup an openbatch pipeline which processes all files placed …Jeroen Goudvis 51 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
API Key Authentication for EPMSummary: We are establishing connection between Oracle Integration Cloud (OIC) & EPM FCCS, and we are using EPM Service Admin ID for this connection. This connection is …Dharanidharan M 41 views 2 comments 0 points Most recent by Dharanidharan M Financial Consolidation and Close
-
Mapping of Dimension based on different data Intersections directly in EPCM ApplicationSummary: Dear Experts, Our Source data is of "No Entity" and we want to map it to proper Entities based on different dimension member combinations (Account → Revenue/ Ex…Sivavignesh V 11 views 2 comments 0 points Most recent by Don Bean-Oracle Profitability and Cost Management
-
Data Management Export Mode Replace doesn't workSummary: Data Management Export Mode Replace doesn't work. When we choose Replace Mode, Scenario/Year/Period/Entity/Mapped Data Source is encountered, the entire combina…J Mahero L 141 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Exchange Pipeline burst NR report across enviornmentsHello Anyone tried executing a Dataexchange pipeline ExecuteBurstdefenition successfully based on below scenario? Pipeline (e.g. Pipe1) is created in POD1 with a connect…
-
EPM Pipeline SubVar to Send Data to ERPSummary: We are trying to use SubVars to manage the Period we are sending data back to ERP from EPM, but we are getting Invalid Start Period error when executing the pro…
-
Data Management - Error when no records presentSummary: Hi Everyone In our implementation when FCCS pulls data from Oracle Fusion, we might have a possibility it returns 0 records or just the header, which is ignored…Mary John-Oracle 91 views 4 comments 0 points Most recent by 1Karen Financial Consolidation and Close
-
Data Integration Inbox FoldersSummary: We are currently transitioning our users from data management to data integration. We are noticing not all inbox folders created in DM are available in data int…
-
EPM Agent ExceptionSummary: EPM Agent has stopped working with the below error: Exception: java.lang.RuntimeException: Error occurred while calling EPMI agent: javax.net.ssl.SSLHandshakeEx… -
Issues while trying to drill back to FCC to EBS (Custom table)Summary: We had configured the EPM Agent is OCI VM and the query is been setup properly to pull the data from the custom table. We had set up the drill URL as well. but …Sudhir_Sinha-Oracle 111 views 5 comments 8 points Most recent by Sudhir_Sinha-Oracle Financial Consolidation and Close -
ERP Closing balances are adding up every monthSummary: We are pulling "Ending Balances" from ERP Cloud every month which is mapped to "Closing Balance Input" in FCCS. For certain accounts instead of calculating Peri…aelahi 101 views 17 comments 0 points Most recent by Jing Xue-Oracle Financial Consolidation and Close
-
Data at Entity Currency is not Populating in Parent Currency or Reporting Currency on ConsolidationSummary: Hi Experts, The data for specific accounts in FCCS is not populating for Entity Currency, Reporting Currency (USD Reporting), and Parent Currency. The data is c…
-
How to get parent child expression for entity dimension in "Data Export to File" Target Application?Summary: How to get parent child expression for entity dimension in "Data Export to File" Content (please ensure you mask any confidential information): we are extractin…Harshith J Rao 61 views 2 comments 0 points Most recent by Jane Wang Financial Consolidation and Close
-
Import data into dynamic calc memberHi! Recently I've got a situation where in the csv file, to import data through Data Exchange, contained some Dynamic Calc members from Account dimension. I expected an …Guido Zanella 51 views 11 comments 0 points Most recent by Guido Zanella Financial Consolidation and Close -
Excluding one particular Level 0 account from Data Exchange exportSummary: Content (please ensure you mask any confidential information): We are exporting data from FCCS data exchange feature to a file. There is a requirement that we d…ShubhamV 131 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Drill Through from FCCS back to JDE through OICSummary: We are Integrating JDE(on-prem) to FCCS using OIC. Here JDE is connected to OIC through JDE Orchestrator using REST API. Also FCCS is connected to OIC using RES…Dharanidharan M 1 view 2 comments 0 points Most recent by Dharanidharan M Financial Consolidation and Close
-
Extract Entity currency through Data ManagementSummary: Hi There, We have created a location in Data Management which uses source as FCCS application(Consol). When we extract the data by running the data load rule wi…Sashidhar Reddy K 21 views 5 comments 1 point Most recent by Sashidhar Reddy K Financial Consolidation and Close
-
Pipeline StartPeriod and EndPeriod VariablesSummary: We would like to use Substitution Variables set at the application level to drive the date values for the StartPeriod & EndPeriod integration from ERP to EPM/PC…
-
Data integration: Is there a way to load/drop a file into Integration inbox using API or GroovySummary: Content (please ensure you mask any confidential information): Hi all Can you let me know if there is a way to load/drop and file into the data integration INBO…NKW 51 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Oracle EPM cloud to AWS Latency issue.We are using EPM integration agent to do writeback from EPM cloud to a data warehouse in AWS. We are seeing significant latency while doing this writeback. The ping test… -
401 error when running data integration in data exchangeSummary: When running a data integration I am receiving a 401 error for the target application. I am using a service account. I verified the service account can log into…