R12.2.4 Performance Issue Resource Where Used Report -XML Format (BOMRWURS)

(Doc ID 2359310.1)

Last updated on FEBRUARY 22, 2018

Applies to:

Oracle Bills of Material - Version 12.2.4 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR

Performance issue in the report Resource Where Used Report (XML).The report runs for more than 24hours and has to be cancelled.
Issue exists only for the XML format , non xml report completes in few minutes.

EXPECTED BEHAVIOR

The report should complete in few minutes(not more than 1 or 2 minutes)

STEPS
The issue can be reproduced at will with the following steps:
Run the concurrent request "Resource Where Used Report (XML)"

BUSINESS IMPACT
The issue has the following business impact:
Users need only the XML format for ease of use ,this issue causes delays in daily business.

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