Data Integration
Discussion List
-
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 32 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 535 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 128 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 41 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 21 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 31 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 64 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 73 views 11 comments 0 points Most recent by Rahul Sharma-226069 Financial Consolidation and Close
-
OWP_Incremental Process Data with Synchronize Definition rule gets executed twiceSummary: I am trying to execute an incremental file adapter–based integration where I have attached the rule “OWP_Incremental Process Data with Synchronize Definition” a…
-
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 …
-
Data Integration Pipeline feature in ARCSSummary: Availability of Data Integration pipeline feature for ARCS Content (required): Currently the data integration pipeline feature is not available in ARCS. Any ide…