Category 101
Discussion List
-
ASO Dynamic Calc Currency Member Not WorkingSummary: I'm working to get an ASO cube working. The stored member is US$ and works fine. US$K in the BSO works fine, but not in ASO and is a dynamic calc member with th… -
Member formula not working in Hybrid BSOSummary: Member formula working well in traditional BSO, but not working in Hybrid BSO. Content (required): Hi , We have a pretty simple member formula for an account me…
-
Groovy - Accessing Attribute Dimension MembersHi, We were doing some testing today and were trying to use .getEvaluatedMembers to access attribute dimension members (similarly to accessing dimension members using th… -
Data Integration SQL queries are not validating anymoreSummary: Data Integration queries are not validating anymore Content (required): In Data Integration, when I try to insert or update a SQL query that previously validate…
-
Activity Report User Interface Key - EfsStructurePSBSummary: Our Activity Report from last night has multiple long-running instances "HyperionPlanning" listed as the Screen and "EfsStructurePSB" as the Action, and no othe… -
Best practices for hotel and leisure industry.Summary: Best practices for hotel and leisure industry. Content (required): Hi We are implementing EPBCS for hotel and leisure industry. I'm looking for EPM Best practic…
-
Is there an alternative to using Use Allow Expansion and Suppress Missing Blocks in FR reports?Summary: We have a FR report for payroll with one column called Other Compensation in which one of the grid POV is an alternate hierarchy for Earn Code which is set to A… -
DM Load is not considering the #missing valuesSummary: Hi Oracle, We are using data management to transfer the data between 2 EPBCS applications. When users delete the data in the source application that cell was de…
-
How to produce Audit Trail Report for Changes done in Data Management in PBCS?Summary: We are working in PBCS Cloud, and we are using heavily DM, for some reason all the periods for FY22 were removed last night from the period application mapping … -
Substitution Variable in Formula Label in a Data FormSummary: Is it possible to reference a Sub Var in a Formula label in a data form? Content (required): When I reference &BudYr1 in a Formula Label in a form, it does not …
-
EPM Cloud REST API authentification with OAUTH2 - prerequisitesSummary: We would like to understand the prerequisites and consequences of using OCI Gen2 with OAUTH2 - we may have EPM classic - but are not sure, if this is a licence/…
-
Can you use Valid Intersections to restrict one dimension based on another?So I've been fiddling around with Valid Intersections, and I'm pretty sure this isn't possible based on the documentation and what i've discovered....but figured I'd try…
-
Data Map between BSO to ASO cube sometimes produces strange results?Summary: I'm currently setting up some data maps between a BSO cube and an ASO cube. However, have encountered a situation where after running the data map job, it has '…
-
Bursting Definition - Security IssueSummary: Bursting Definition - Security Issue Content (required): Hello, We have one report where we took cost centres on a row. When user select parent cost centre then…
-
[Data Management] Export mode replace does not clear dataSummary: Export mode replace does not clear data Content (required): Hello, In a DLR with replace export mode, the clear script is not run before load. Can you please he… -
Account Type appears to be ignored, only Consol properties being consideredBelow is a screenshot of a portion of our account hierarchy. We have the parent 00124 with 4 children. However, the numbers are not acting the way I would expect with th…
-
Groovy Sum of two columnsSummary: Groovy to check sum of two columns Content (required): Hi, I want to use groovy to check if sum of Dr. column is equal to sum of Cr. Column and if not then thro… -
EPM performance score cardSummary: As part if enterprise edition, do we have performance scorecard as out of box feature? Content (required): As part if enterprise edition, do we have performance… -
Extract or download cell attachmentsSummary: Looking for a way to systematically download cell attachments Content (required): I'm trying to find a way to systematically download cell attachments. I don't … -
Suggestion for an easy method : Financial reporting studioSummary: Suggestion for an easy method : Financial reporting studio Content (required): Hi We are using a PBCS Application, and is in the process of creating an income s…
-
tax compensation configured with a rate and a threshold to calculate starting Jan or hiring monthSummary: In Workforce, tax compensation configured with threshold and rates calculates starting the start period of a forecast even though the employee start month is be…
-
Dynamic time series feature in Financial reporting studioSummary: Dynamic time series feature in Financial reporting studio Content (required): Hi This is a PBCS Application and We are in the process of creating a FRS report. …
-
Ger member from SmartListSummary: Hello, I've used to build calculations to extract the member from a smartlist based on a existing members. However I'm doing one internal testing and I'm no lon… -
Is there a way to move a file from the planning inbox to the Data Management inbox w/o downloading?Summary: Is there a way to move a file from the planning inbox to the data management inbox that doesn’t require the file to be downloaded from one inbox and uploaded to… -
EPM Agent failing to display data for one source CargoWiseSummary: Content (required): Hi all We have an issue with one of our source target. We are getting this error: ----------------------------------------------------------… -
How to extract JE lines data from Cloud ERP Database tables into EPBCSSummary: We are trying to extract data from Oracle Cloud ERP to EPBCS application using EPM agent.Since we are going to pull huge number of journal level dataset from Cl…
-
Amazing what product management and development doesI have been at Oracle coming up on 2 years and been using Planning since it was released on the cloud. There is no question in this post, just want to take a step back a… -
Task Manager Sample in PlanningSummary: Task Manager Sample Content (required): Is there a downloadable sample for Task Manager in Planning? Version (include the version you are using, if applicable):…