...
and mbr_id = '10042'
and mbr_typ_cd = 'G';
Note that 52741 is the newly created role_mbr_id.
...
| 13 | documentTypeName |
| 22 | chartOf AccountsCode |
| 28 | accountingLineOverrrideCode |
insert into kr_SUP.krim_role_mbr_attr_data_t
(attr_data_id,
obj_id,
ver_nbr,
role_mbr_id,
kim_typ_id,
kim_attr_defn_id,
attr_val)
values (kr_SUP.KRIM_ATTR_DATA_ID_S.nextVal,
sys_guid(),
1,
'52741', <----- newly created role_mbr_id
'30',
'13', <----- attr_defn_id for documentTypeName
'JV'); <----- actual Document Type Name
commit;
-------------------------------------------------------------------------------------------------------------------------
insert into kr_SUP.krim_role_mbr_attr_data_t
(attr_data_id,
obj_id,
ver_nbr,
role_mbr_id,
kim_typ_id,
kim_attr_defn_id,
attr_val)
values (kr_SUP.KRIM_ATTR_DATA_ID_S.nextVal,
sys_guid(),
1,
'52741', <----- newly created role_mbr_id
'30',
'22', <----- attr_defn_id for chartOfAccountCode
'UC'); <----- actual Chart Of Accounts Code
commit;
-------------------------------------------------------------------------------------------------------------------------
insert into kr_SUP.krim_role_mbr_attr_data_t
(attr_data_id,
obj_id,
ver_nbr,
role_mbr_id,
kim_typ_id,
kim_attr_defn_id,
attr_val)
values (kr_SUP.KRIM_ATTR_DATA_ID_S.nextVal,
sys_guid(),
1,
'52741', <----- newly created role_mbr_id
'30',
'28', <----- attr_defn_id for Accounting Line Override Code
'NONE'); <----- actual value for Accounting Line Override
commit;
4. Insert entry into the KRIM_ROLS_RSP_ACTN_T.
insert into KR_SUP.KRIM_ROLE_RSP_ACTN_T
(role_rsp_actn_id,
obj_id,
ver_nbr,
actn_typ_cd,
actn_plcy_cd,
role_mbr_id,
role_rsp_id,
frc_actn)
values (kr_SUP.KRIM_ROLE_RSP_ACTN_ID_S.nextVal,
sys_guid(),
1,
'A', <----- Approve (the document)
'F', <----- First (person to act on the document)
'52741', <----- newly created role_mbr_id
'*',
'Y'); <----- Must be approved even if initiator is within the group
commit;
5. Review Role to validate that entries are as expected:
Related articles
...