Integration
Discussion List
-
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 31 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… -
Change the 60 day archive limit for Inbox files to 10 daysHi All, in Data Management we would like to change the 60 day archive limit to 10 days for files in the Data Management inbox. Without using groovy or epmautomate script… -
run multi period data integration from BI Publisher Report Extract to pbcsSummary: make dynamic parameter list in data integration between BI Publisher Report Extract and pbcs Content (please ensure you mask any confidential information): hi e…
-
Need delta metadata load from ERP to EPMSummary: We have a requirement to load delta metadata changes from ERP to EPM (Planning module) for Account and a couple of other custom dimensions. We have configured a…
-
What is the maximum value for Data PrecisionSummary: Data Integration job run into an error "EPMFDM-140274:Message - ORA-01438: value larger than specified precision allowed for this column". check the document an…
-
Data Management – Multi Column with Period dimension as driver load rule ignores selected periodSummary Data Management – Multi Column with Period dimension as driver load rule ignores the selected start period and always picks the first data column in the file.Con… -
Data Integration Clear Region and SecuritySummary: Clear Region in Data Integration seems not to reflect Dimension Member Security, Scenario Security (Start/End Period/Year) or other Security like Valid Intersec…