My Oracle Support Banner

Performance Issue Bill Of Material Loop Report (BOMRBOMS) Completing Too Slow After R12 Upgrade (Doc ID 1518823.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms

The BOM Loop report runs too slow for all items and does not completed.
In R12 is has run for as long as 64 hours without completing. DBA had to manually terminate.

What is working
In R12, for one or a few items, the report runs very fast in seconds.
In 11.5.10 it completed in less than 5 minutes for the same results taking 64+ hours in R12.

Expected Behavior
Expect the report to run in 5 minutes on R12.

Sample Counts

Steps
1. Bills > Reports > Loop report
2. Runs for 60+ hours.

Changes

Upgraded from R11i (where the report worked fast) to R12 (where the report is slow).

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


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.