Data Integration
Discussion List
-
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 101 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 102 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 35 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 91 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 24 views 5 comments 1 point Most recent by Sashidhar Reddy Financial Consolidation and Close
-
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…Nkehli 51 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCCS delete method in groovy script returns errorWe have a requirement to delete members in Accounts dimension via a groovy script. However the delete() method returns an error stating it is not allowed. We've been abl…Randy Haight 11 views 1 comment 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Retained Earnings Prior balance becomes zero when data is loaded in current periodSummary: Current year Retained Earning Prior is successfully populating from previous year Retained yearning CB. However when data is loaded in current year, Retained ea…
-
Enabled Pipeline Execution for non-admin users but it is not working.We have Enabled Pipeline Execution for non-admin users but it is not working. When logged in as a user, we are unable to see the Pipeline job in Data Exchange. We follow…Mamtha Deepak 21 views 4 comments 0 points Most recent by Mamtha Deepak Financial Consolidation and Close
-
Data Management folder securitySummary: We would need a security on Data Load Rule folder in Data Management for TXT files Content (please ensure you mask any confidential information): Dear Experts, …Stefano Francese 31 views 6 comments 0 points Most recent by Stefano Francese Financial Consolidation and Close
-
Disable/Skip/Mark as dummy for a particular stage or a job in a pipelineSummary: We would like Oracle to add a functionality to disable/skip/mark dummy a particular stage or a job in a pipeline across all Oracle EPM Cloud applications Conten…Priyesh P. Rane 21 views 5 comments 1 point Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Drill through to data source using Apache Web serverWe are trying to drill through from FCCS to SQL Database for that we have configured the Apache Web server but still, we are not able to achieve so could you please help…Prem Siva Kumar Reddy Rami Reddy 11 views 1 comment 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
Direct Drill through passing fully qualified name in FCCSummary: Hello Experts, The drill through report which was configured to pull back the data from relational database is sending fully qualified entity and cost center me…Swaraj Vamaravelli 32 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close
-
DM in FCCS - how to enable folder level access by locationSummary: in FDMEE on prem we were able to setup folder level access so that every user assigned to a specific location, could only see the folder for that location. what…Emanuele Panichi 92 views 7 comments 0 points Most recent by Nkehli Financial Consolidation and Close
-
FCCS & Data Integration Export of YTD data from FCCS to Planning using DM does not workSummary: Content (please ensure you mask any confidential information): Hi all Can someone let me know if I am missing something in my current configuration to enable YT…
-
Needing to import data through Data Integration from file with source amount in EUR format (.,)Summary: needing to import data in EUR format (comma as decimal separator) Content (please ensure you mask any confidential information): I have a data file to import in…Gianluca Natili 61 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Extract YTD Data using Data Extract via overview Extract DataSummary: Content (please ensure you mask any confidential information): Hi all Can someone let me know the exact reason why we cannot extract YTD data via Overview -? ex…Nkehli 61 views 16 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Management automatically delete TB files after running Data Load RuleI notice that TB file (csv) getting deleted automatically in Data Management Inbox folder, post running DLR manually. Please advise how to retain the file in Inbox folderdkr_epm1 2 views 2 comments 0 points Most recent by SureshM-Oracle Financial Consolidation and Close
-
Duplicate/Double Value ERP in FCCS WorkbenchSummary: Hi All, I would like to ask about duplicate/double data values from ERP to FCCS. I have already set up specific filters and used the qualified name. In ERP, the…Ruosidah 51 views 5 comments 0 points Most recent by Rahul G.-Oracle Financial Consolidation and Close
-
Mapping load automationIs there any API/EPM Auotmate command available to automate mapping load in Data Integration? We are maintaining mappings in EDM and sending it to FCC.
-
loading to FCCS to a different currency via Data ManagementSummary: Content (required): I have a location set up in data management to load FX rates from Oracle ERP to FCCS. I cannot get the data to load to the correct target cu…
-
Scenario, Period and Years not in Export (dat) FileSummary: We have an integration between FCCS and TRCS to send actuals data. Integration was working fine. We adapted the integration to send YTD data and then we notifce…Julie Belurier 31 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Can FCCS send data to HFM using EPM Integration Agent.Summary: There is a requirement to send the FCCS data (subsidiary data) to HFM (parent group), is the same possible using EPM integration agent or using any other featur…AditiKavdia 12 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Need to find users who loaded data to FCCS with Merge export modeSummary: We have a scheduled job which sets the default export mode as Replace for all Data Management locations, which runs after the patch is applied this month. Howev…Ryan DeFilippi 11 views 2 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
not able to load data for unlocked entitySummary: we are trying to load data from a Oracle EBS source sytem the file has multiple enities some of them and locked in FCC and some are not. I am not able to load a…Ashish Mishra-169689 51 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How to get the account description from ERP Source in FCCS Data managementSummary: How can we get the account description from ERP Cloud Source in FCCS Data management. Content (please ensure you mask any confidential information): Version (in…aelahi 15 views 5 comments 0 points Most recent by Randa-Support-Oracle Financial Consolidation and Close
-
FCCS Integration with ERP Issue,RuntimeError: No periods were identified for loading data into tableHi All, I would like to inquire about this error: "I received the log message 'RuntimeError: No periods were identified for loading data into table 'TDATASEG'.' " I have…