Unable to Open Some Functions in Formula Management with Variable Mode

(Doc ID 2107989.1)

Last updated on MAY 04, 2016

Applies to:

Oracle BigMachines CPQ Cloud Service - Version 2015 R1 and later
Information in this document applies to any platform.


When trying to edit a function in Formula Management with "Variable" mode, the function cannot be opened.

Steps to reproduce:

Navigate to Admin > Process Definition > Formulas > Select "Variable" in Display Mode

If a formula was created using the "sumif" function, it cannot be opened in Variable mode. Click the pencil icon to edit function, then click the "sumif" function, nothing shows.


Switch to Label mode. Editing the function works without any issue.


Note: Functions that don't open in Variable mode include but are not limited to: "if", "sumif","toFloat", "avgif", "mod".


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