File Upload in R12.1.3
I need to build one customization to massively update Items in Inventory.
In order to do that I have create one custom staging table and a custom package to manipulate data in that staging table and then feed the standard inventory interface tables and use Item Import API.
The problem which I'm having so far is how to populate that table. My idea is to use a Sql Loader concurrent to load data from a flat file to the staging table, but I'm not able to find any functionality to perform the upload the flat file on the server (I don't have to give user the permission to do FTP from their PC).