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 MAY 24, 2016

Applies to:

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

Symptoms

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:


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.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms