INVIRCAT_XML Item Categories Report XML Performance Issue (Doc ID 1969807.1)

Last updated on JUNE 06, 2017

Applies to:

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

Symptoms

ACTUAL BEHAVIOR
---------------
The XML version of the Item Categories report, INVIRCAT_XML, runs for 24 hours to complete for all items 600 pages. It does NOT fail with any output post processor errors, just takes an unacceptably long time to complete.

EXPECTED BEHAVIOR
-----------------------
Expect Item Categories report to complete in a timely fashion, no matter if character or XML versions.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run XML version of the Item Categories report for all items.
2. Observe it takes 24 hours to complete, but does complete.
3. Run XML version of the Item Categories report for a small number of items.
4. Observe the report completes in minutes.

Cause

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