PBCS
Discussion List
-
Variance Percentage formula is showing #error if there is no DataSummary: Hi Folks, I have added Variance Percentage formula to the form and I'm doing actual and forecast variance %. But it is showing #error when there is no data. How… -
How to Download exported data file using API?Summary: I need to down load file from EPBCS to my local computer using RestAPI Content (required): I have exported data using export Job and it is available in inbox/ou…
-
Data Management error - Essbase Error(1003007): Data Value **** Encountered Before All Dimensions SelSummary I'm trying to create a dataload rule but it returning an error "Essbase Error(1003007): Data Value [****] Encountered Before All Dimensions Selected"Content Hey …
-
EMP Agent update query to on-premise databaseSummary: Integration EPM Agent to on-premise Database using update not insert Content (please ensure you mask any confidential information): Hi everyone, Currently, I ha…
-
How EPM Projects work with ERP Project ManagementSummary: EPM Projects process flow with ERP Project Management Content (please ensure you mask any confidential information): Hi Experts, We are going to be implementing…Parmit Choudhury-Deloitte 11 views 2 comments 0 points Most recent by Rajesh Pachiyappan-Oracle Planning
-
get attribute values associated with a member using groovySummary: I'm trying to get the attributes value associated with a member. But somehow I'm unable to make it work. I need the value to be stored in some variable for furt…Subhojyoti Chakraborty 342 views 2 comments 0 points Most recent by M. Kyle Goodfriend-Oracle Planning
-
Course for Business Rule WritingSummary: Content (please ensure you mask any confidential information): I am looking for recommendations of courses which offer Calculation Manager training. I have a go… -
Password Expiry DateDear All, Please let me know how do I know in advance about a user whose password is going to expire on so and so date ? Where can I check this ? We have some admin /bat…
-
In Redwood theme update what we needs to test in the EPM applicationsOracle recently update the Redwood theme to all EPM applications. can you please provide the list thing what we have to test on this update.ActuallyGopu 101 views 10 comments 0 points Most recent by Ashutosh Bhatikar-Oracle EPM Platform and Freeform
-
Working functionality of LOOP/ARRAY in Business RuleSummary: Is there any way to use Loop or Arrays which will take multiple RTP variables as parameter and perform calculations for each RTP within the loop? Content (pleas…
-
How to get JOB ID to use it for REST API to extract role assignment reportHow to get JOB ID to use it for REST API to extract role assignment report?
-
List the user in the JobsSummary: How do I show the user on a Job Content (please ensure you mask any confidential information): In the Jobs recent activity list, can I set it to show the user? …
-
support for EPM automate and Integration Agent in 3rd Party Virtualized EnvironmentsSummary: Hello we're going to install EPM automate and Integration Agent to arrange data exchange with our EPm Cloud (Planning) on Microsoft Windows 2019 or 2022. Do you…
-
Allocation ExampleSummary: Need to allocate by department from one entity to multiple others. Content (please ensure you mask any confidential information): I'm looking for a good example…
-
Convert value of SmartList to member to use in cross-dimensional (Non-Groovy)Hello experts, I have an account linked to smartlist where I have "account values" to choose in this smartlist, like this: For each entity (on columns) and dimension flo… -
Copy a dynamic calc parent member to a stored base level memberSummary: Need to copy a dynamic calc member to a stored base member Content (please ensure you mask any confidential information): I have a roll up (below) in a sparse d…
-
CurrentPOV not AvailableSummary: Content (please ensure you mask any confidential information): In Reports, I don't see CurrentPOV in the function list. Is there some setting I need to turn on?…
-
Drill through from planning to ERP cloud GL balances failingSummary: When trying to drill through to source, either from a data form, workbench or smart view, I'm only getting a blank browser page. Content (please ensure you mask… -
EPBCS time balance property not working on dynamic calc parentHi All, I have a balance sheet account(level0 stored) in OOTB financials module with properties = (Account Type: Asset, Time Balance: Balance, Skip: Missing) From Plan E…
-
Data Erased by Hierarchy Change?Summary After adding a roll up to existing members all level 0 data for those members was erasedContent We added 3 new roll ups to our existing Finance and Facilities co… -
How to print or use substitution variables in Groovy for ASO cubeSummary: I had a requirement where I need to extract data from ASO cube montly, I created Sub Var in ASO cube for period and year trying to call those in groovy but scri…
-
Ledger Id Missing When Trying to Write Back ActualsSummary: Getting the following error when when trying to write back actuals to ERP, it is happening on the Import Journals job in ERP. "Warning: Ledger Id can not be emp…
-
Optimizing Allocate RuleHello experts, I have a doubt with a calc script doing an allocation. Type my code and explain if is possible optimize this code: FIX (&Act_Year,"Actual","EUR",@RELATIVE…
-
Member Selection in a Business Rule Shows Account List Not HierarchySummary: Would like to have the member selection show as a hierarchy, not a list Content (please ensure you mask any confidential information): We have a prompt to selec…
-
Planning PBCS: Intercompany Elimination best PracticesSummary: Developing in Planning an Intercompany Elimination process. Content (please ensure you mask any confidential information): Hi, We are developing an intercompany…
-
Do your data forms with year-to-date view work as expected?Summary: We have always used year-to-date view in data forms and reports. We normally use the member formula on member VS_YTD, as posted on the Oracle documentation, SUM…
-
How to display top n customers by revenue in data forms in planning cloudSummary: How to display Top n customers in data forms in Planning Cloud by Net Revenue or Gross Revenue. Customer is a dimension. Content (please ensure you mask any con…
-
hide rows in a pbcs formHello Experts! I have a form that I would like to supress rows that contains "almost" zero. I click on option supress missing / zero rows but in my example doesn't work …
-
Can we connect REST API to PBCS ApplicationSummary: we have requirement to extract data from PBCS Application using REST API, is there possibility for the external tools like Talend or BOOMI to connect to the Dat…
-
How to run the calculation in detailed logging mode?Summary: We are running into errors like "Error executing formula for [StaffEntry] (line 764): attempt to cross a null member in function [@X]" Found Doc ID 2191610.1. I…