Category 161
Discussion List
-
Can you drill through to multiple currencies?Summary: We have two main reporting currencies that are users leverage, USD_Reporting and EUR_Reporting. I have enabled dill through data back for both currencies, howev… -
How to transform (not map) the Source-Entity column based on another dimensionSummary: I'm trying to find a way to transform the Source-Entity based on another dimension, so that the result can still be mapped after. Content (required): Let's say …
-
Looking for Groovy Scripting samples to achieve File renaming & deletion in the Inbox/ OutboxSummary: We are looking for an automated way to manage the files in the inbox/outbox of the Planning Cloud instances. We are thinking of 3 usecases: keeping more than 1 …
-
EPM 22.04 Data Management JSONObject["Consol"] not found.Summary: EPM 22.04 introduced a bug when integrating FCCS with Planning. When calling a Data Management Extract -> JSONObject["Consol"] not found. There is no such chang… -
EPM Automate createGroups errorSummary: Unable to use createGroups in epmautomate to create groups in bulk Content (required): When using the createGroups command of epmautomate (https://docs.oracle.c…
-
Understanding multisession EPMAutomateSummary: Trying to understand what I need to do to run multiple sessions of EPMAutomate against multiple pods. I need to do this as I have processes that go over multipl…
-
EPMAT-7:Malformed URLSummary: I am at my wits end setting up an additional (new) server to run epmAuotmate. I have epmauotmate running on 3 different servers with no issue, but this new one …
-
Issues with $START_PERIODKEY[YYYY]$: giving wrong yearSummary: I've implemented an integration, where I'm trying to leverage $START_PERIODKEY[YYYY]$ unfortunately for Dec-20 it gives me year 2021 but I would have expected 2…
-
Data Management Range Mapping to Wildcards, possible?Hi All! Is there any way we can have the mapping below with Sql script? Range from 92??-???? to 933?-???? mapped to 92??_???? to 933?_???? Thank you -
EPMAT-7:Malformed URLSummary: I am at my wits end setting up an additional (new) server to run epmAuotmate. I have epmauotmate running on 3 different servers with no issue, but this new one …
-
EPMAutomate: EPMAT-7: Unable to Parse Password File: passwordfile.epw ErrorSummary: Content (required): HI all We get the above error when running a batch file to rename a snapshot. It only fails if the file contains references to log path. if … -
automate start period and end period input when executing DLR in data managementSummary: Content (required): We are currently working on a custom query integration to extract data from a BI report in the ERP side using data management in ARCS. We al…
-
Data Management - Lookup dimension in a metadata load?Is there a way to use a lookup dimension as part of a metadata load? When we tried to set one up for our Projects dimension. It only allowed "Generic" dimension (aka met…
-
What is the frequency of SOC 1 reports issued by Oracle for their Gen 2 EPM Cloud environments?Summary: We are an existing PBCS customer and are in the process of moving from HFM to FCCS. One of our project workstreams is Audit and Compliance and I need to underst… -
How frequently can we clear the 'Data' and 'Logs' folder under application folder for EPMAgent?Summary: Will it affect anything if I delete all the files under 'Data' and 'Logs' folder monthly? Content (required): EPM agent Version (include the version you are usi… -
Data Load Rule with Export Mode is Loading only One Record instead of Two in Data ManagementSummary: We have an integration to load Oracle GL data to Planning Cloud. I came across an issue in Data Management that out of two records for a statistical account onl… -
SSO Azure SAML 2.0 integration with Oracle CloudSummary: Azure SAML 2.0 integration with Oracle Cloud Content (required): Hello, Is it possible to integrate Oracle Cloud Classic with Microsoft Azure SAML 2.0 without u…
-
ERP Cloud BIP Report to EPBCS for loading Account dimension keeps failing!Hi All, I have created a BIP report in ERP Cloud, and while running the integration in data management it keeps failing with the following error: 2022-04-06 09:33:52,266…
-
PBCS integration with Azure Data FactorySummary: Is it possible to do the integration with ADF? In ADF, there is an option to select Oracle Service Cloud. Unable to connect PBCS from ADF using Oracle Service C…
-
EPmAutomate: Download the EPM Activity ReportContent (required): Hi All Ahas anyone tried to download the EPM Activity report using the batch commands? I have found this, but it does not work and seems very lengthy…
-
EPMAUTOMATE exit error querySummary: Hi all We would like to generate an error code number specific for a task. We want EPMAutomate to delete the latest snapshot downloaded from the server to a loc…
-
Is anyone using Workforce Planning Module with 13 period calendar?Summary: Is anyone using Workforce Planning Module with 13 period calendar? If yes, can we get their first hand feedback on how the implementation went and are there maj… -
Introduction of Quick Start Checklists for Oracle Smart View for OfficeSummary: Quick start checklists help you learn how to speed up your first day using Oracle Smart View for Office. Content (required): Wondering how to start using Oracle… -
Data Management file to FCCS - Power users unable to export the data.Hello, We have a group of people as Power Users in FCCS, even though their access to the dimension is fine, while trying to load the file data in Data Management (DM), t…
-
Exporting EPM Dimensional Security to Oracle Autonomous Database (Blog post)Summary: This is a blog post on how to export dimensional and other artefacts' security to Oracle Autonomous database in OCI. Thanks, Omar -
Best practices for updating EPM Integration Agent on Linux platformSummary: Hello experts, I'm looking for best practices of updating EPM Integration Agent on Linux Platform. Content: What are the recommendations to update Integration A… -
How to check EPM Agent Run status on Linux machineSummary: We have configured the EPM Agent in asynchronous mode on OCI box (Linux). We need to monitor Agent run status. Content (required): To Monitor Agent status, we a…
-
Smart View AdHoc analysis error - member xxxx is out of placeSummary: Smart View connected to FCCS but when running an AdHoc analysis an error popped up with: Member Account is out of place. Content (required): Hello, I've encount…
-
EPM Integration Agent Unable to WriteBackSummary: Am trying to Writeback Forecast data from PBCS to On-premise DB and getting error which i am not able to fix. Content (required): Trying to export data from PBC…