My Oracle Support Banner

Download Attachments Completed With Error JBO-29000 (Doc ID 2575296.1)

Last updated on AUGUST 19, 2019

Applies to:

Oracle Fusion Product Hub Cloud Service - Version 11.13.19.04.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.13.19.04.0 version, Item Management

Download Item Attachments program errored for All Level and Single Level

ERROR
-----------------------
JBO-29000: Unexpected exception caught: oracle.jbo.SQLStmtException, msg=JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (with expl as (SELECT itms.ITEM_NUMBER PARENT_NUMBER,
 SYS_CONNECT_BY_PATH(itms.ITEM_NUMBER, '/')
 CONNECTION_PATH,


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

In Product Development >Manage Items > Search Item. Select Structure. Actions > Download Attachments > All Level OR Single Level


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!


In this Document
Symptoms
Changes
Cause
Solution
References


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