Hi Ashu,
I see this in the schema file:
TABLE ZRisk_level {
id INTEGER UNIQUE KEY;
last_mod_dt LOCAL_TIME;
last_mod_by UUID REF ca_contact;
delete_flag INTEGER REF Boolean_Table UNIQUE;
sym STRING 60 UNIQUE;
}
... so the delete_flag is currently defined as a unique index for ZRisk_level, which is not workable.
A couple of suggestions:
1. I would normally set 'delete_flag' as an SREL to 'actbool' (Active_Boolean) rather than to 'bool' (Boolean_Table), as that is how nearly all of the out-of-box reference tables are defined (look at the 'delete_flag' in WSP for acctyp, closure_code, crs) and your table will then behave similarly to other reference tables.
2. In WSP, for your 'delete_flag', clear the 'DBMS Index Options / Unique' flag and set the 'Required' flag. Under 'On New Default Value', enter 0 as the default. This is the pattern for most out-of-box reference tables. Save, publish, run pdm_publish again. You may find that the 'save and publish' fails because pdm_publish failed previously. If so, please get back to me :-).
Regards,
James