A Notification will generally include 3 Objects that are tied together. This includes:
1) A Notification Object
2) A User Group Object (Notifiation is assigned to this User Group)
3) A Message Template Object (Message Template is assigned to Notification and also assigned to this User Group)
When importing a Notification, a User Group (ie USER_GROUP_TEST), and a Message Template (ie TEMPLATE1-TEST) that does NOT exist, the below error occurs
ORA-20025: No role access to " role USER_GROUP_TEST in get_role_seq_aw when
add_obj_roles "
ORA-06512: at "APPMGR.AWAPI2", line 487
ORA-06512: at "APPMGR.AWAPI2", line 1000
If User Group USER_GROUP_TEST is created manually and then Import re-attempt is made, the following error is seen.
ERROR at line 1:
ORA-20024: No such (get_object_seq_aw)Message Template as "TEMPLATE1-TEST"
rtype=m edit=N my_dba=Y my useq=1*-5-7-9-10
ORA-06512: at "APPMGR.AWAPI2", line 487
If an empty message template TEMPLATE1-TEST is created manually, then Import re-attempt is made, the IMPORT is successful.
Release : 9.3
Component : APPLICATIONS MANAGER
The import process imports objects types in the wrong order.
This is fixed in Applications Manager 9.3.5.