My Oracle Support Banner

How To Make An Action Formula For 3 Variables To Calculating And Populating A Collection Element (Doc ID 2340161.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Quality - Version 12.1.3 and later
Information in this document applies to any platform.


User is attempting to populate a user defined collection element with a value that is the sum of the quantity from three other collection elements. The numeric quantity in each element may change before the NCR is completed. Therefore, if a user changes a quantity in one of the three elements, the user defined collection element needs to be updated with the new total of the three elements.

The issue: can only get the user defined element to update when we specify an action formula with two variables, &A + &B. When we add the &C, the html form fails. It fails no matter which sequence lists the variables. The three elements are currently listed in sequence # order and are all lower in sequence than the user defined element.

All three quantity collection elements are defined the same, as attribute elements, with a data type of number, and a default value of 0 (zero). The action rules for all 3 elements are identical.

The user defined collection element is also defined as an attribute element, with a data type of number, and NO default.

How can this be done?


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.