If any errors are encountered while loading UKPMS data using Inventory Loaders it might sometimes be necessary to clear the temporary tables to be able to re-try the load.
Run the CLEANRUN script in SQL*Plus logged on as a user doing the load. You can download it here.
Run MAICLINV which can be run through FastPath in your system. Do that when logged on as a user doing the load.
If it is not there please install it by running maiclinv_metadata.sql in SQL*Plus to create the GRI metadata and place the maiclinv.sql into the exor/bin directory on the application server.
Download maiclinv_metadata.sql here.
Download maiclinv.sql here.