INV Stock Locator Upload  Help

INV Stock Locator Upload creates, updates and deletes Oracle Inventory stock locators – the locator combinations within a subinventory – in bulk from Excel. Download the locators in an organization (optionally filtered by subinventory, locator range, type or status), add new ones, edit attributes such as picking and dropping order, capacity, dimensions and coordinates, or flag rows for deletion, then upload.

When to use it

• Mass-create locators for a new or reorganized warehouse or subinventory layout.
• Load many bin, rack or shelf locators that would be tedious to enter in the Stock Locators form.
• Bulk-update locator attributes: picking order, dropping order, capacity (units, weight, volume), dimensions, coordinates, alias or descriptive flexfield values.
• Activate or deactivate locators by setting the inactive date.
• Set a locator’s material status across many locators at once.
• Delete obsolete locators that carry no transaction history.

Before you start

• Blitz Report is installed and you are signed in to an Inventory responsibility with access to the organizations you load.
• The organization has locator control enabled – organizations with locator control “None” have no locators and are not listed.
• The subinventory exists in the organization, and the locator’s segment combination is valid against the Stock Locators flexfield.

Choose a template

The upload offers two templates that differ in how you enter the locator code:

Both create the same locators – pick whichever is easier for your data. The default is Locator by concatenated segment.

Step 1 – Choose a template and mode, set the parameters and download

In Blitz Report, open INV Stock Locator Upload, choose your template, and set the Upload Mode and download filters:

• Create – an empty template for adding new locators.
• Create, Update (default) – downloads existing locators so you can edit them, delete them, or add new rows.

Run the upload to download and open the Excel file. Each row is automatically handled as a create, update or delete, depending on whether the locator already exists and whether you flag it for deletion.

Step 2 – Identify the locator

On each row enter the Organization Code and Subinventory, and the locator itself – as the Concatenated Segments string (in the default template) or across the individual segment columns (in the segments template). The organization, subinventory and segment combination identify the locator and cannot be changed once it exists.

Step 3 – Set attributes, or delete

• Attributes – set the editable fields as needed: Description, Type, Status, Picking Order, Dropping Order, Alias, capacity (Max Units, Max Weight, Max Volume with their units of measure), dimensions, X / Y / Z coordinates, and any descriptive flexfield values.
• Inactive On – set this date to disable the locator (it must be today or later).
• Delete Locator – set this column to Yes to remove an existing locator. Oracle refuses the delete if the locator is referenced by transactions.

Step 4 – Validate and Save

Click Validate and Save. This checks for missing required values and runs any extra validation the upload defines, then saves the file. Correct anything it flags before continuing.

Step 5 – Upload and view the result

Back in Blitz Report, click Upload and select your saved file. This submits the Blitz Upload request, which processes each row independently. When it finishes, a result report opens showing each row as success or error.

What’s produced

• Created, updated or deleted stock locators in the chosen inventory organization.
• A result report listing every row with a status (success or error) and a message – for example “Locator created.”, “Locator updated.”, “No change.”, “Locator deleted.” or a specific validation message.

Common questions

Can I rename a locator or move it to another subinventory?
No. The locator’s organization, subinventory and segment combination are part of its identity and cannot be changed once it exists. To rename, create the new locator and delete the old one (if it has no transactions).

How do I delete a locator?
Download in Create, Update mode, set the Delete Locator column to Yes on the locator’s row, and upload. Oracle rejects the delete if the locator is referenced by transactions – disable it with an inactive date instead.

Why don’t I see all my inventory organizations?
The list shows only organizations your responsibility can access, and only those with locator control enabled. Organizations with locator control “None” never appear because they have no locators.

Which template should I use – concatenated or individual segments?
Whichever is easier for your data. Both create the same locators; they differ only in whether you type the locator as one string or across separate segment columns.

My update row says “No change.” – did anything happen?
No update was needed: none of the editable values differed from what is already stored, so the upload skipped the call. This is normal, not an error.

Troubleshooting