Business app status showing incorrect value

[SNDEV27]

Hello,
I am trying to update the status of business application to retired through a catalog item workflow.
My workflow has following script :

gr.setValue('install_status', "3"); //Retired = 3 in backend choice table

On completion of the workflow, there is weird issue where the status is updating the value to 7 and in choice list table i do not see any new entry with this value.
There ain't any other script running in parallel and this issue is observed in xanadu.
I found this KB Article  but if i do this configuration change, it's creating a new value in choice table.

Any insights how to trouble shoot this ?What could be the possible reason, If it's creating any new record with value 7, it should atleast appear in backend.

[Ankur Bawiskar]

@SNDEV27 

ideally it should not as per that KB

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ravi Gaurav]

Hi @SNDEV27 
Verify that "3" corresponds to "Retired" in the backend choice list table (sys_choice table). Ensure there are no duplicates or conflicting entries for "3" that might be causing confusion.

Review your workflow script carefully (gr.setValue('install_status', "3");). Ensure there are no typos or other logic that could inadvertently change the value to "7". Double-check if there are any conditions or asynchronous updates that might affect this field after your script runs.

[SNDEV27]

Hi Ravi,
This an old logic implemented and is working fine on other instances which are in washington. This particular instance where it's updating to 7, was recently upgraded to xanadu. So not really sure if it's the instance version as the logic seems to be simple.

[SNDEV27]

To add to this, the status field on form is showing value 7 in dropdown only on records where it is updated. Other business application records donot show 7 in dropdown. Becasue no new value is created in backend in sys choice table.