New Groovy Training Available from Oracle!!!!

Wow i just saw this and cant help myself in advertising this, now we have the OBE (oracle by example) for the GROOOOOOOVYYYYYYYYY yahhhhhh enjoy...

Introduction to Groovy Business Rules
Learn about the Groovy scripting language and see how to create a Groovy script in Oracle Enterprise Planning Cloud.

Working with Data Grids and Iterators in Groovy
Implement Groovy scripts to work with data grids and data grid iterators. You use conditional logic to set the background colors in a data grid, implement performance benchmarking, and set default data values in a grid.

Moving Dimension Members with Groovy
Create a Groovy script to work with metadata, in this case, moving a member from one parent to another.

Moving Modified Data Using Groovy and Smart Push
Push data from a source location to a target location via Groovy rules.

Validating Data Entry Values with Groovy
Implement a Groovy script that validates data entry against allowed ranges stored in a driver cube.

Adding Dimension Members with Groovy
Create a Groovy script to work with metadata, in this case, adding a member to a dimension.

Calculating Modified Data Using Groovy
Generate a focused calculation script to calculate only data that has been edited, instead of the entire data entry form.

Integrating Data Between Planning and Strategic Models Using Groovy
Learn about Strategic Modeling concepts and how to integrate data between strategic models and planning applications using Groovy scripts.

Creating Groovy Templates
Create a Groovy template with interactive Design Time Prompts (DTPs).

The OBEs are available on the Help Center.

Loading numeric & non-numeric data directly into Planning application in PBC/EPC via the Simplified Interface

Let's see how to load numeric & non-numeric data directly into Planning applications in PBC/EPC instance via the Simplified Interface without using the Data Management.

Method: Using the Source Type Planning

If an import error occurs during a Planning data load, the import will continue to load valid data (partial load). Any errors will be noted in the import and export status.

All we need is the data to be loaded in a specified format to get loaded. The format should be like the following file, (CSV Format)

In this case, we are loading the data to the Account members for Jan to Jun period for the specified POV and for the Database Plan1

You can export the data from the Planning application via the Simplified Interface to get this format.

To export, the data click on Navigator 

Go to Application - Overview