How To Make An Action Formula For 3 Variables To Calculating And Populating A Collection Element

(Doc ID 2340161.1)

Last updated on DECEMBER 25, 2017

Applies to:

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

Goal

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?
 

Solution

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