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 11.13.20.01.0 and later
Oracle Fusion Inventory Management - Version 11.13.20.01.0 and later
Information in this document applies to any platform.

Symptoms

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.

ERROR
-----------------------

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/1_BATCH.zip. 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.




STEPS
-----------------------
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
4. Open INV_ITEM_SUBINVENTORY.csv
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

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

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


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