Oracle EPM Cloud Planning: Hidden Member Property UDAs

Richard Jeffries

Brovanture Consultant

Turns out there are a lot of Oracle Cloud EPM Planning 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 script below, 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 are present:

Expense 

Revenue 

Asset 

Liability 

Equity 

Saved Assumption

 

These Time Balance types are present:

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 are present:

Standard Bottom Up 

Standard Target

 

Until next time

Richard

More Blogs by Richard can be found HERE