My Oracle Support Banner

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.

Symptoms

On : 12.2.6 version, Integrated Bills of Material

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

Error

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

STEPS
-----------------------
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


Changes

 

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!


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