My Oracle Support Banner

BOM EGO Structure Bulkload Via Excel SpreadSheet Not Working with Error ORA-00904: "STRUCTURE_TYPE_ID": invalid identifier (Doc ID 1610779.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle Product Hub - Version 12.1.3 and later
Information in this document applies to any platform.


BOM EGO Structure Bulkload via excel spread sheet not working

You are trying to upload BOM (Bills of material) via excel spread sheet via bulk load in PIM (Production information management) is not working.
You exported the spread sheet and filled the data and uploaded. The program completes with warning and error message:

BOMJCP module: Structure Bulkload
Got OAException in createStructure

oracle.apps.fnd.framework.OAException: Application: BOM, Message Name: BOM_VALIDATION_FAILURE. Tokens: ERROR_MESSAGE = Executing - EGO_USER_ATTRS_BULK_PVT.Insert_Default_Val_Rows: ORA-00904: "STRUCTURE_TYPE_ID": invalid identifier;

Steps to produce:
Responsibility: Product Information Data Librarian
Menu: Product Information Data Librarian-> Batch Import -> Import Item -> Import from Excel

Select Object: Structure
Click on Continue
Select structure type: Manufacturing Structure
Structure name: Primary
Import Format: Component Information
Click Import and click next
And click open to import to open the import excel format.

Fill the required data and click on menu Add ins and click on oracle and upload.

This will initiate two programs
1. EGO Spreadsheet Java Concurrent Program
2. Structure Bulkload

Both the programs complete with warning and you see the error.


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.