Data Integration
Discussion List
-
Pipeline File Operations - Disappears after set up and first executionSummary: We are using Pipeline to DELETE a file in POD2, download a file from POD1 and to upload into POD2. It executes for first time but when we close and open it imme…
-
Pipeline skipping stage and not executing all stages of the pipelineSummary: We are using multiple Stages & jobs through pipelines but a certain stage (POD to POD direct data transfer -> Quick Mode rules) is skipped/unrecognized in pipel…
-
Drill through to land in the specific pageSummary: We are using the Drill through functionality, but we have the requirement where the user wants to land on a specific page on the ERP Side using Drill through. C…Narender9971 32 views 1 comment 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
Data integration Export to File Tab Delimiter optionSummary: Data Integration Export to File does not seem to have the tab delimiter option available. Is this available or is there an option we can use to extract tab deli…Dinesh Chand 33 views 4 comments 0 points Most recent by Rajesh Pachiyappan-Oracle EPM Platform and Freeform
-
has anyone connected Oracle EPM agent for Planning to Azure database ?Summary: I am trying to connect Oracle EPM agent to Azure database and trying to load data from Azure DB to cloud Oracle EPM PBCS/EPBCS application ? has anyone done tha…
-
EPM Integration Agent: Connect to Azure DB using Active Directory authentication - Groovy scriptSummary: Using EPM Agent Groovy script (BefExtract) to connect to Azure DB using Active Directory authentication Content (required): I can connect to a Azure DB with AD …
-
Why SYSDATE Parameter is not working in Data Management to pull TM balances till date?The Clients wants to have a Daily Load of Reconciliation Compliance and Transaction Matching profiles. (Format used is Account analysis with Transaction Matching). The R…
-
Pipeline Custom List working mechanismSummary: We are using pipeline specific variables for passing params and works fine when using (substituting) single value for this. When using custom list it allows onl…
-
epmautomate runDataRule using sub varSummary: Hi All, trying to automate data load rule to load the data for last 4 months . Login to cloud url, run clear data run data load rule, it is working fine by hard…
-
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 234 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…JML-820830 83 views 5 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
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 86 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 43 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…
-
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 31 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 12 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 13 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 22 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 54 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 53 views 2 comments 1 point Most recent by M. Kyle Goodfriend-Oracle EPM Platform and Freeform