Tuesday, 24 October 2017

Importing Sub-Inventories, Locators in Oracle Fusion.



Step 1: Navigate to Setup and Maintenance Work Area and Select the ‘Manufacturing and Supply Chain Materials Management Offering click the ‘Setup’ button


Step 2: Select the Functional Area ‘Inventory Management’ -> Click the ‘View’ menu ‘Columns’ -> Enable Checkbox ‘Actions’

Step 3: You will now see the ‘Actions’ icon displayed as a column. Click the ‘Actions’ icon for Task: Manage Subinventories and Locators -> Click ‘Export to CSV File’ -> Click ‘Create New’

Step 4: Click the ‘Submit’ button on the Export Setup Data to CSV File. Click the ‘OK’ button on the Confirmation dialog window

Step 5: Review the Export to CSV file by clicking ‘Actions’ -> ‘Export to CSV File’ -> ‘Ready for warning review 8-Nov-2015. A warning will be reported, however, you will be able to complete the item to subinventory assignment process.
 

Step 6: Click ‘Actions’ -> ‘Download’ -> ‘CSV File Package’
 

Step 7: Save File to local directory


Step 8: Extract the file ‘INV_ITEM_SUBINVENTORY.csv’ from the zip file to add item subinventory records


Step 9: Edit the INV_ITEM_SUBINVENTORY.csv file by adding the new records. In the screen shot below the records in green already existed and new records in yellow have been added to the CSV file.

Step 10: Add the edited file INV_ITEM_SUBINVENTORY.csv back to the zip file

Step 11: Navigate back to the main page and click the ‘Actions’ icon -> ‘Import from CSV File’ -> ‘Create New’


Step 12: Browse for your zip file and click the ‘Submit’ button

Step 13: Review the Import to CSV Process
 

Step 14: Process has been Completed Successfully. Click the ‘Done’ button
 

Step 15: Confirm the Item Subinventory records have been successfully created. Click the task link ‘Manage Subinventories and Locators’
 
 Step 16: the newly created records.
 

2 comments: