My Oracle Support Banner

PBCS / Planning Cloud / EPBCS: Base Level Members with Member Formula Are Not Showing the Calc On The Fly Formula in Excel (Doc ID 3011973.1)

Last updated on MARCH 28, 2024

Applies to:

Oracle Enterprise Planning and Budgeting Cloud Service - Version N/A and later
Information in this document applies to any platform.


Calc on the fly for forms 2.0 not bringing in formulas in to calculated cells.

Trying to replicate functionality that was in smart forms in forms 2.0. The Calc on the Fly should display an excel formula in cells that are calculated. Here is an example where it is not.

1. Set Account Member Account1 to Dynamic calc and insert member formula “=Account2*Account3;” for the Cube. Save and Refresh Database
2. Open the associated form. Parent members are showing calc on the fly formulas as expected:
3. Base level members with member formulas are not showing calc on the fly formulas:




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.