My Oracle Support Banner

Whenever I Am Doing Locator Upload Through Excel, It Is Giving Error Of Locked Cells Although The Ex (Doc ID 2566647.1)

Last updated on AUGUST 01, 2019

Applies to:

Oracle Fusion Inventory Management Cloud Service - Version 11.13.19.04.0 and later
Oracle Fusion Inventory Management - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

Locator import through FSM using csv upload on task 'Manage Subinventories and Locators" is ending in an error.
The issue reported is dbms_lock.request error but the actual errors seen in the database and logfiles uploaded
differs.

ERROR
-----------------------
JBO-25026: Row oracle.jbo.Key[CHEM-WHS 300000262133985 ] with XML tag InventorySubinventoryVORow cannot be loaded.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000262133985 CHEM-WHS ] in InventorySubinventoryEOJBO-FND:::FND_VS_VAL_NOT_IN_LIST: Discipline CHEMICAL is not in the list of values.
JBO-25026: Row oracle.jbo.Key[300000262536420 ] with XML tag InventoryLocatorVORow cannot be loaded.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000262537193 ] in InventoryLocatorEOJBO-INV:::INV_BKND_SUBLOC_INVALID_SUB: INV-2416388The subinventory DMM-DOE cannot be edited as it does not exist.JBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=Cannot get property 'SubinventoryType' on null object: Cannot get property 'SubinventoryType' on null objectJBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=Cannot get property 'SubinventoryType' on null object: Cannot get property 'SubinventoryType' on null object

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Setup and Maintenance > Manufacturing and Supply Chain Materials Management > Inventory Management > Manage Subinventories and Locators
2. Actions -> Export
2. Unzip the file
3. Provide the subinventories and locators to be uploaded for an inventory organization.
4. Actions -> Import
5. The program fails with error, with following in the logfle.


Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.