My Oracle Support Banner

JBO Error Occurs When Import Subinventory And Locators Using FSM Template (Doc ID 2661965.1)

Last updated on AUGUST 23, 2023

Applies to:

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


When attempting to import CSV for Manage Sub inventory and Locators using FSM Template with changing just INV_ITEM_SUBINVENTORY.csv, JBO error occurs in Business object: Subinventory/Detail Object: ItemSubinventoryIE.


Business object: Subinventory. Status: In progress. Status details:
Detail Object: ItemSubinventoryIE. Status: Completed with errors. Status Details: A total of 2,259 rows were processed. 2,259 rows of them failed and 0 rows completed with warnings.. Started: 4/21/20 7:44 AM. Ended: 4/21/20 7:46 AM.
Row Identifier: 100000004769190 300000002485005 null. Status: Error. Message Code: FND_CMN_INVALID_ATTRB_API_SERV. Severity: . Message Text: The value of the attribute Subinventory isn't valid.
The data row can be found in batch file ItemSubinventoryIE/ Cause: Action:

JBO-25026: Row oracle.jbo.Key[100000004769190 300000002485005 null ] with XML tag ItemSubinventoryVORow cannot be loaded.JBO-27024: Failed to validate a row with key oracle.jbo.Key[300000002485005 null 100000004769190 ] in ItemSubinventoryEOJBO-27014: Attribute SecondaryInventory in ItemSubinventoryEO is required.JBO-FND:::FND_CMN_INVALID_ATTRB_API_SERV: The value of the attribute Subinventory isn't valid.JBO-29000: Unexpected exception caught: java.lang.NullPointerException, msg=Cannot get property 'PlanningLevel' on null object: Cannot get property 'PlanningLevel' on null objectJBO-27014: Attribute SecondaryInventory in ItemSubinventoryEO is required.

The issue can be reproduced at will with the following steps:
1. Setup: Manufacturing and Supply Chain Material Management
2. Inventory Management > Manage Subinventory and Locations > Action > Export CSV Files > Create New
3. Download CSV files
5. Change anything the file and save it
6. Manage Subinventory and Locations > Action > Import from CSV Files > Create New
7. Upload zip file include saved INV_ITEM_SUBINVENTORY.csv

The issue has the following business impact:
Due to this issue, users cannot Load Subinventory And Locators Using FSM Template


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

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