Data Integration
Discussion List
-
Drill Through Error "No drill-through reports found at this location"Hi everyone, im having the issue related to Dril-through and i already follow alot of steps and still not woking, can someone help by a guide or something related please…Caio Silva 248 views 16 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform -
Which SOC Report includes coverage of Data Integration/Data Manager?Summary: Which SOC report includes coverage of data integration/data manager/data exchange? Content (please ensure you mask any confidential information): Version (inclu… -
In FDMEE, is it possible to limit the access for the metadata (entities) on Data Load Mappings?Summary: We have enabled a Global User to load data into HFM. The requirement is to prevent users from being able to select an entity that they are not allowed to on the…Claudio Caceres M. 22 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
How FCCS calculates Periodic data if we are loading YTD values?How FCCS calculates Periodic data if we are loading YTD values from ERP? Is there any calculations we need to consider ensuring that the data rolls over correctly for ea… -
What options are there for exporting calculated data (ie:parents and member formulas) from ASO cube?Summary: We have a fairly large ASO database, with one of our dimensions containing 193k members. Many of these members are shared members for alternate hierarchies with…Chad Alexander 81 views 10 comments 0 points Most recent by Chad Alexander EPM Platform and Freeform -
Data Management - Essbase Error(1260046) introduced on non-Gen1 ScenariosSummary: An issue appears to have been introduced into EPBCS last night which caused a lot of our Data Management Rules to fail (these have previously been running with …Alan Davey 41 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
Open Batch - Processed file does not appear anymore in the process id's post completionSummary: We are using Open batch to execute certain data loads. Post the data load completion, the files (that are uploaded in open batch folder for data loads) were app…NarayananS 14 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform -
Error Export data to budgetary Control FusionSummary: Hi, I have an error issue when exporting data from PBCS to Budgetary Control. Could you please help me to solved this issue? I have attached the full log as wel…Ruosidah 35 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform -
Email setup and subject setup for email notificationsSummary:We have a requirement where we need to setup an email inbox as a recipient of all emails from the ARCS cloud. We would also need help on setting the subject for … -
Data Exchange Integration - Map one source coulumn to multipleSummary: I am loading data from HCM to Workforce: AS seen below, I want to map Assignment Start Date to OWP_Start Date (employee Start Date), OWP Start Month (Employee S…Ravinder Singh-63390 11 views 5 comments 0 points Most recent by Stu G-Oracle EPM Platform and Freeform -
Data Management recalculate showing in POVWe are noticing a recalculate icon in Data Management production and test environments for Oct only. We have reloaded some prior periods and do not get the recalculate d… -
Direct Data push from EPCM to GL creates records in GL for debit and creditSummary: Direct Data push from EPCM to GL creates records in GL for debit and credit. On what basis are these records created in GL? Need Logic was differentiate debit a…Subhojyoti Chakraborty 11 views 1 comment 0 points Most recent by SureshM-Oracle EPM Platform and Freeform -
How to set up Explicit period mappings vs Default?Summary: Setting up alternate period mapping for specific DLR Content (please ensure you mask any confidential information): I have a requirement to load prior period re… -
Open batch Archive filesSummary: Files Placed in Open Batch files are processed but does not land into Archive folders after processing. Content (required): Files Placed in Open Batch files are… -
Oracle EPBCS Integration Option with Azure DatabricksSummary: General questions on available functionality between Oracle EPBCS Data Integration and Azure databricks Content (required): Specific questions regarding the fun… -
Is it possible to build dimension named "Highest Education Degree" in WFP reporting cubeSummary: Is it possible to build dimension named "Highest Education Degree" in Workforce Planning reporting cube (for demographics) via Data Exchange. I am thinking of p…Ravinder Singh-63390 21 views 7 comments 0 points Most recent by Stu G-Oracle EPM Platform and Freeform -
Data Load rule vs Quick Mode Data RuleSummary: Data Load rule vs Quick Mode Data Rule not behaving same in REST API executions Content (please ensure you mask any confidential information): We are using Quic… -
Groovy CreateFileWriter bug/defect? File generated not located in Outbox.Summary: The Groovy documentation for CreateFileWriter method (https://docs.oracle.com/en/cloud/saas/enterprise-performance-management-common/groov/oracle/epm/api/script…Chad Alexander 51 views 3 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Can we integrate EPBCS with Accounts Payable in a way that drill through would work from EPM to APSummary: Content (please ensure you mask any confidential information): Version (include the version you are using, if applicable): Code Snippet (add any code snippets t… -
Missing File When Using an Export Dimension by Name (EDMCS) Job Type in PipelineSummary: I am testing export Dimension by Name (EDMCS) Job Type in Pipeline. I created EDM connection: https://edmcs-test-domain.epm.****.oraclecloud.com/epm Parameter: … -
Customizing default integration with DFF (Flexfields) between EPM and PPMSummary: Is it possible to adjust "Import Project Actuals" (EPM side) to pick up 2 flexfields from PPM? Customer uses 2 flexfields into PPM (Oracle Project Management) t…HMMgl-Oracle 51 views 2 comments 1 point Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
FDMEE artifact migration issues since 24.02 patchSummary: Since the 24.02 patch we are unable to import snapshots without errors for the FDMEE artifacts. The process we took was: Overview -> Remove application Import f… -
Importing data records surrounded by quoteHello. I'm trying to import data into FCC and the records, while comma delimited, are surrounded by quotes. They look like this: "Account,CostCenter,Amount" So the whole…ericerikson 21 views 4 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
GL to EPCM inbound integration failing with Replace modeSummary: GL to EPCM inbound integration failing with Replace mode for Entity dimension members only. Error message says failing to clear data for Entity members which ar…Bala Vishwa Gautam 51 views 9 comments 0 points Most recent by Pratap Ball EPM Platform and Freeform -
Can a pipeline validate metadata in FCCS?Summary: Can a pipeline validate metadata in FCCS? Content (please ensure you mask any confidential information): I'm building an automation using EPM pipeline to load m…Handel Zhuang 22 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform -
Extract Data with the Full Qualified Name for All AccountsSummary: Content (please ensure you mask any confidential information): Hi All, We are extracting data using the data export feature in data integration and it is extrac…Ayeshan 37 views 3 comments 0 points Most recent by Kyle Goodfriend-Oracle EPM Platform and Freeform -
Data Exchange - Clear Region broke after Jan-24 UpdateHi, Unable to select members from the hierarchy in the 'Clear Region' option in Data Exchange on all DLR's. Anyone else notice this? Our last successful run was Jan 19th…Hyperion_Junkie 61 views 8 comments 0 points Most recent by Hyperion_Junkie EPM Platform and Freeform -
Pipeline Move from Outbox OR Download/Upload File OperationSummary: Pipeline as per 23.09 includes 'Move' from Inbox. Could we know about 'Move' from Outbox? OR Download/Upload File operation availability? Content (required): Pi… -
Pipeline Start and End Period failing though REST API but successful when executed manually.Summary: Pipeline variables for start and end period work properly when executed manually but fail whenever the job is executed through a REST API call. Content: I've cr… -
DLR Members Selected if no Source Filter GivenI have a DLR which is pulling data from an FCCS application to a TRCS application. The DLR has no Source Filter specified for the dimension Data Source. The structure of…annaschmult 51 views 1 comment 0 points Most recent by Randa-Support-Oracle EPM Platform and Freeform