Data Integration
Discussion List
-
In PROD the LoV Period in Data Management > Data Load Mapping is not appear in pop-up windowIn PROD the LoV Period in Data Management > Data Load Mapping is not appear in pop-up window select Point of View and then must setup Period Key in (N) Data Exchange > A…sarahayuputri 21 views 6 comments 0 points Most recent by NarayananS 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… -
HCM 'effective date' and EPM Planning IntegrationSummary: HCM 'effective date' and EPM Planning Integration Content (please ensure you mask any confidential information): I would like to better understand the role of t… -
Netsuite integration to FCCS issues with token expiring after 60 daysSummary: My client has an integration with Netsuite to FCCS which runs fine for about 2 months, then the token appears to be become invalid. Content (please ensure you m…
-
Unable to exclude members based on conditional search from a source filter in EPCM Data ManagementWe are trying to pull only certain cost centers which starts with either "PK*" or "Z0*" etc. but cannot put an Essbase function @MATCH to solve our purpose. However, as …
-
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 25 views 3 comments 0 points Most recent by Lakshmi V-Oracle Financial Consolidation and Close -
FCCS data storage archieval guidanceHello We are seeking official guidance and best practices for managing historical financial data and metadata within Oracle FCCS, specifically as it relates to archiving…Prashanth0302 7 views 0 comments 0 points Started by Prashanth0302 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 27 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 41 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 12 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
-
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 31 views 6 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 526 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…
-
AFCS integration with EPM Cloud FCCSDear All, We have a requirement to load data from AFCS to FCCS for Notes To Accounts. Requesting support to understand best approaches to integrate AFCS (Accounting Foun… -
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 113 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 63 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…