Automation to Load Mass Data - Upload Item costs
Below is the requirement and the data entry task we are currently doing manually and looking for any possible way of automated data load.
SLS is using the Cost plus pricing feature, and the cost is not from the cost accounting application because they have to maintain different contract prices and the special pricing from suppliers as per sales channel. All these supplier prices are maintained as a Cost list, from which the list price is calculated as a markup percentage.
Unfortunately, the cost list does not support any mass upload feature (No FBDI, ADfdi, API), and it has been confirmed with Oracle Support/DEV team. We have around 300K rows of items and their cost information to be loaded into the system. And the manual way of adding this list item takes more time and workforce.