Data Integration
Discussion List
-
Data integration: Export double data if there is a break in yearsHi, we have a DSO FCCS-System. In order to export data we needed to change the 'Data Extract Option' to 'All Data'. With this option the system is using a MDX-Statement …Fabian Bistram 23 views 3 comments 0 points Most recent by Fabian Bistram Financial Consolidation and Close -
Is there REST API or another non-interactive way to change connection details under Data ExchangeSummary: Is there REST API or another non-interactive way to change connection details under Data Exchange in EPM? After each clone from Prod to non-Prod and after nativ…Thoraclus 53 views 8 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Email Data Integration Output File as AttachmentSummary: Email Data Integration Output File as Attachment Content (please ensure you mask any confidential information): We have data export file from Data Integration a… -
EPM Agent Automatic Vs Manual - Neither works when run as ServiceSummary: EPM Agent automatic does not work for scheduled jobs but whereas when set as Manual it works. Is there any issue with Agent running as a service when set to Aut… -
FCCS Data Exchange – How to clear an Attribute value once it has been loaded?Hello everyone, I’m working with Oracle FCCS – Data Exchange mappings and I need clarification on how attribute values can be cleared or removed. Scenario: I am mapping …Alberto Parisella 23 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
Custom MDX Query in a data integration giving errorHello, I am trying to add a custom MDX query to my data integration. I am following the document at https://docs.oracle.com/en/cloud/saas/enterprise-performance-manageme…
-
Slow execution of DELETE FROM TDATASEG_THello, We are experiencing a performance issue in our FCCS environment (Data Integration). The execution of the following query in the backend is taking an unusually lon…MKhade 23 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Error loading Exchange Rates to FCCS Rates Cube via AutomationHello All, I have an Integration defined to load Exchange Rates to the Rates Cube in FCCS from an On-premise Database using EPM Agent, but the rates are failing to expor…Simon Eng 43 views 15 comments 0 points Most recent by Girish Joshi Financial Consolidation and Close
-
Simple Tutorial: Import System Exchange Rates from a File Using Data IntegrationSummary: Please find attached a simple step by step tutorial to import text-based exchange rates to FCCS Rates cube using Data Integration. Tutorial demonstrates how to …Ashutosh Bhatikar-Oracle 23 views 1 comment 2 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Data Load at Parent EntitySummary: There is a requirement to enter data at the parent-level entity. The parent entity is associated with only one shared member. We introduced the shared member be…Yashaswini 33 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
How can we remove shared entities from a Data Management extract?Summary: We need to generate a SOX control from Data Management. Content (required): The shared entities are duplicating the results. We have tried using mapping to filt…Michelle Wagner 123 views 11 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
EPBCS to EPBCS IntegrationSummary: I have to create two EPBCS applications for budgeting and then consolidate the budget in one application. The application will have same number of cubes but the…
-
Numeric Data load Vs All Data Type with Security thereby Amount Vs Data in DM/DESummary: Numeric Data load Vs All Data Type with Security thereby Amount Vs Data in DM/DE Content (please ensure you mask any confidential information): When the integra…
-
Data Exchange using ESS Job errorSummary: ERP Fusion connection using ESS Job gives an error stating "Job could not be triggered with given parameters.Request ID returned is -1" Content (please ensure y… -
FCCS schedule report to be extracted and placed in the DM inbox of FCCS or TRCS ApplicationSummary: We have a requirement where there is a need to extract the FCCS Scheduled reports (FR) and place it in either FCCS inbox or TRCS inbox using EPM Automate or RES… -
What does the HSP_NOLINK value on UDA indicate?There are a handful of accounts that have the HSP_NOLINK value on the UDA. What does HSP_NOLINK indicate? How is this value applied to the UDA on the account since it's …Steven Woods 63 views 3 comments 0 points Most recent by Denitza Krasteva-Oracle Tax Reporting (Direct Tax)
-
Pipeline to run business ruleSummary: How to get variable names used in Business Rules for Pipeline? Content (please ensure you mask any confidential information): We are implementing pipelines in T…
-
NewLoadYTDClosingBalanceInput not working as expected with prior period movementsSummary: For a customer we are encountering issues with balance sheet accounts in combination with the NewLoadYTDClosingBalanceInput substitution variable (YTD Reversal …Tjeerd Huisman 124 views 6 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Error in Initializing Step to HCM Cloud from Data Integration screenDears, We have a custom Workforce Planning Cube in EPBCS. We are trying to directly connect with HCM cloud. The connection was established successfully but is failing in…
-
Elimination in FCCS or TRCS?Summary: Should we run ICP elimination in FCCS or TRCS? Content (please ensure you mask any confidential information): We are implementing both FCCS and TRCS. FCCS will …
-
"Cannot Clear Partial Data. Essbase Error(1260046): Unknown Member Entity" in PCMCSI'm getting "Cannot Clear Partial Data. Essbase Error(1260046): Unknown Member Entity" when using the Replace option in PCMCS data integration, even though the entity ex…Dpanshu 42 views 2 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Member selection does not display members in Integration rule -> Option -> FiltersSummary: Hi everyone, I encounter the following issue regularly in EPCM as well as in Planning. Sometimes the following solves the issue: 1. going to the application doi…Mueller 82 views 5 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Integration from EPM to ERP via BIP report is not workingSummary: Integration from EPM to ERP via BIP report is not working. It errors out in the 1st step with invalid parameters requested Content (please ensure you mask any c…
-
Connection to Google Cloud PlatformSummary: Iam trying to connect to Google Cloud Platform with necessary information having JDBC Driver, URL through EPM Agent and it is failing to extract data with error…
-
FCCS_Mvmts_NetIncome not calculatedSummary: FCCS_Mvmts_NetIncome not calculated for P&L accounts for new entities that started receiving data recently. Data from ERP is loaded at "FCCS_ClosingBalance_Inpu…Rahul Sharma-226069 85 views 11 comments 0 points Most recent by Rahul Sharma-226069 Financial Consolidation and Close
-
Loading by FDMEE - Replace vs MergeSummary: Loading by FDMEE - Replace vs Merge Content (please ensure you mask any confidential information): Hi All, I noticed an issue during Loading Phase by FDMEE. In …Antonio Barbaro 73 views 15 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close -
Pull Dynamic Calc Member with DLRBackground: In FCCS, we currently have a level-0 member of the Account dimension (let's call it Account XYZ), which has a data storage type of "Dynamic Calc and Store". …
-
Cloning Limitation for Data ManagementSummary: Data Management can be cloned only if the source and target environments are on the same monthly update, or if the target is one update ahead of the source. Is …