Data Integration
Discussion List
-
Conditional in Source/Target expressionHello there! Where I can find all the possibilities for the Conditional statement in Source/Target expression? In the documentation, there is only one example with the t… -
Using SSO Users or Oauth2 for Connections in Data Integration Planning CloudSummary: We are not allowed to use Native users - SSO from corporate Azure servers are the company policy. Is there a way to use an SSO user also for the connections/ ta… -
Question related to format number - Custom ApplicationSummary: Question related to format number - Custom Application Content (required): HI All, in my FCCS Application, I created a specific Custom Application in order to h…Antonio Barbaro 41 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Object storage namespaceHi I'm interested in using the new Pipeline feature to move files to and from Object Storage. How do I find out the namespace for my respective tenancy? I read the docum…
-
loading exchange rates - Entity is locked.FCCS newbie here. I have been tasked with loading exchange rates to FCC. I have an integration pulling data from a ERP BI Publisher report and loading to the rates cube.…
-
Copy / Recompute Ownership via REST-APISummary Is it possible to do a copy of ownership data and/or a recompute of the ownership data via REST-API?Content Hi all, I'm just trying to automate some things to ge…User_2025-02-03-23-55-06-250 224 views 7 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
how to pull parent level data in the applicationSummary: The issue is w.r.t ectracting data from fccs for Net Income, we are able to extract only base level members (the ones with store or never share data storage pro…_Sanjay_ 81 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data Management - block data importWhen Exporting from Data Management to FCCS receiving error ERROR [AIF]: The rest service request has failed: 400 - {"status":400}. In the target options, when we define…Timestamp EPM Team 21 views 3 comments 0 points Most recent by Timestamp EPM Team Financial Consolidation and Close
-
Drill through to GL Essbase cube using custom data load processSummary: We have decided to proceed with a custom data load process and not use the standard GL adapter to source GL balances. This has led for us to consider a custom d… -
Run Business Rule for All PerriodsSummary: How to Run on demand business rule for all periods Content (required): I want to include business rule that clears budget data for Jan:Dec in a pipeline. Pipeli…Ija Vidaurri 31 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data integration job between Workato Rest API to EPM Cloud not working.Summary: Data integration job between Workato Rest API to EPM Cloud not working. Content (required): We recently migrated ARCS classic to Cloud. now we are establishing …Srinivas Nuthi 21 views 7 comments 0 points Most recent by Omar Shubeilat. EPM Platform and Freeform
-
Removal of Custom ApplicationsSummary: Removal of Custom Applications Content (required): Hi Team, When will the Custom applications be completely removed in FCCS. Please let us know the timeline pla…
-
Drill through integration agent from ERP to FCCSSummary: Hello Experts !! To meet the client requirement where source is ERP on premise and Traget FCCS latest version. Data integration is working fine , challenge is h…AlokPriyadarshi-Oracle 51 views 5 comments 0 points Most recent by Swaraj Vamaravelli Financial Consolidation and Close
-
How to load mutiple currencies from Fusion to EPBCS?Summary: Loading multiple currencies from Fusion to EPBCS Content (required): Hi, we need to load different currencies from Fusion to EPBCS. Can someone assist on how th…
-
How to add a prefix to specific members in Data Load MappingSummary: Having trouble mapping a prefix and no prefix while loading employee data. Content (required): I am trying to load employee data using employee number. In our s… -
How to set data precision when exporting data from ASO through Data ManagementSummary: We are trying to export data from PCM to a flat file using Data Management. Is it possible to restrict the data precision to 2 as the source is an ASO cube Cont…Vikasitha 51 views 3 comments 0 points Most recent by Raama Rao-Oracle Profitability and Cost Management
-
What are the options for data exchange between EPM planning and EPCM moduleSummary: Data exchange between EPM planning and EPCM module Content (required): Currently using EPM Planning and EPCM module for systemization of transfer pricing system…Sucheta Srini 72 views 1 comment 0 points Most recent by NarayananS Profitability and Cost Management
-
The member [NONE] does not exist for the specified cube or you do not have access to it.Summary: The member [NONE] does not exist for the specified cube or you do not have access to it. However, there is nothing in the data load workbench with that value. C…
-
Export Aggregated Data from FCCSSummary: We have issues in exporting aggregated data out of FCCS. even if we point the aggregated level member, the export result in file always shows level 0 data. Cont…Emanuele Panichi 41 views 4 comments 0 points Most recent by DISHIL SHAH Financial Consolidation and Close
-
There is no Fusion Hierarchy Top Node in Options tab in Data Integration ? (Metadata Integration)Summary: There is no Fusion Hierarchy Top Node in Options tab in Data Integration Content (required): Hi , I Would to integrate metadata fusion to pbcs, but there is no …
-
Where is Data management custom application option in Data ExchangeSummary: Where is the Data management "custom application" option in the Data Exchange Content (required): After Oracle replaced data exchange instead of Data Management…Jaiganesh K 31 views 2 comments 0 points Most recent by Thejas Shetty-Oracle EPM Platform and Freeform
-
Data load error messageSummary Data load error message - Data was loaded via Import data in FCCSContent Hi all, Tried to load the data, getting the below information. Here my question is where…
-
Not able to see Hierarchy Top Node in Options tab in Data IntegrationSummary: Trying to setup metadata integration using ERP COA Application Content (required): Not able to see the TREE (Hierarchy) which is created in ERP in option tab. A… -
hardware requirements and the required connectivity requirements for EPM Integration AgentSummary: We need to know what the recommended hardware requirements are for the machine where the EPM Integration Agent will be installed. Additionally, we need to under…
-
When Export error (from GL to FCCS) appears in Data management, can no data be loaded into FCCS?Summary: When Export error (from GL to FCCS) appears in Data management, the successfully exported data can be loaded into FCCS. For those export error lines they cannot…Xu, Angela Menglei 51 views 2 comments 0 points Most recent by Xu, Angela Menglei EPM Platform and Freeform
-
Need a file based integration functionality (automation required)Customer has set of data which needs to be uploaded in FCCS application (budget data) without any manual intervention. SmartView is not helpful here and we have has requ…
-
FCCS - Pipeline - Is it possible to use variables in a 'Business Rule' type jobSummary: I'd like to use variables for the parameters of my business rules. Content (required): I created a pipeline containing one job: 'Translate'. This is a 'business…Julie Belurier 254 views 5 comments 1 point Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Audit Log for Export Method of Data Management/Data IntegrationSummary: Is there any audit log report in Data Management/Data Integration to check export method that is runned by user whether the method is Replace, Merge, etc. Thank…
-
"Data Export to file" option in FCCS is not generating YTD valuesSummary: We have created Target application with application Type of "Data Export to File" in order to extract data from FCCS application and then selected "FCCS_YTD" ag…Harshith J Rao 53 views 1 comment 0 points Most recent by Matt Maurer Financial Consolidation and Close
-
How to Integrate Metadata in Oracle Fusion to be Custom Dimension in Oracle PBCSSummary: I would to ask about integration Oracle Fusion metadata (segment) to be dimension in Oracle PBCS, especially to be a custom dimension 1-4. I Already setup data …