Data Integration
Discussion List
-
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 21 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 21 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 42 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 11 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 31 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle Financial Consolidation and Close
-
Data Input at Parent EntitySummary There is requirement where we have to enter data at parent level Entity.Content Hello All, There is requirement in FCC where we have to enter data through custom…Tushant Pandey-151106 544 views 13 comments 0 points Most recent by Yashaswini 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 122 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 46 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 112 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 31 views 2 comments 0 points Most recent by Harish Kumar C Profitability and Cost Management
-
Workbench Data Retention PolicyWe have a business requirement to retain Workbench data (job history, logs, and related artifacts) in EPCM for a minimum of 12 months. We have found no clear Oracle docu…MTipton 34 views 4 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 61 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 71 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 76 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". …