Integration
Discussion List
-
How to Create Target/Source System with Data Type HPL?Summary: Hi, I would like to ask, what is the difference in data types between HPL and EPM Local/PBCS? I tried to integrate data using data exchange, but when I choose t… -
EPM agent reconfig after Windows OS Server 2012 upgrade to Windows OS 2019.Summary: Hi I have a question related to EPM agent reconfig after OS 2019 upgrade. The client is going to upgrade their Windows OS from 2012 to Windows OS 2019. Please h…
-
FCC to EPBCS - Error due to P13 Period mappingSummary: Hi All, We are trying the integration between FCC and Planning. But FCC contains data in P13 - period for all the years and planning doesn't have P13 period. So…
-
How to notify users about non-existing members after intégration of data (Data Management) ?Hello All, my best wishes for 2024 ! :) We would like to notify users about non-existing members (errors after Data Integation/Data Management). Could you tell us please… -
Is it possible to integrate metadata with security?Our client imports constrained elements to display historical data, however, it is not authorized to insert new values to those specific elements. Essentially, these ele…
-
Is there a way to Encrypt User's personal data when used via integration?Summary: Content (please ensure you mask any confidential information): Hi all We have a need to move users' personal data from an EPM HR application to Planning. Using … -
How to check the URL used for an integration via Data ExchangeSummary: Hi All, As data management is getting decommissioned, we have been switching to data exchange to handle our integrations. As I need to maintain the URL of a spe…DylanPauwels 37 views 9 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Drill through to specific region from different membersSummary: How to drill through from more than one version member to the same region loaded in DM Content (please ensure you mask any confidential information): Hi, I'm lo… -
Power User Unable to execute data maps.Hi, How can we give Power user access to Data Maps.
-
Run Integration needs FilterSummary: When I run an Integration I first set Start/End Period. It fails unless I click on the "Filters" tab and add the Accounting Period Name, which is the same as th…
-
PBCS dimensions not showing in Data ExchangeSummary: I created a new Planning application. Then I added dimensions and created some forms. I needed another dimension so I added, then enabled it for the Plan Type. …
-
Period/Year not integrating correctly from Oracle Fusion to Oracle EPM CloudAccountingPeriod from Fusion is clearly mapped to Period and Years in Oracle EPM Cloud, however as can be seen in the screenshots below - the amount field is what is com…
-
Pipeline - Custom VariablesHi, Has anyone been able to add a pipeline variable using a custom list to use as an input for jobs? We are trying to replicate the steps outlined in the documentation b… -
Loading Metadata from ERP to EPBCS through Data Management via BI Publisher ReportSummary: Hi, Here we are trying to integrate the ERP Metadata to EPBCS Application through Data Management. Knew we can achieve the above using BI Publisher Report. Woul…
-
Data Integration Export by EndUsers and SSOSummary: Situation: Data Management is currently used to allow 5 dedicated endusers to export Data for their respective entity for 15 different scenarios (categories) an…
-
Pre Build Cannot begin data load. Essbase Error(1003007): Encountered Before All Dimensions SelectedSummary: This problem is on integration hybrid cubes on pre-build oep_fs - as source, and oep_wfp as target. The log error is: Cannot begin data load. Essbase Error(1003… -
Data Management - Calculate data column based on mapped dimension columnHi, I want to calculate a data column based on a LOOKUP dimension that was already calculated with multi-dimension mapping. See below, this LOOKUP Dimension (Conversion)… -
Calculate amount in multicolumn file - Data ManagementSummary: I want to calculate an amount column data in multi-column data rule. Content (please ensure you mask any confidential information): Hi, How can I calculate an a…
-
How to remove/disable SL Ledgers from DIMENSIONS Ledger in Data management?Summary: We are experiencing an issue where users occasionally use SL instead of PL to upload data in Oracle FCCS Data Management, causing problems in the upload process… -
Unable to Update Source System ConnectionSummary: Unable to switch to new source system connection Content (please ensure you mask any confidential information): Our DLRs currently run off source system connect…
-
Practice's to load data from OEP_FS to OEP_WFP?Summary: Load data from OEP_FS to OEP_WFP (using post Allocated/Distribution Actual) from base Expense Amount value to Compensation details (benefit1) in WFP. Content (p…
-
Is it possible for Data Integrator to pass multiple periods to a business rule?Summary: I know that you can pass the POV Period to a business rule as a parameter, but if you are loading multiple periods, this will only pass one period. Is it possib… -
Data Management in Planning does not understand comma as decimal for loaded dataSummary: Content (please ensure you mask any confidential information): Hi All We are having this issue : PBCS: Loading Data With Comma(,) as a Decimal Separator Through…
-
Can the parent of a Planning dimension member be used in the data load mapping logic?Summary: Is it possible when loading the data to lookup the Parent member of the Cost Center coming in from a source (FCCS in this case), and then map to a Child member … -
Can a Planning member's UDA be used in data mapping?Summary: Can an attribute be used in data load mapping logic? e.g. if cost center CC_A has ABC attribute, then map cost center to a planning only cost center. (so that p…
-
power user role data managementSummary: Content (please ensure you mask any confidential information): Hi We want to give access to users to upload files in data exchange. We have given them power use…
-
[Data Integration] the way to import multi multi-column type dataSummary: Hello In Data Management, if members of the same dimension were arranged in columns, data could be imported by having a column definition in the data field at i…
-
Upload metadata via DM with attributesSummary: Hello Experts, I have two CUSTOM dimensions to upload metadata to EPM Planning. These two dimensions are CUSTOM Category and each dimension have different attri… -
report definition not found, running integration pbcs - BI publisherSummary: we were running integration between pbcs and BI publisher, but always encounter 'Report definition not found'. Content (please ensure you mask any confidential …
-
Does Data Exchange require a BSO cube to set up a Dimension target app for loading metadata?Summary: Having an issue with configuring Data Exchange target applications for metadata loads on an app that only has ASO cubes. Does this type of setup require a BSO c…