To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
EPM Platform and Freeform
Discussion List
-
How to export attribute along with data using groovySummary: Dear Groovy Experts, customer has requirement to export data with attributes. Please suggest if anyone has worked on such scenario. Content (please ensure you m… -
[OCI EPM] Add filter functionality in My Applications to find the environmentSummary: [OCI EPM] Add filter functionality in My Applications to find the environment Content (please ensure you mask any confidential information): Currently there is … -
In EPCMCS Smartview Dimension editor is not showing.Hi All, I recently migrated PCM to EPCMCS and while connecting to smartview I'm unable to see the dimension editor to edit metadata from smartview. I have service admin …
-
How to map JGZZ_RECON_REF in ARCS to Fusion GL journal export?Summary: Mapping of Reconciliation Reference (JGZZ_RECON_REF) in ARCS to Fusion GL Journal Export via Data Integration Content (please ensure you mask any confidential i…
-
How to retrieve ASO Incremental Data Slice count via Groovy (EPM Cloud Gen 2)?Hi Experts, I want a Groovy script to programmatically check the current number of incremental data slices. I have explored several avenues to fetch ASO statistic progra… -
Dormant UsersHi All, In IDCS we have dormant users list, is there a way we can export dormant users along with access date field? Also, In IDCS we have prod and test POD users, is th…
-
Can I email a report from PBCS and add a password to protectSummary: I have a PBCS workforce report with sensitive data that I would like to email to recipients and password protect. Is this possible Content (please ensure you ma…
-
Data Integration Purge Data FileSummary: Our EPM application is performing a data file purge for all file-based integrations without distinction, even when this option is configured as 'NO'. I have als…
-
Managing Member Order After Creating or Migrating Members in Smart ViewHi Everyone, When I create new members in Smart View—or when I migrate newly created members from a test environment to production—they always appear at the bottom of th…
-
Account Time Balance Property in Free Form AppSummary: Account Time Balance Property in Free Form App Content (please ensure you mask any confidential information): Is Account Time Balance Property supported in Free…
-
Can you Easily Migrate Prod down to lower Environments without a ton of DM manual intervention?Hi Gurus, We have a client who has a lot of cloud EPM environment. In prod alone there are 9 separate instances (EPCM, EPBCS, FCCS etc). Internal controls has them refre…
-
Oracle EPM Cloud Artifact Snapshot downloads(~200GB) are taking 5–6 hours daily -how can I optimize?Hello everyone, I’m working with Oracle EPM Cloud and need to download the daily Artifact Snapshot for safety/compliance reasons. The snapshot size is around 200 GBs, an…
-
Queries on Fusion and EPM saas DR and backupsSummary: Queries on Fusion and EPM saas DR and backups (Current region- UAE) Content (please ensure you mask any confidential information): Due to the current situation …
-
Average Account Property is Not Working for Some Day of the Week Rollups (Dense)Summary: Average Account Property is Not Working for Parent Rollups of Periods Dimension (Daily rollups) Content (please ensure you mask any confidential information): I…
-
Calling Data Management REST API through scheduling PBC Groovy RuleSummary: We've built an Integration between ERP and PBC. We want to execute this integration every two hours for only a few days during a month. We want to automate this…
-
does EPM support OAuth for SOAP API between EPM applications and between EPM app and non-EPM apps?Summary: We are looking to migrate all connections to OAuth. would EPM support OAuth conn between EPM apps and between EPM and non-EPM apps. Content (please ensure you m…
-
Debits and Credits are in separate columns. How do you load a flat file in this case?Summary: We have a client that uses Quickbooks. The flat file that is being provided for load into Data Integration has a column for debits and a column for credits. Wha…
-
Can we load journal lines from Cloud GL ERP into FCCS using direct integrationIs there a possible way to load journal transactions (as journals or data lines) from ERP to FCCS using direct integration?
-
ASO Calc for Number of Days with Day of the Week Dimension (DOW)-Daily Free Form AppSummary: Need help with ASO Calc for Number of Days with Day of the Week Dimension (DOW)-Daily Free Form App Content (please ensure you mask any confidential information…
-
How to handle a trigger through groovy rule for metadata and security integration pipelineSummary: Hi everyone, I’m evaluating a possible automation in Oracle EPM Cloud (Planning) triggered by a Groovy rule on form save, and I would like to understand whether…
-
Source Period mapping for flat fileSummary: We are exporting data to a CSV file using Groovy, which works correctly. We then created a file-based Data Exchange integration to load the data into Planning, …
-
Data Exchange vs Data Management - Creating Application / Target ApplicationSummary: Fail in setting up Application EPM Cloud Planning Via Data Exchange, no problem in Data management Content (required): Hi, I keep receiving an error when adding…
-
Report Prompt window is not displaying alias from Custom Alias Table in PlanningSummary: Report Prompt window→ Member Selection window→ displaying alias of Default Alias table instead of Custom Alias Table in Planning. We have a Custom Alias table o… -
Incorporate Reports as Dashboards in EPBCSHi All, I know most of the functionality that report gives in Planning the data form cannot, but the dashboards are based on data form, is there a way we can get report …
-
Need Help to Calc Number of Days for Daily CubeSummary: Need Help to Calc Number of Days for Daily Cube Content (please ensure you mask any confidential information): I need to calculate number of days but it is not …
-
Conditional formula in ReportHello, Is it possible to have conditional formula in Reports? Customer wants the formula be same for Qtr1, Qtr2, Qtr3 and different formula for Qtr4. Thanks,
-
Clarification on IPM Advanced Predictions Architecture and OCI Data Science IntegrationHi all, I’m looking for clarification on how IPM Advanced Predictions in Oracle EPM Cloud integrates with OCI Data Science. Oracle documentation mentions that the featur…
-
Oracle JDK compatibilitySummary: Oracle JDK 11 or Oracle JDK 21 compatibility Content (please ensure you mask any confidential information): Currently we have Open JDK11 Redhat so we are planni…
-
TB Data Export for All Location in on GoSummary: Hi, We are in process of Implementing the FCCS to replace existing HFM Solution. in on prim Environment we had feasibility of querying the FDMEE Staging data us…
-
Oracle_SSN_DLM_02271554Summary: Getting the following error when trying to download oracle smartview for office version 25.200 An error occurred while attempting to load items Content (please …