Trying to run the MCI upload process results in an error:
ORA-01422: exact fetch returns more than requested number of rows.
1. Have a look at the shapefile you are trying to upload and note the values in the [OWNER] field.
Then start a sqlplus session and run the following statement for each owner (in this example OWNER is PKV)
select * from hig_users where hus_initials='PKV';
The above statement should return a single record each time. If it doesn't, that means you have users with the same initials. Initials must be unique in the system for mapcapture as this is what is used to determine which user uploads/downloads
Change the initials for each user so they are unique across the system.
2. If the details appear correct (as per point 1.), the other may be the file name. Check the upload logs to verify if an attempt to load the file has been made more than once. If this is the case, the file will need to be loaded with a different name.