Data Integration
Discussion List
-
Planning to FCC load for 12 periodWe have an integration that pulls data from Planning custom to FCC. The process works when we run integration for one month at a time and gives correct numbers in FCC. (…MKhade 31 views 5 comments 0 points Most recent by Dhanasekaran Kasimani-Oracle Financial Consolidation and Close -
How to auto disable user in FCCSSummary: Hi, We have a requirement to auto disable/inactive user in FCCS/OCI. Is there any API or configuration available to fulfill this requirement? We have a requirem…Andika14 31 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
posting journal via data exchangeSummary: Content (please ensure you mask any confidential information): Hi all Can someone please let me know if there is an option to post consolidation journals via Da… -
What setup should perform to enable the drill through to Summary Level in EPM FCCS?Summary: The drill through is working fine in EPM Report but not in data form. Content (please ensure you mask any confidential information): Version (include the versio…User_ZCB13 61 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
FCC integration to SAP BW Hana (On-premise) using EPM Integration AgentSummary: FCC integration to SAP BW Hana (On-premise) using EPM Integration Agent Content (required): We wanted to know if we can connect to On-premise SAP BW Hana using …SenthilSSN 411 views 6 comments 0 points Most recent by Fabio Fiore Financial Consolidation and Close
-
On-Premise File Integration Agent - does not contain a header recordSummary: On-Premise File Integration Agent is not working, log file show 'does not contain a header record', but csv file in epm agent inbox has a header. Content (pleas…AA_AlfonsoGonzalez 22 views 3 comments 0 points Most recent by AA_AlfonsoGonzalez Financial Consolidation and Close -
Creating an outbound integration from FCCS to Third Party SystemSummary: We have a requirement where in we need to run a Report in FCCS and push the output to a third party SFTP. What are the ways to achieve this? Content (please ens…Mandeep Mittal 1 view 1 comment 0 points Most recent by Chansouda-Oracle Financial Consolidation and Close -
Error while running BR with IntegrationWe have added consolidation and transaltion rule with data load rule to consolidation numbers after data load but getting below error for a rule which we have not added …
-
Data exchange export not working from Workbench ActionsSummary: Has anyone else experienced that you cannot export the view data data listing from the Workbench in data exchange/integration? It works if you use Data Manageme…
-
Load ytd values with data managementSummary: Hello everyone, Can we load ytd Data using data management on fccs? Also, if we approve the status of an entity, the loaded will be rejected or not? Many thanks…User_6M4GS 21 views 2 comments 0 points Most recent by LucianoStasi Financial Consolidation and Close
-
Is there any way to restrict load data to FCC for closed monthsI know we have "manage period" page to close month in FCC, This restricts from posting any Journal entries in FCC. But we have a data load process, its file based and we…HarryEPMUser 51 views 5 comments 0 points Most recent by LucianoStasi Financial Consolidation and Close
-
Delete file from inboxSummary: Hi all, i'm facing the following issue while deleting file from inbox/outbox explorer through using REST api from groovy script. "A method called by the script …SRAD 32 views 4 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Load File for PipelineSummary: Currently data load files are being manually imported into Data Exchange and then from there we created a Pipeline and called the Data Exchange job. Is there a …
-
EPM Agent receives job but does not attempt extractSummary: EPM Agent receives job but does not attempt to connect to on premises DB to perform data extract query. We have a single production database on premises that pr…
-
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 31 views 2 comments 0 points Most recent by Dharanidharan M Financial Consolidation and Close
-
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 111 views 12 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
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 81 views 4 comments 0 points Most recent by User_M20FM 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…
-
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 103 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 32 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 112 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 21 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…NK2025 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