My Oracle Support Banner

Error when Exporting to Excel from Manage Items Search Results (Doc ID 2544652.1)

Last updated on NOVEMBER 18, 2019

Applies to:

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

Symptoms

On : 11.13.19.01.0 version, Item Management

Error when exporting Item list

User performs a search on Manage Items UI based on a combination of normal attribute and EFF attribute.

Query returns rows, the user selects "Export to Excel" option, the excel file output does not download the records, instead it contains the following error:



ERROR
-----------------------
  Export is incomplete due to error JBO-27122: SQL error during statement preparation ...


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
- Go to PIM-> Manage Items
- Input search criteria
- When Search is complete, click Export to Excel
- Open Excel File and notice there is an error (see attachment)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot review multiple items through the Manage Items UI.

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