IBM Support

PH27496: CALCULATED FIELDS THAT ARE THE CONTROLLER OF A DEPENDENT PICKLIST GENERATE AN ERROR SAVING CHANGES

Subscribe to this APAR

By subscribing, you receive periodic emails alerting you to the status of the APAR, along with a link to the fix after it becomes available. You can track this item individually or track all items by product.

Notify me when this APAR changes.

Notify me when an APAR for this component changes.

 

APAR status

  • Closed as program error.

Error description

  • If a calculated field, dependent on another field, is set as the
    controller for a dependent picklist, then that dependent field
    may run into an error when saving.  This happens if the
    calculated controller was set to a value that excluded the new
    dependent value being set, but the controller was updated by the
    calculation engine.
    If the controller change is saved first, then the dependent
    field can be updated without any error.
    
    The error will appear to the user like:
    OP-15063
    The value "Operational" cannot be set on field "Domain" due to
    the value of field "Control Type".
    
    To reproduce:
    Prerequisites:
    OpenPages 8.2 with standard test data
    
    Create a calculation rule:
    1.	Login as OpenPagesAdministrator to TFUI
    2.	Go to gear menu > Solution configuration > Calculations
    3.	Click Add New
    4.	Name it Control dependent test, and set the object type to
    Control
    5.	Create an operation by clicking the Add Operation link
    6.	Set it to Set Field and name it test 1
    7.	Set Output field to Control Type:
    
    
    8.	The expression should be:
    if [$OPSS-Ctl:Control Method$] in ('Automated') then
    'Preventive'
    else
    'Detective'
    endif
    9.	Click Done, then click Publish for the calculation
    
    
    Create a dependent picklist:
    1.	Switch to the standard UI
    2.	Go to Administration->Object Types
    3.	Click on SOXControl
    4.	Go to the Dependent Picklist section
    5.	Click Add
    6.	Choose Control Type as the controlling field, and Domain as
    the dependent field
    7.	Set the picklist to the following:
    
    
    8.	Save the picklist definition
    
    
    Steps to Reproduce:
    1.	Login as OpenPagesAdministrator to the TFUI
    2.	Choose main menu->Assessments->Controls
    3.	Create or select a control to test
    4.	In the Task View of the control, go to the Control Activities
    section
    5.	Choose Automated for the Control Method ? the Control Type
    should automatically change to Preventive
    6.	Save the Control record
    7.	Update the Control Model field to Manual ? Control Type
    should update to Detective
    8.	Set the Domain to Audit:
    
    9.	Try to save the Control again
    10.	An error will be displayed:
    OP-15063
    The value "Audit" cannot be set on field "Domain" due to the
    value of field "Control Type".
    11.	Clear the value for Domain, then save again.
    12.	Update Domain to Audit, then save again.  The save should be
    successful
    

Local fix

  • Save any changes to calculated fields before trying to modify a
    dependent field.
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED:                                              *
    * OpenPages Users                                              *
    ****************************************************************
    * PROBLEM DESCRIPTION:                                         *
    * CALCULATED FIELDS THAT ARE THE CONTROLLER OF A DEPENDENT     *
    * PICKLIST GENERATE AN ERROR SAVING CHANGES                    *
    ****************************************************************
    * RECOMMENDATION:                                              *
    * Customers should download OpenPages with Watson 8.2 Fix Pack *
    * 1 (8.2.0.1). See the following document for details on       *
    * obtaining OpenPages 8.2.0.1:                                 *
    * https://www.ibm.com/support/pages/openpages-watson-82-fix-pa *
    * ck-1                                                         *
    ****************************************************************
    

Problem conclusion

  • This fix addresses fields that are both Calculation Output
    fields and involved in field dependencies (e.g. editable,
    required, dependent picklist).
    
    NOTE:  This is fixed in 8.2.0.1 and also in interim fix
    8.2.0.0.2
    
    Customers should download OpenPages with Watson 8.2 Fix Pack 1
    (8.2.0.1). See the following document for details on obtaining
    OpenPages 8.2.0.1:
    https://www.ibm.com/support/pages/openpages-watson-82-fix-pack-1
    

Temporary fix

Comments

APAR Information

  • APAR number

    PH27496

  • Reported component name

    OPENPAGES GRC

  • Reported component ID

    5725D5100

  • Reported release

    810

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2020-07-15

  • Closed date

    2020-11-24

  • Last modified date

    2020-11-24

  • APAR is sysrouted FROM one or more of the following:

  • APAR is sysrouted TO one or more of the following:

Fix information

  • Fixed component name

    OPENPAGES GRC

  • Fixed component ID

    5725D5100

Applicable component levels

[{"Line of Business":{"code":"LOB10","label":"Data and AI"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSFUEU","label":"IBM OpenPages with Watson"},"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"810"}]

Document Information

Modified date:
25 November 2020