HOME | My Site

Find out about new features, tricks I have discovered, or useful best practice advice for Oracle EPM Applications.

Consultant Tips;

EPM Planning
Business Rules
Data Exchange

BLOG PREVIEWS

Tips for using REST API and groovy to run jobs in Oracle Cloud EPM Planning

Sarah Ansell

Apr 25, 20244 min read

Integrations

Tips for using REST API and groovy to run jobs in Oracle Cloud EPM Planning

Good to know tips for beginners using REST API via Groovy in EPM Planning

Reference rows and columns in Oracle EPM Report formulas

Sarah Ansell

Dec 5, 20232 min read

Reports

Reference rows and columns in Oracle EPM Report formulas

In EPM Reports, formulas can be used to perform simple calculations, such as a variance calculation. Formulas require references to rows...

7 Day Rolling Artifact Snapshot Backups in the Cloud (Groovy Script)

Sarah Ansell

Jul 25, 20234 min read

Rules

7 Day Rolling Artifact Snapshot Backups in the Cloud (Groovy Script)

Each Oracle Planning Cloud environment has a Daily Maintenance window in which Oracle perform routine maintenance. During this automated...

Automating Data Integrations via Business Rules using REST API Commands

Sarah Ansell

Apr 5, 20233 min read

Groovy

Automating Data Integrations via Business Rules using REST API Commands

Automate EPM Data Load Rules without the need to install any automation software on a server. Entirely within the cloud. Make life...

Oracle EPM Data Management Multi Currency Load

Sarah Ansell

Oct 28, 20222 min read

Integrations

Oracle EPM Data Management Multi Currency Load

By default, Data Management assumes that the currencies will be associated with the Entity or Location when loading any data into Oracle...

Clear target data in Oracle EPM - ERP integrations using a Data Exchange Clear Region

Sarah Ansell

Oct 1, 20214 min read

Integrations

Clear target data in Oracle EPM - ERP integrations using a Data Exchange Clear Region

------------------------------------------------------------------------------------------------------------------------ *** Update...

FAQs answered for the new Clone Environment Planning Cloud feature!

Sarah Ansell

Apr 13, 20212 min read

FAQs answered for the new Clone Environment Planning Cloud feature!

This is a very quick, no frills, 'what you need to know' blog about the latest new Planning Cloud feature: Clone Environment. This...

Connecting to multiple Oracle Cloud Environments via Smart View

Sarah Ansell

Jul 28, 20192 min read

Smart View

Connecting to multiple Oracle Cloud Environments via Smart View

Connect to multiple EPBCS environments via Smart View Shared Connections XML Switching environments, changing domains, logging in,...

Transfer of Smart List values to members in Calculation Manager

Sarah Ansell

May 31, 20183 min read

Rules

Transfer of Smart List values to members in Calculation Manager

This blog features instructions for retrieving and transforming a Smart List entry into a member name to be used within a calculation...

Be in Touch

Ask questions & share your thoughts below. Alternatively, comment directly on my blog posts!

EPM

Consultant Tips;

EPM Planning

Business Rules

Data Exchange

Tips for using REST API and groovy to run jobs in Oracle Cloud EPM Planning

Reference rows and columns in Oracle EPM Report formulas

7 Day Rolling Artifact Snapshot Backups in the Cloud (Groovy Script)

Automating Data Integrations via Business Rules using REST API Commands

Oracle EPM Data Management Multi Currency Load

Clear target data in Oracle EPM - ERP integrations using a Data Exchange Clear Region

FAQs answered for the new Clone Environment Planning Cloud feature!

Connecting to multiple Oracle Cloud Environments via Smart View

Transfer of Smart List values to members in Calculation Manager

Be in Touch

More EPM Content

Subscribe to new content