FCCS ClearEmptyBlocks

In the November Cloud update, Oracle released a new business rule in FCCS to clear empty member blocks.  This SHOULD somewhat help perfmance.  I haven’t tested it myself, but I’m certainly crossing my fingers.

It’s fairy easy to do from the web.  Select your scenario, Year(s), and Period(s).

emptyblock

But, what if you want to automate  this process?  You can do this via EPMAutomate.

For one period the command  would look like this:

epmautomate runbusinessrule ClearEmptyBlocks Period=Oct Scenario=Actual Year=FY17 

For multiple periods, the command would look like this:

epmautomate runbusinessrule ClearEmptyBlocks Period=Oct,Nov,Dec Scenario=Actual Year=FY17

HOPEFULLY I have just made your FCCS world a little better (or hopefuly faster?)

 

~Sum

 

 

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s