This content has been marked as final. Show 1 reply
Never update data in a table directly ... you could run into support issues with Oracle. Unless you use a public api or interface. Or be 100% that you have validated your data properly before loading i.e. Item codes, are they assigned to the relevant INV org that the subinventory belongs to etc. etc.
For your particular issue you could use a form loader tool such a dataload.net. It is available as a freeware version (classic) that supports loading from spreadsheet to an open form or a professional version where you use a prerecording and 'background' load for more dataintensive requirements. It is still emulating datamanipulation as if it is done through a form.
Using a loader will ensure that your data is validated properly.