Category 101
Discussion List
-
Why doesn't leaf level data in financial forms, roll up to top level dimensions?Summary: We have data uploaded for plan and actuals in financials at leaf level. When we select the specific POV we can see the data uploaded, but when we filter for top…
-
Has the logic behind dimensional security on shared members changed?Summary: Security logic that we have always used in the past successfully doesn't work any longer Content (please ensure you mask any confidential information): In our o…
-
Missing LinkForm and Explainability function when opening forms via Task ManagerSummary: When I open a form from Task Manager, the LinkForm and Explainability options are missing from the options list. Opening the same form from the Data section sho…
-
Issue with Thousand Separator in Multi-Column All Data Type Rule in Data ManagementSummary: Content (please ensure you mask any confidential information): Hi all, I’m working with Oracle EPBCS Data Management and running into an issue with thousand sep…
-
Can Oracle Rest APIs be used to export/import data and metadata (dimensions)?Summary: Can Oracle Rest APIs be used to export/import data and metadata (dimensions) to/from Planning and other database types (i.e PowerBI as an example)? I have revie…
-
How to use @SHIFT(@CurrMBR in a crossdimI am trying to write a calc in calculation manager which will return a different value based on 3 different situations depending on the Period (i.e. "Jan") in the IF sta…
-
How to Check if member from Plan1 exist in Plan2?Summary: Problem : Customer is copying data from one plan to another plan in planning application. Now some dimension member do not exist in target plan type. Do we have…
-
New Groovy Engine EnquiryWe came across the following Oracle notification: "A future version of the Groovy engine, which is planned for the second half of 2025, has stricter validation rules tha…
-
Groovy script to Validate comment entered through data formSummary: Hi, I am new to groovy BR. I am working on Groovy BR to validate "comment" entered by user using data form. A member with "Text" data type is used in data form …
-
How to hide #noaccess and display data for users in EPBCS formsSummary: In EPBCS we are using Cell level security to restrict access for certain intersections based on security groups. However, we noticed a strange behavior: When us…
-
Restrict Users to run specific DLRsSummary: Is there any way to restrict users to run specific DLR in EPM FCCS. For example, only User under Group A should be able to execute the DLR_A . Content (please e…
-
"Page members combination larger than long max range. " - WebformSummary: When try to open a form there is a error "Page members combination larger than long max range." Content (please ensure you mask any confidential information): T…
-
Missing Previous Owner and Last Action information in the approval notification emailSummary: When we approve the parent entity via Approvals (e.g. promote data at Group level), the email notification received by the user is missing the previous owner an…
-
Automation Mechanism for Approval Status SynchronizationHi Gurus, I am seeking an automation mechanism that will allow the approval status of an entity in PBCS to change based on the approval status of the same entity in FCCS…
-
Transfer file from a unix server to EPM cloud aplllication using copyfromSFTPSummary: There is a requirement to pull files from Unix server to EPM cloud application. Is it possible to meet the requirement using EPMAUTOMATE copyfromSFTP command. I…
-
How to exclude intersections of different dimensional membersSummary: How to exclude an intersection of different dimensions within a FIX statement? see example below Content (required): Calc Script: In the FIX Statement is the wh…
-
"Unknown Member used in query" error in Data Load RuleSummary: I am updating the Source Filter in an EPBCS data load rule, changing the spec for Accounts, but even using the member selector to ensure correct spelling, I am …
-
Failed Member context on shared members to open formSummary: Forms doesn't get the member context on page forms for shared members Content (please ensure you mask any confidential information): Hello, I have faced this is…
-
NetSuite PBCS, Form 2.0, no Drill Through?Summary: Content (please ensure you mask any confidential information): Hi, We are working on NetSuite PBCS, with Form 2.0, with the cells which indicates there is a Dri…
-
How to write csv file with groovy rule without adding Byte Order Mark (BOM)I am trying to create a csv file with groovy rule. All went well, except this created file contains byte-order mark (BOM), which is not needed. Automation is sending thi…
-
Functionality to defer Scenario Roll forward for Predictive Cash forecastFor Predictive Cash Forecasting module of EPBCS - As per the current process - the system rolls forwards the application substitution variables during daily maintenance …
-
Do we need a new instance for Predictive Cash Forecasting?Hi, We already have existing EPBCS application enabled with Module Type and as per business need to we are planning to enable Predictive Cash Forecasting in the same ins…
-
EPM to PPM project exportSummary: We are trying to export approved projects (created in EPM) to the PPM. The process is showing success in EPM, but no projects are being created in PPM. Content …
-
Account with two pass and stored formula is not pulling data at the Year Total levelSummary: We have many % accounts that have stored formula with two pass. a. When we pull these accounts vs year total at top level of other stored dimensions, they popul…
-
Can the EPM Project Export to PPM Be Updated to Send Additional Fields? Can Scripts be Updated?Summary: I'm working on implementing the OOB integration to integrate approved projects between EPM and PPM (Project Management). The integration works. However, I need …
-
EPM Project export to PPM fails on business rules not executing? How do I find which rules are used?Summary: I have created a capital project in EPM Planning Projects. When I run Export Projects in Data Exchange the process ends in error. The logfile mentions one or mo…
-
EPM Workforce - partial payment factor gets overwritten by the monthly HCM loadSummary: Process Loaded data rule copies OWP_Partial Payment Factor from the the loaded period into all future periods, hence overrides EPM Workforce direct data entry. …
-
Multi-Column load is not picking up data for the last few columnsSummary: Content (please ensure you mask any confidential information): Hi, We do a revenue file load using the data integration. The integration is setup as Multi-colum…
-
Clear Budget in budget control cube ERP (XCC_) before loading a new budget dataHello everyone, We are pushing our approved budgets from Planning to Budgetary Control Cube. There are cases where we are supposed to clear Budgetary Control cube data b…
-
How to turn on Predictive Cash Forecasting in EPM PlanningHello, I am trying to turn on Predictive Cash Forecasting in our EPM Planning Test Environment. When I go to Application > Configure I don't see it as an option. How do …