Oracle EPM Cloud Planning: Hidden Member Property UDAs

Turns out there are alot of UDAs that we were never told about, I've compiled a list below but there may be more in which case let me know! These can be used to test for specific member properties such as the account type and time balance settings which could prove very useful in certain situations.

I've tested them using the below script, fixing on a specific member to check if it pulls back the error message when the if statement was a success.

You can use an @isuda to check which of these Account types is present:

Expense

Revenue

Asset

Liability

Equity

Saved Assumption

These Time Balance types:

Flow

Balance

Average (Worth noting it doesn't seem to distinguish between average "time balance" and average "exchange rate type", so if either is set to average this will be considered true)

Fill

These Exchange Rate Types:

Average (Worth noting it doesn't seem to distinguish between average "time balance" and average "exchange rate type", so if either is set to average this will be considered true)

Ending

These Version Types:

Standard Bottom Up

Standard Target

Comments

Oracle Apex Basics: Conditional Formatting

Our Objective: Here I will be outlining how to apply conditional formatting to your grids and reports in oracle apex, for instance shading highly positive figures as green or negative figures as red. This can be especially helpful when creating end user reports. Lets Begin: First you will need the report you're applying the formatting to, to have an SQL query as it's source. Once you have the query you want, we need to add an additional "Conditional_Formatting" column, and for that column to be populated with 'Green' should a certain column's data meet a criteria. Here I have made the 'Conditional_Formatting' column populate with 'Green' when the figure in the 'Likes' column is greater than or equal to 2. This will have added an extra column to our report, one which you will probably want to hide from view as it is only used in deciding the color of the conditional formatting. From here we need to write t

Connecting EPM Cloud Planning to Apex with Rest API: Running Jobs in Planning from Apex Part 2 of 2

In Part 1 I covered how to setup your web source modules, one to perform a GET request on available jobs, and another to perform a POST request to run these jobs. Now lets build the connector between the web source modules and our application. Head over to SQL Workshop and create a new Package with the following "Specification" and "Body" , substituting "PLANNING_RUN_JOB" with the name you gave your package. Or as text: Body: create or replace package PLANNING_RUN_JOB as procedure planning_run_job( p_jobtype varchar2, p_jobname varchar2 ); end planning_run_job; ---------------------- Specification: create or replace package body PLANNING_RUN_JOB is procedure planning_run_job( p_JobType varchar2, p_JobName varchar2 ) is l_parameters apex_exec.t_parameters; begin apex_exec.add_parameter(p_parameters => l_parameters, p_name => 'JOBTYPE', p_value => p_JobType); apex_exec.add_parameter(p

Connecting EPM Cloud Planning to Apex with Rest API: Running Jobs in Planning from Apex Part 1 of 2

Intro: I've already run through how to view and change your substitution variables in Oracle Planning via Apex, so let's take a look at something a bit more versatile, running jobs in Oracle Planning from Apex. According to Oracle's documentation you should be able to run any of these types of jobs using Rest API: Rules Ruleset Plan Type Map Import Data Export Data Export Metadata Import Metadata Cube Refresh Clear Cube Administration Mode Compact Cube Restructure Cube Merge Data Slices Optimize Aggregation Import Security Export Security Export Audit Export Job Console Sort Members Import Exchange Rates I haven't had a chance to test them all and see how they work/ if they require any further tweaking, but the one's that have worked have done so with relative ease which makes me feel fairly confident in writing this that you shouldn't run into any issues, but please do let me know if anything does fail to work f

Working with EPM Cloud Planning and Apex

Search This Blog