[PBCS] Text Type Member is Updated with the Excel Formula Instead of Calculated Value In SmartView

(Doc ID 2257588.1)

Last updated on SEPTEMBER 19, 2017

Applies to:

Oracle Planning and Budgeting Cloud Service - Version 17.02.75 and later
Information in this document applies to any platform.

Symptoms

 If the data type of a column is text and you enter Excel formula to enter a calculated value in Smart View, the formula itself is set as a value instead of calculated value. Here is an example.

1. Create a sheet with two members in a row, a numeric type member and a text type member. In the following example, Capex:Land is a numeric type member and Comment is a text type member  is in a sheet named Sheet 2.

2. Create another sheet which has two values. One is a numeric value and the other is text value. In this example, 100 and aaa are in a sheet called Formula.

3. Go back to the sheet created in step1 and enter an Excel formula in a numeric type member to refer the value created in step2. In this example, Formula!B1 is entered as the value of Capex:Land.

4. Click Send. You will notice that the value of the numeric type member is updated by the calculated value.

5. Enter an excel formula in a text type member to refer the value created in step2. In this example, Formula!B2 is entered as the value of Comment.

6. Click Send. You will notice that the value of the numeric type member is updated by the Excel formula itself.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms