EPBCS
Discussion List
-
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… -
Alternative to LOOP or any other improvementsSummary: Alternative to LOOP function is needed. Content (required): Hi Attached rule is taking 15 minutes to run. it is taking that much of a time because of the LOOP. …Lakshani Hettiarachchi 24 views 8 comments 0 points Most recent by Kyle Goodfriend, In2Hyperion-Oracle Planning
-
Troubleshooting Pulling in Smartlist DataSummary: Issues with pulling in @MEMBER(@CONCATENATE("HSP_ID_",@HspNumToString(Smartlist_Value))). Content (required): I am creating an allocation in which I have a form…
-
Has Drill Through Functionality Changed in Planning Cloud?Summary: Drill Through not bringing back records on previously loaded data where drill detail was available (with no other changes to app/data) - has something changed t… -
Improvements to ruleSummary: Content (required): Hi There is a rule which is taking around 4 hours to run. and biggest contributor is following section i have attached. Pls help to reduce t…
-
NSPB Writeback to NetSuiteSummary: Has anybody had experience with configuring and working with Writeback from NSPB to NetSuite? If so, any documentation around on how to set this up and run it? … -
@prior not executing as expectedSummary: @prior not executing as expected, need to get the value 12 months back from the current month which im calculating. Content (required): Hi Im using @prior to ge…
-
Download Dimension Export File from EPMSummary: REST API for Oracle EDMCS fails with status code 501 Content (required): Hi, We were trying to download the dimension export file from staging using endpoint: /…
-
Updated EPM balances are not reflected in ERP/GL essbase cubeSummary: We updated balances for a few accounts in EPM planning and pushed it to ERP GL using the ERP writeback job in DM. We are seeing all the balances are showing up …
-
YTD Dynamic Calculations in ASO cubesSummary: Dynamic Member Formula not calculating correctly for YTD view. Content (required): I have a dynamic calculated account with a member formula that takes two acco…
-
Multiple calculation scripts from a single groovy scriptSummary: Can we run multiple calculation scripts from a single groovy script? Content (required): Hi, I tried running a groovy script with 2 cal scripts (base on 2 strin… -
How to get the Smart Push functionality to work in Dashboards when they are being utilized via SmartSummary When submitting data for an EPBCS Dashboard in Excel via the Smart View 11.1.2.5.910 (Build 172) add-in, the Smart Push for the underlying simple forms being sav… -
Use of MATCH Function in FR - Dynamic Reference to Current POVSummary: The general requirement is to use the MATCH function in the FR Reporting Web Studio in a dynamic fashion. Essentially, I want to use the MATCH function to pull …