Skip to main content
Kofax

MarkView Admin - Unable to insert a new role

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