EPBCS
Discussion List
-
EPBCS - How to check the last run details of business rulesSummary: We have many rules and would like to check last execution of rules in planning application to determine to delete the unused rules. I have checked job logs and … -
EPBCS - How many days of jobs information is presented under JOB consoleSummary: Currently I am able to extract jobs details from April 2022 to till date from the EPBC application. Before April, we dont see the jobs details in the applicatio…
-
Seeding data / Archiving data in ASO CubesWe have to do various data copies in our ASO Cubes. We have to seed actual data into Forecast, and do standard Version copying (Working -> 3+9 for example). As we know, …
-
Scheduling of excel version of HFRSummary: Hello, Is it possible to schedule the HFR in excel? Most of customers are prefer excel version of report over pdf or html view. Content (required): Version (inc…
-
check whether member is descendant of any parent in groovySummary: how to find the the member is a descendant of any parent in groovy Content (required): How can we check whether selected member from pov is a descendant of any …
-
Planning and Forecast PreparationSummary: We provide support to two separate companies within one Oracle EPBCS instance, Is there a way to bifurcate the Planning and Forecast Preparation calendar? Conte…
-
Member Formula for to Date for a View DimensionSummary: Greetings, I have a need to create member formulas for members within a View dimension (MTD, QTD, YTD, YTD[Year to Go]). Content (required): The databases will … -
Will switching to Hybrid BSO speed up retrieval time significantly?Summary: Slow retrieval time (including running web studio reports, forms, smartview) and calc mgr rule performance from existing BSO cubes. Content (required): Will upg…
-
Applying custom Time Balance PropertyHello Experts, Could you please suggest best way to apply custom Time Balance Property for a member from account dim? This means, account member when retrieved on Full Y… -
Creating automated data extractsSummary: I have several EPBCS cubes that are being used for data input and a consolidated Essbase cube that is primarily used for reporting. EPBCS groups have different …
-
Partial Security in one cube and full access in otherSummary: Requirement: in the planning cube (BSO) we want to restrict security to users to only have access to parts of the department dimension and no access to the rest…Jonathan A Cohen 31 views 12 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning -
get a parent members in a list for list of lvl0 members in groovySummary: get a parent members in a list for list of lvl0 members in groovy Content (required): I have lvl0 members in list extracted from flexform need to create another…
-
EPBCS: How to download Static Excel report generated from Reports?In the old FR (Financial Reports), you could burst a report to the inbox\outbox and then use EPM Automate to download it from there. With (new) Reports, I can burst the … -
401 Authorization Error: https://epm-<TENANT_NAME>.epm.us6.oraclecloud.com/interop/rest/v3Summary: When using postman, issues with authorization when calling endpoint, https://epm-.epm.us6.oraclecloud.com/interop/rest/v3 Content (required): Hello, When using …
-
AncestorAlias function in Management Report.Summary: Content (required): Hello, We have a requirement where client wants to see the level 4 on first column, level 3 on the second column and so on till level 0. I t…
-
OOTB Workforce - Basic SalarySummary: Spread basic salary into months based on calendar days Content (required): The requirement in our project is to spread annual salary based on calendar days, eg …
-
Oracle GL ERP to Planning Cloud Error. The rest service request has failed: 404 Not FoundSummary: In trying to connect Oracle GL ERP to Oracle Planning Cloud. The service account created is not connecting. Erroring out. The roles are custom with the roles: G…
-
Data management processing insert/delete statementSummary: We are loading two large files, one file takes significantly more time. Content (required): For a customer we are loading actual files per month with a large nu…
-
Inbox/Outbox Explorer - Retention PolicyHi, Was curious if anyone has details on the inbox/outbox explorer file retention policy. Is it in conjunction with the 60 days / 150 GB cap that is referenced for snaps… -
How can I convert a member to a string to populate a Smart List value?Summary: I am trying to derive a Smart List value using a member, where the Smart List has been build from the Period dimension. Content (required): Below is an example …
-
Change Existing Details Form Issue (Workforce Planning)Summary: We are unable to properly update the Status on positions via Change Existing Details as the number of months for entered for duration does not match the output.… -
Invoking a Cube Refresh via Business RuleSummary I am trying to create a business rule that executes the Cube refreshContent I am trying to create a business rule that executes a cube refresh. I have created a …
-
How can I use a Smart List member to generate a target Period and Year?Summary: To try to dynamically create a mapping generic months to a Period and Year for each of the different Entities. Content (required): Hello, I have a requirement t…
-
New Quick Mode in Data Integration - Inter Cloud data movement and ASOSummary: We see it is possible to do data movement inside the instance with Quick Mode, but is it possible to use ASO cubes? Has anyone tried it? Content (required): We …
-
Loading high number of account dimension members.Summary: Loading high number of account dimension members. Is it recommended in the long run. Content (required): Hi Do you recommend uploading chart of account members …
-
How to remove UDA in bulk？Summary: Content (required): Hi， If I have 1000 members being tagged with a UDA, and I don't need that UDA anymore, how can I remove the UDA in bulk? I tried exporting …
-
Reports - dynamic user variablesSummary: Hi all, Currently we are building a report with specific formatting. It is however the customers desire to maintain a high level of flexibility in order to stre…
-
Groovy - Acting on Edited Cells IssueHi, We are running a basic groovy rule on save to act only on edited cells. The form in question is a spin off of the OOB expense trending form, but with additional dime…
-
what is the use case for Link Accounts by Default setting in EPBCSSummary: Recently in EPBCS application Link Accounts by Default set to Yes and entire application performance degraded by running many Xref/Xwrite processes running in t… -
Received Email : Your service has been updated|Incremented by 10 users.Summary: Received email from Oracle Cloud with subject as Your service has been updated. The Body of the email mentioned as below. Can any one help me to understand wha…