Category 101
Discussion List
-
Function to specify the member of a calc member blockI would like to pass in a run time prompt that I can then use to derive the member to be used as the calc member block. So picture this: RTP Name: {Period} RTP Value: P0… -
How can I use a batch file to dynamically update a variable in Rules calculation manager.Hi, I'm still learning the ropes of cloud and I really appreciate your patience with me in advance. I want to dynamically update a variable in Rules that is in calculati… -
Options for loading dimension securitySummary: My client is currently maintaining a list of their cost centre managers in Fusion HCM (for approvals purposes). They want to use this same list to maintain the …
-
Groovy - how to print real-time log message in job console?Summary: Hi, I have a Groovy rule with long-running processes, for example the process needs to be iterate through 100 times for different combinations. I need to watch …
-
Oracle EPM Planning - PipelineWhat's the difference between running a business rule in a pipeline from using an EPM Platform Job Job Type for Planning Jobs vs using a Business Rule Job Type?
-
OIC adapters for epbcs?Summary: Are there any OIC adapters for epbcs? Content (please ensure you mask any confidential information): Are there any OIC adapters for epbcs? We found something wi…
-
Required a code in groovy so that if the first BR is running second BR should wait for the first BRWe are using the export and import method as we need to manipulate the file because of the mapping of dimension between two cubes.Data has been doubling when we are runn…
-
EPB - Migrating Standard to EnterpriseSummary: We have a planning standard cloud license, and have 3 BSO cubes deployed to the same POD. Recently we have purchased Enterprise license and intent is to move to…
-
Debugging Rules in EPM planningWe have few Rules in EPM planning and budgeting - Profit cube which calculates the costs/revenue based on few allocation account drivers and then it allocates them acros…
-
How to schedule to run the report and send it via email?Hello everyone, I want to schedule to run a report in EPBCS and send it via email. Is there any function that can help with this requirement? I tried to find it in the J… -
Phased Submission of Approval Unit using Approval GroupsSummary: We are trying to set phased submission of approval workflow for 2 set of accounts using approval groups feature. While setting up the approval unit, we have sel…Javed Nawaz Khondkar-Oracle 42 views 3 comments 0 points Most recent by Javed Nawaz Khondkar-Oracle Planning -
Groovy setSuppressMissingSuppressesZero never workSummary: Hi, With a groovy rule to build a grid like below for reading data FlexibleDataGridDefinitionBuilder gdb = cube.flexibleDataGridDefinitionBuilder() gdb.setSuppr…
-
Is it possible to get the Thai calendar instead of the default calendar in data forms?Is it possible to get the Thai calendar instead of the default calendar in data forms? -
Not able to retrieve smart list values from datagrid.datacellSummary: Hello, we need to retrieve smart list values from a grid. The smart list has entry ID of 1,2,3 and corresponding label and Names. we need to retrieve the name h…
-
How to use Groovy to create unique set of multiple chart string values via a single GridHello, I'm trying to build a Form and Groovy Script that will allow a user to update multiple "Transaction IDs" simultaneously within a Form. The form is built with a sp…
-
ASO Refresh Compression IssueSummary: In my BSO cube i have the account dimension setup as sparse and have associated attributes. Afterwards i created an ASO cube and i am trying to refresh the data…
-
Display 2 alias tables simultaneously in Form and Smart ViewSummary Is it possible to display 2 alias tables at a time in Form and Smart View? Content (please ensure you mask any confidential information): Due to limitation of 80…
-
Report grid exportSummary: Content (please ensure you mask any confidential information): Hi In FRS we were able to export grids. Pls check the option highlighted in yellow. I need to fin…
-
Open in Smart View from Form not workingOpening SmartView from Forms first time getting downloaded. But when clicked its not getting opened in Excel. Second time If I do the same, getting redirected and openin…
-
Groovy rule in pipeline failed to initialize Epm Automate instanceSummary: Try to attach groovy rule in pipeline Content (please ensure you mask any confidential information): I tried to put groovy rule in pipeline, but it failed to ca… -
Preventing dates rollup at agg levels causes suppressions of agg amounts as well at this levelSummary: We have multiple date account types and at Half year level this gets rolled up and we want to prevent this. Having a Member formula to generate #missing at Half…
-
Automate File Transfer from SFTP to EPBCSOur current process with OIC renames the file on SFTP(Example file name: Testfile_MMDDYYYY_HHMMSS to Testfile MMM-YY) and moves the file to EPM then deletes the file on …
-
Air-gapped Backup Paired RegionsSummary: We want to enable the Air-gapped backup that mentioned in Sep Monthly update Content (please ensure you mask any confidential information): Hi, In the September…
-
Funds Reserve date issueWe're having an issue with our Funds Reserve process. Many of the analysts are having the process fail on them with the following type of error: Response from Budgetary …
-
General aggregation questionI was curious as to what might be causing an aggregation to take significantly longer when run for a different fiscal year, all other things being equal. Each fiscal yea…
-
Need to load more than 2 decimal placesHello, We are loading exchange rates to planning from a file through data management and the values in rates column have 14 decimal places(Ex values: .73172146606776, 1.…
-
Groovy rule in ASO is rounding off the values after calculationSummary: When performing a calculation on ASO using a Groovy Business rule a simple Unit*Price is resulting in an absolute value instead of giving the decimal values. Is… -
drill through on some higher parent level not workingSummary: Issue on drilling through on higher parent level. Content (please ensure you mask any confidential information): I am trying to drill through on higher parent l…
-
Is it possible to auto start the plan cycle for a newly created entity in a planning unit?Summary: We would like to auto start the plan cycle for any new created entity (it inherits it's owners and reviewers from its parent, which is what we want). It only se… -
@count usage in a divisionSummary: Greetings, I'm using @count in a rule file in Planning to get the number of records for a particular intersection. Works well, the result comes back correctly. …