How To Make An Action Formula For 3 Variables To Calculating And Populating A Collection Element
Last updated on DECEMBER 25, 2017
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 (XXDON_Quantity_Nonconforming) 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 XDON_Quantity_Nonconforming element needs to be updated with the new total of the three elements.
The issue we are having is that we can only get the XXDON_Quantity_Nonconforming 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 I list the variables. The three elements are currently listed in sequence # order and are all lower in sequence than the XXDON_Quantity_Nonconforming
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 XXDON_Quantity_Nonconforming is also defined as an attribute element, with a data type of number, and NO default
How can this be done?
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