MarkView Admin - Unable to insert a new role
12048
Summary
12048
Applies To
- ERP System: Oracle
- MarkView Version: All
Behavior
- The system administrator is unable to add a new role from the screen below:
Go to Markview Home > Administration > Module admin > Organizations > Global Configuration > Role Configuration.
Error on the screen:
'ORA-01403: no data found ORA-06512: at "MARKVIEW.MVOA_ORG", line 81 ORA-06512: at "MARKVIEW.MVERP_ORG_EXT", line 80 ORA-06512: at "MARKVIEW.MVERP_ORG", line 82 ORA-06512: at "MARKVIEW.MVERP_ORG_ROLE_CONFIG_ADMIN", line 549 ORA-01403: no data found ORA-06512: at "MARKVIEW.MVOA_ORG", line 81 ORA-06512: at "MARKVIEW.MVERP_ORG_EXT", line 80 ORA-06512: at "MARKVIEW.MVERP_ORG", line 82 ORA-06512: at "MARKVIEW.MVERP_ORG_ROLE_CONFIG_ADMIN", line 549 ORA-06512: at "MARKVIEW.MVERP_ORG_ROLE_CONFIG_ADMIN"
Known Causes
- The organization names in MarkView ( table: mvt_org ) don’t match the ones in Oracle ERP ( table: hr_operating_units).
Resolution
- The following script will list all Orgs configured in Markview, and will show blank values for ou.organization_id and ou.name where the Org name in MarkView doesn’t match the Org name in Oracle ERP.
select o.org_id, o.org_name, ou.organization_id, ou.name from mvt_org o, hr_operating_units ou where o.org_name=ou.name(+);
- If the organization names are different ,the resolution is to update the organization names in table mvt_org to match the names in table: hr_operating_units.
Example:
update mvt_org
set org_name = '&value_from_hr_operating_units'
where org_name = '&value_from_mvt_org';
commit;
Keywords: Role, no data found