Bom Explosion Error In Product Workbench JBO-27122 BOM_EXPLOSIONS_V ORA-00904 Invalid Identifier

(Doc ID 2400724.1)

Last updated on MAY 18, 2018

Applies to:

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


On : 12.2.6 version, Integrated Bills of Material

Getting error while viewing the BOM Structure in Product Workbench with personalized display format


JBO-27122:SQL error during statement preparation. Statement: SELECT * FROM (SELECT *
FROM ( SELECT bom_explosions_v.USER_ITEM_TYPE TYPE ,
## Detail 0 ##
java.sql.SQLSyntaxErrorException: ORA-00904:
"OVREXTTABLE1"."C_EXT_ATTR1": invalid identifier

The issue can be reproduced at will with the following steps:
1. Navigate: Development Manager > Launch Product Workbench
2. Double click to open structure page for item 54321
3. Get the Explode Structure 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