I have an Interactive Grid column SC_NO which is a Popup LOV.
When a value is selected in SC_NO, I have a Dynamic Action that sets values for three other columns: GRE_REC_ID, GRE_REC_SEQ_NO, and COST_ID.
Now, COST_ID is a cascading LOV whose parent columns are GRE_REC_SEQ_NO and GRE_REC_ID.
The issue is: when SC_NO changes, the Dynamic Action refreshes the parent columns (GRE_REC_ID and GRE_REC_SEQ_NO). This triggers the refresh of the COST_ID column, causing its value to be wiped out.
I want to prevent COST_ID from losing its value when its parent columns refresh.
How can I stop this from happening in an Interactive Grid? Is there a way to retain the existing COST_ID value if it is still valid for the new parent values?
@karel-ekema