BOM EGO Structure Bulkload Via Excel SpreadSheet Not Working with Error ORA-00904: "STRUCTURE_TYPE_ID": invalid identifier
Last updated on MAY 02, 2018
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.
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